[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   SKIP 125   <  SKIP 1000  >   <  TAKE 500  >   

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Nelson, Adam, B,27402128.970.000.000.00128.97
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Hughes, Samantha,2721564.470.000.000.0064.47
Hughes, Zachary,12203157.910.000.000.00157.91
Miller, Chloe, V,228936056.510.003578.272478.240.00
Yang, Thomas, A,14108839.480.000.000.00839.48
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Richardson, Melissa, E,111322371.940.000.000.002371.94
Henderson, Caroline,2008256.970.000.000.0056.97
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Powell, Jonathan,238584712.740.003578.271134.470.00
Diaz, Luke,12054402.530.000.00139.97262.56
Shan, Benjamin,235663578.270.003578.270.000.00
Bennett, Maria, G,229837.280.000.000.007.28
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Thomas, Edward, E,19147133.710.000.000.00133.71
McDonald, Aaron, J,27734119.980.000.000.00119.98
Gray, Jared, A,264494.990.000.000.004.99
Srini, Ruben,18078200.940.000.000.00200.94
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Mehta, Carmen, C,2743694.480.000.000.0094.48
Young, Jenna, W,163652490.180.000.000.002490.18
Alexander, Caroline,176541759.970.000.000.001759.97
Sanchez, Grace,120802354.990.000.000.002354.99
Johnson, Jonathan,220597.280.000.000.007.28
White, James,253317.280.000.000.007.28
Gonzalez, Morgan,130651700.990.000.000.001700.99
Flores, Gabriel,271117.280.000.000.007.28
Howard, Alyssa, A,11513863.950.000.000.00863.95
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Hannah,1952540.230.000.000.0040.23
Edwards, Elijah, D,281577.280.000.000.007.28
Evans, Elijah, S,2588439.980.000.000.0039.98
Ward, Mariah, J,2158044.910.000.000.0044.91
Sanchez, Stephanie,1786756.970.000.000.0056.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Hall, Taylor, J,169951735.980.000.000.001735.98
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Green, Xavier,2356739.980.000.000.0039.98
Hall, Eduardo,16847189.940.000.000.00189.94
Wang, Karen, P,1955331.970.000.000.0031.97
Chen, Jack, E,17579151.430.000.000.00151.43
Campbell, Angel, D,195461174.480.000.000.001174.48
Walker, Destiny, M,169961754.980.000.000.001754.98
Alvarez, Melody,2507068.490.000.000.0068.49
Roberts, Jordan, M,1680039.250.000.000.0039.25
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Stewart, Melissa,2517336.960.000.000.0036.96
Henderson, Olivia,188591155.480.000.000.001155.48
James, Morgan, E,2324539.980.000.000.0039.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Garcia, Patricia,11651226.430.000.0099.97126.46
Bailey, Maria, C,1915034.980.000.000.0034.98
Sharma, Samuel,27725119.980.000.000.00119.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Williams, Ethan,243094793.120.003578.270.001214.85
Martin, Tyler, L,2772469.990.000.000.0069.99
Jones, Madison,246614181.760.003578.27603.490.00
Rivera, Hailey, R,2079239.980.000.000.0039.98
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Alexander, Angelica,2271471.950.000.000.0071.95
Turner, Blake,12136131.740.000.000.00131.74
Davis, Jonathan,2925913.980.000.000.0013.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Yuan, Brendan, S,247444.990.000.000.004.99
Lopez, Carlos,186171147.770.000.000.001147.77
Hall, Jason, A,29351119.980.000.000.00119.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Henderson, Austin,2764354.980.000.000.0054.98
Garcia, Victoria, V,245013578.270.003578.270.000.00
Thompson, Madison, L,187882351.960.000.000.002351.96
Washington, Ian, M,246644368.580.003578.270.00790.31
Alexander, Sarah,1941129.990.000.000.0029.99
Hayes, Austin,202083219.580.002049.100.001170.48
Blue, Melanie, L,178611749.960.000.000.001749.96
Cook, Megan, J,2029956.970.000.000.0056.97
Rivera, Amanda,11131115.920.000.000.00115.92
Cooper, Stephanie,249762181.560.002181.560.000.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Watson, Olivia, S,1386093.850.000.0014.9878.87
Sánchez, Angela, C,176551750.980.000.000.001750.98
Reed, Judith, D,2534759.980.000.000.0059.98
Bradley, Rachel,158504813.040.000.000.004813.04
Russell, Megan,16220562.960.000.000.00562.96
Hayes, Dalton, C,188822322.280.000.000.002322.28
Hughes, Julia,250612443.350.002443.350.000.00
Adams, Julia, N,2607359.980.000.000.0059.98
White, Jennifer, S,27027782.990.00782.990.000.00
James, Julia,2497567.930.000.000.0067.93
Thomas, Emily,2180339.980.000.000.0039.98
Johnson, Jacob, I,28069553.970.000.000.00553.97
Price, Stephanie,258922443.350.002443.350.000.00
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Jenkins, Megan, R,12074261.380.000.000.00261.38
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Gomez, Renee, L,253712181.560.002181.560.000.00
Rivera, Sara,187852350.960.000.000.002350.96
Murphy, Dalton, N,27043782.990.00782.990.000.00
Butler, Cassidy, L,21792114.460.000.000.00114.46
Washington, Elijah, L,250164.990.000.000.004.99
Turner, Eduardo,158764789.020.000.000.004789.02
Price, Jocelyn, D,258752443.350.002443.350.000.00
Nath, Alison, J,171161764.960.000.000.001764.96
Walker, Emma, M,2520998.960.000.000.0098.96
Cox, Lucas, J,253932443.350.002443.350.000.00
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Chen, Jackson, S,270751371.950.00782.990.00588.96
Yuan, Carly,19839194.960.000.000.00194.96
Russell, Fernando,27084782.990.000.00782.990.00
Powell, Lauren, E,1966275.970.000.000.0075.97
Gonzales, Luis,15856116.250.000.0037.2778.98
Lopez, Jack, I,2904751.460.000.000.0051.46
Powell, Blake, J,2237139.980.000.000.0039.98
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
Washington, Miranda,152014793.020.000.000.004793.02
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Martinez, Matthew, L,16009170.450.000.000.00170.45
Stewart, Grace, H,247737.280.000.000.007.28
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Brooks, Bryce,12061140.170.000.00112.2527.92
Taylor, Zachary, M,27082782.990.000.00782.990.00
Griffin, Cassidy,264961000.440.000.001000.440.00
Bell, Eduardo,27101782.990.000.00782.990.00
Miller, Katherine, B,27102782.990.000.00782.990.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Thompson, Joshua, F,259992181.560.000.002181.560.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
Jai, Connor, D,27253782.990.000.00782.990.00
James, Timothy,213312670.890.000.002670.890.00
Davis, Emily,27267782.990.000.00782.990.00
Jones, Zachary, J,27285782.990.000.00782.990.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Coleman, Vanessa,215892589.090.000.002049.10539.99
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Hall, Kyle, J,1749169.970.000.000.0069.97
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Smith, Lucas, P,1809064.910.000.000.0064.91
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Moore, Ian, L,2463939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Price, Caroline,180511735.980.000.000.001735.98
Foster, Abigail,1982346.470.000.000.0046.47
Collins, Jonathan,16849119.980.000.000.00119.98
Mitchell, Evan, R,247314.990.000.000.004.99
Li, Rafael, M,217527.280.000.000.007.28
Jones, Alexandra, B,2020245.950.000.000.0045.95
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Perry, James,192051249.840.000.000.001249.84
Gray, Sebastian, B,138782366.960.000.000.002366.96
Walker, Jacob, N,29027574.980.000.000.00574.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Foster, Nicole, A,2349489.970.000.000.0089.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Alexander, Gavin, K,2932249.990.000.000.0049.99
Jones, Alexander, I,2002180.960.000.000.0080.96
Li, Brandon,2933973.960.000.000.0073.96
Ramirez, Emma,29072128.970.000.000.00128.97
Campbell, Timothy,2584513.980.000.000.0013.98
Williams, Joshua,260514.990.000.000.004.99
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Bell, Julia,216522646.060.000.002646.060.00
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Carter, Elijah,216182611.070.000.002611.070.00
Powell, David, W,266151000.440.000.001000.440.00
Garcia, Lucas,27545782.990.000.00782.990.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Watson, Janet, S,2320859.980.000.000.0059.98
Clark, William,2902169.990.000.000.0069.99
Butler, Benjamin, C,189722369.970.000.000.002369.97
Martin, Samuel,15874225.440.000.0069.99155.45
Lee, Ian,19646197.040.000.000.00197.04
Alexander, Thomas,207607.280.000.000.007.28
Cox, Katelyn, B,2174230.970.000.000.0030.97
He, Micah,2740169.990.000.000.0069.99
Smith, Samuel, D,2308349.900.000.000.0049.90
Alexander, Luke,290432447.050.000.002447.050.00
Hughes, Isabella,2304851.460.000.000.0051.46
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Campbell, Gabriella,188411145.480.000.000.001145.48
Sanchez, Faith,270494.990.000.000.004.99
Garcia, Isabella,18382204.940.000.000.00204.94
Coleman, Miguel, D,2740069.990.000.0069.990.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Simmons, Dylan,16133107.850.000.0038.8868.97
Hernandez, Jamie,27283119.980.000.00119.980.00
Phillips, Isaiah,28631144.470.000.00144.470.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Harris, Natalie,2368259.980.000.0059.980.00
Roberts, Robert, R,1898656.970.000.0056.970.00
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Rodriguez, Destiny, J,227397.280.000.007.280.00
Hall, Noah, A,1525175.250.000.000.0075.25
Diaz, Thomas, O,16020595.960.000.000.00595.96
Campbell, Alex,119844730.320.000.002329.982400.34
Thompson, Xavier, R,15761192.410.000.000.00192.41
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Johnson, Christopher,119794813.760.000.002352.212461.55
Martinez, Joseph, E,2921459.980.000.0059.980.00
Wu, Randy, J,116472365.940.000.002365.940.00
Nelson, Luis,234884.990.000.000.004.99
Gray, Sara,292472447.050.000.002447.050.00
Wilson, Grace,17539205.920.000.000.00205.92
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Collins, Sierra,185491169.460.000.001169.460.00
Long, Jordyn,1733847.250.000.000.0047.25
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Patterson, Jeremy,130272319.260.000.000.002319.26
Kelly, Trinity,2609515.230.000.000.0015.23
Cooper, Andrea,2932378.980.000.000.0078.98
Moore, Jonathan,2047896.460.000.000.0096.46
Evans, Jesse,2191639.980.000.000.0039.98
Thomas, David,168363193.790.000.000.003193.79
Rodriguez, Julia, A,264884.990.000.004.990.00
Evans, Jordan,2920939.980.000.0039.980.00
Peterson, Christina,2897694.480.000.000.0094.48
Harris, Matthew,14330806.760.000.000.00806.76
Barnes, Emily, G,15996564.990.000.000.00564.99
Thomas, Megan,2907169.990.000.000.0069.99
Ramirez, Richard, C,282397.280.000.007.280.00
Morris, Mason, J,22349124.990.000.000.00124.99
White, Emily, M,159174679.060.000.000.004679.06
Sanders, Allison, B,18852268.250.000.000.00268.25
Foster, Isabel, M,2174571.950.000.000.0071.95
Diaz, Alyssa,139084715.330.000.000.004715.33
Wilson, Daniel, K,142814746.300.000.000.004746.30
Stewart, Sara,17347119.720.000.000.00119.72
Clark, Miguel, D,169872414.990.000.000.002414.99
Robinson, Joseph,2814194.480.000.0094.480.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Walker, Ian,16771104.550.000.0054.5849.97
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Lee, Don,188392384.970.000.000.002384.97
Moore, Seth,138512331.950.000.000.002331.95
Gonzalez, James, M,188421155.480.000.000.001155.48
Perry, Natalie,1712669.990.000.000.0069.99
Rivera, Rachel, S,2899678.980.000.000.0078.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Collins, Jose,2474839.980.000.0039.980.00
Moreno, Marie,2773969.990.000.000.0069.99
Perry, Benjamin,291652407.040.000.002407.040.00
James, Maria,1624391.970.000.0069.9921.98
Bryant, Rachel,220197.280.000.007.280.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Anderson, Daniel,20694146.970.000.00146.970.00
Long, Sydney,279217.280.000.000.007.28
Hayes, Logan, J,19026113.240.000.0037.2775.97
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Murphy, Chase, J,2472958.980.000.000.0058.98
Zhang, Robert,188551155.480.000.000.001155.48
Flores, Madison,14416769.490.000.000.00769.49
Allen, Sean, L,12097159.220.000.000.00159.22
Perry, Justin, E,167583062.340.000.000.003062.34
Williams, Destiny, S,15881564.990.000.00564.990.00
Peterson, Mason, A,185701174.480.000.001174.480.00
Yuan, Leonard, F,167911729.970.000.000.001729.97
Carter, Jesse, E,22141166.280.000.000.00166.28
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Mitchell, Bailey, B,267067.280.000.007.280.00
Sanchez, Jared, J,2585064.470.000.000.0064.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Carter, Isaac,137191129.480.000.000.001129.48
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Blue, Paige,2170313.980.000.000.0013.98
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Anderson, Tyler, E,131481137.430.000.001137.430.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Bryant, Jackson, J,2533239.980.000.000.0039.98
Kumar, Cameron, S,185711120.490.000.001120.490.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Ashe, Alexis, S,194141145.480.000.000.001145.48
Phillips, Aaron, R,2494739.980.000.000.0039.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Powell, Sydney, M,14886539.990.000.000.00539.99
Lewis, Christopher,1875586.960.000.000.0086.96
Washington, Aaron, L,246494.990.000.000.004.99
Hughes, Antonio, P,15913712.270.000.000.00712.27
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Coleman, Dylan,27403132.970.000.000.00132.97
Hill, Katherine, L,2670139.980.000.000.0039.98
Washington, Ryan,2833294.480.000.000.0094.48
Brooks, Steven, C,14877889.470.000.000.00889.47
Coleman, Stephanie,2226489.970.000.000.0089.97
Jackson, Victoria,270194.990.000.000.004.99
Nelson, Henry,193941155.480.000.000.001155.48
Wang, Benjamin, R,274547.280.000.000.007.28
Butler, Jonathan,261804.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Hall, Grace, A,201894.990.000.000.004.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alexander, Julian,132172351.960.000.000.002351.96
Scott, Mason,2355139.980.000.000.0039.98
Lee, Kayla, M,2078115.230.000.000.0015.23
Rogers, Bryce,174022304.980.000.000.002304.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Powell, Ian,2608564.470.000.000.0064.47
Moore, Anthony, M,2473039.980.000.000.0039.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Adams, Mason, T,2052864.470.000.0064.470.00
Gray, Isabella,168203217.790.000.000.003217.79
Washington, Hailey, S,2588559.980.000.000.0059.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Torres, Xavier,16840176.950.000.000.00176.95
Anderson, Jasmine, A,235534.990.000.000.004.99
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Bryant, Dakota, L,176132401.950.000.000.002401.95
Ortega, Sheila, M,2763239.980.000.000.0039.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Stewart, Garrett, O,15762564.480.000.000.00564.48
Foster, Caleb,27112114.460.000.000.00114.46
Sanchez, Shelby,16021539.990.000.000.00539.99
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Perry, Lauren,248164.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Foster, Paige,2742894.480.000.000.0094.48
Nath, Yolanda, A,2462513.980.000.000.0013.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Gray, Marcus, T,183892401.450.000.000.002401.45
Washington, Emma,191231170.480.000.000.001170.48
Martin, Christian, V,19709197.250.000.000.00197.25
Bell, Garrett, J,14265161.230.000.000.00161.23
Price, Rachel, D,2532889.970.000.000.0089.97
Thompson, Lucas, O,212774.990.000.000.004.99
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Wood, Brittany,2877753.990.000.000.0053.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Johnson, Ian, E,2173283.470.000.000.0083.47
White, Emma, N,16090604.960.000.000.00604.96
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Taylor, Marcus, A,18944146.940.000.000.00146.94
Reed, Melanie, A,28160574.980.000.000.00574.98
Edwards, Hailey,242584.990.000.000.004.99
King, Sara,2235439.980.000.000.0039.98
Miller, Jill,129142329.980.000.000.002329.98
Ross, David, M,171431763.970.000.000.001763.97
Foster, Aaron,155664912.470.000.000.004912.47
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Diaz, Trevor, B,2051954.960.000.000.0054.96
Reed, Megan, A,181181750.980.000.000.001750.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Flores, Julian,158464943.320.000.000.004943.32
Russell, Richard,2763322.260.000.000.0022.26
Collins, Allison,28581119.980.000.000.00119.98
Watson, Victoria,16125588.960.000.000.00588.96
Stewart, Gabriella,2803469.990.000.000.0069.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Thomas, Dalton,230097.280.000.000.007.28
Lal, Jack, R,185251735.980.000.000.001735.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Shan, Gabriel, T,2773169.990.000.000.0069.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Reed, Michelle,2804669.990.000.000.0069.99
Johnson, Madison, L,15530846.460.000.000.00846.46
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
_SUM1806517.5065197.22486223.00320298.81934798.47

Generated 2025-11-06 20:14:46.896 UTC