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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Morgan, Juan, C,1882191.970.000.000.0091.97
Richardson, Lauren, C,14867839.480.000.000.00839.48
Stewart, Garrett, O,15762564.480.000.000.00564.48
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Brown, Benjamin, D,151874725.320.000.000.004725.32
Turner, Kaylee, M,16213154.540.000.000.00154.54
King, Gabrielle,263504.990.000.000.004.99
Foster, Jessica,2606951.460.000.0051.460.00
Reed, Sean, L,145974803.310.000.000.004803.31
Martin, Nicholas,233627.280.000.000.007.28
Washington, Miranda,152014793.020.000.000.004793.02
Wilson, Eduardo,15323804.470.000.000.00804.47
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Perez, Amber, D,13318214.260.000.00116.9197.35
Carter, Jason,11724210.090.000.00113.8696.23
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Harris, Edward,27062782.990.000.00782.990.00
Yang, Jordan, K,14458133.950.000.000.00133.95
Cooper, Timothy, J,206513198.570.000.002049.101149.47
White, Emma, N,16090604.960.000.000.00604.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Robinson, Emily,12183228.420.000.0054.96173.46
Nelson, Jennifer,171471700.990.000.000.001700.99
Bailey, Lauren,15864103.550.000.000.00103.55
Diaz, Alyssa,139084715.330.000.000.004715.33
Sharma, Samuel,27725119.980.000.000.00119.98
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Hall, Natalie, A,230704.990.000.004.990.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Flores, Arianna,217274132.243578.270.000.00553.97
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Hughes, Anna,197052341.970.000.000.002341.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Russell, Elijah, M,118354772.300.000.002319.262453.04
Simmons, Jennifer,112621010.560.000.00207.93802.63
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Hill, Carlos,12919257.880.000.00158.9398.95
Thomas, David,168363193.790.000.000.003193.79
Coleman, Ashley,27297782.990.000.00782.990.00
Reed, Erin, I,14353128.840.000.0074.9853.86
Collins, Luis, J,227655978.610.003578.270.002400.34
Watson, Devin, A,18875114.950.000.000.00114.95
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Stewart, Cindy,14496804.480.000.000.00804.48
Cook, Joan,235544.990.000.000.004.99
Smith, Chloe,17619163.920.000.000.00163.92
Turner, James, E,16841126.960.000.0069.9956.97
Murphy, Richard, M,222994145.540.003578.270.00567.27
Perez, Angel, S,213362628.350.000.002071.42556.93
Price, Caroline,180511735.980.000.000.001735.98
Prasad, Molly,243924329.610.003578.270.00751.34
Cooper, Brian, L,13760128.840.000.000.00128.84
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Walker, Jacob, N,29027574.980.000.000.00574.98
Harris, Natalie,2368259.980.000.0059.980.00
Carter, Jesse, E,22141166.280.000.000.00166.28
Alexander, Gavin, K,2932249.990.000.000.0049.99
Henderson, Austin,2764354.980.000.000.0054.98
Watson, Erin, B,227724.990.000.004.990.00
Lal, Luke, L,11019698.230.000.00139.93558.30
Russell, Melanie, B,15478182.830.000.00167.8514.98
Diaz, Brandon,236764.990.000.004.990.00
Rubio, Kellie,27653128.970.000.000.00128.97
Watson, Emma,17481126.940.000.000.00126.94
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Perez, Savannah, J,17036176.950.000.0056.97119.98
Smith, Lucas, P,1809064.910.000.000.0064.91
Smith, Zachary, W,2378358.980.000.0058.980.00
Sanders, Isaiah,2587339.980.000.000.0039.98
Murphy, Shelby,244894.990.000.000.004.99
Diaz, Luis, D,11203801.770.000.00183.97617.80
Madan, Carmen, V,155674720.270.000.000.004720.27
Jackson, Charles, P,112771305.660.000.00237.821067.84
Shan, Benjamin,235663578.270.003578.270.000.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Rogers, Sara,198744544.450.003374.990.001169.46
Martin, Christian, V,19709197.250.000.000.00197.25
Rodriguez, Taylor,1607166.960.000.000.0066.96
Harris, Isabella,17119214.900.000.0077.96136.94
Richardson, Evan, J,15488165.300.000.000.00165.30
Adams, Hailey, M,121544798.530.000.002379.472419.06
Scott, Adam,15863243.010.000.000.00243.01
White, Nicole,16731155.910.000.0084.9670.95
Taylor, Madison, A,11802215.290.000.00127.9687.33
Taylor, Victoria,260132443.350.000.002443.350.00
She, Martha, E,222515971.330.003578.270.002393.06
Zhang, Robert,188551155.480.000.000.001155.48
Griffin, Melissa, L,287807.950.000.000.007.95
Washington, Christian, R,2668639.980.000.000.0039.98
Long, Gavin,13762186.030.000.000.00186.03
Rivera, Rachel, S,2899678.980.000.000.0078.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
Hill, Sydney,264821000.440.000.001000.440.00
Roberts, Jordan, M,1680039.250.000.000.0039.25
Lal, Robert, L,14084138.680.000.000.00138.68
Clark, William,2902169.990.000.000.0069.99
Yuan, Carly,19839194.960.000.000.00194.96
Clark, Emily, R,120862294.990.000.000.002294.99
Howard, Brianna, D,246304.990.000.000.004.99
Long, Julia, R,228895971.330.003578.270.002393.06
Harris, Jacob, G,2367939.980.000.0039.980.00
Robinson, Dylan, L,1472481.530.000.000.0081.53
Yang, Aaron, C,2519654.980.000.000.0054.98
Nelson, Adam, B,27402128.970.000.000.00128.97
Price, Marissa,15826160.740.000.00120.4840.26
Chen, Luis, G,2125294.450.000.0094.450.00
Flores, Brandon, L,2562189.970.000.000.0089.97
Turner, Jose,11784272.690.000.000.00272.69
Hayes, Jason,261764.990.000.000.004.99
Hall, Luke, E,14745902.460.000.000.00902.46
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Prasad, Donald,15413318.920.000.00123.98194.94
Flores, Devin, A,15559172.040.000.0086.5685.48
Harris, Destiny, M,137102341.460.000.000.002341.46
Morgan, Jada, A,11520702.990.000.00137.45565.54
Lu, Alejandro,2562039.980.000.000.0039.98
Walker, Hunter,271007.280.000.000.007.28
Young, Adam,12984200.200.000.00107.2692.94
Wright, Kyle,2371626.970.000.000.0026.97
Evans, Jesse,2191639.980.000.000.0039.98
He, Micah,2740169.990.000.000.0069.99
Baker, Gabriella,174041709.980.000.000.001709.98
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Roberts, Wyatt,15900699.970.000.00699.970.00
Howard, Alexandra,207363194.580.000.002049.101145.48
Butler, Jonathan,261804.990.000.000.004.99
Martin, Xavier,222335997.330.003578.270.002419.06
Flores, Stephanie,259922721.550.000.002181.56539.99
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Smith, Nathan,217647.280.000.007.280.00
Anderson, Jasmine, A,235534.990.000.000.004.99
Simmons, Anna, K,124512367.920.000.000.002367.92
Barnes, Blake, A,178651789.970.000.000.001789.97
Blue, Paige,2170313.980.000.000.0013.98
Sanchez, Shelby,16021539.990.000.000.00539.99
Mitchell, Caleb, K,268064.990.000.000.004.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Russell, Rachel, C,2158124.270.000.0024.270.00
Moore, Matthew, W,13267109.950.000.000.00109.95
Foster, Aaron,155664912.470.000.000.004912.47
Johnson, Edward, H,23279124.990.000.000.00124.99
Hall, Taylor, J,169951735.980.000.000.001735.98
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Martin, Noah, A,1765775.970.000.0075.970.00
Edwards, Elijah, D,281577.280.000.000.007.28
Cox, Katelyn, B,2174230.970.000.000.0030.97
Powell, Caleb, G,216132610.580.000.002049.10561.48
Flores, Miguel,1975077.250.000.000.0077.25
Butler, Cassidy, L,21792114.460.000.000.00114.46
Allen, Aaron, A,200753399.990.003399.990.000.00
Chow, Candice,1923260.960.000.000.0060.96
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Gray, Brianna,249603008.820.002443.35565.470.00
Lewis, Christopher,1875586.960.000.0056.9729.99
Zhang, Nathan, L,2910478.980.000.000.0078.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Martinez, Jill,242354829.390.003578.270.001251.12
Hall, Eduardo,16847189.940.000.000.00189.94
Green, Xavier,2356739.980.000.000.0039.98
Walker, Isabella,243864143.740.003578.27565.470.00
Allen, Angel, G,15571101.850.000.0034.8966.96
Gonzales, Miranda,11660324.720.000.000.00324.72
Davis, Ethan,136604750.010.000.000.004750.01
Perez, Jordan, A,292674.990.000.000.004.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Russell, Ian, T,2474613.980.000.0013.980.00
Hughes, Miranda,266784.990.000.000.004.99
Diaz, Thomas, O,16020595.960.000.000.00595.96
Perez, Jonathan, R,2345512.940.000.000.0012.94
Henderson, Olivia,188591155.480.000.000.001155.48
Diaz, Faith, M,2236356.970.000.000.0056.97
Barnes, Dalton, C,178581700.990.000.000.001700.99
Zhao, Clarence, R,1982671.970.000.0071.970.00
Cooper, Ariana,17348205.420.000.000.00205.42
Phillips, Jack, R,259952443.350.000.002443.350.00
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Bell, Eduardo,27101782.990.000.00782.990.00
Raje, Mindy, A,16083561.970.000.000.00561.97
Moore, Hunter,14897196.270.000.0071.58124.69
Peterson, Mason, A,185701174.480.000.001174.480.00
Griffin, Haley, L,1892582.180.000.000.0082.18
Lal, Jack, R,185251735.980.000.000.001735.98
Flores, Jordyn,252882721.550.002181.560.00539.99
Green, Chloe, J,1465892.820.000.000.0092.82
Gonzalez, Morgan,130651700.990.000.000.001700.99
Nelson, Kevin,1476584.970.000.000.0084.97
Powell, Vanessa,26630699.100.00699.100.000.00
Davis, Dylan,15556588.960.000.00588.960.00
Long, Elizabeth, F,127822400.950.000.000.002400.95
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Richardson, Melissa, E,111322371.940.000.000.002371.94
Hall, Charles,234764.990.000.000.004.99
Ross, Haley, T,253612443.350.002443.350.000.00
Parker, Caleb, A,2631813.980.000.000.0013.98
Nath, Yolanda, A,2462513.980.000.000.0013.98
Rivera, Sara,187852350.960.000.000.002350.96
King, Jordan, C,110202316.970.000.002316.970.00
Morris, Mason, J,22349124.990.000.000.00124.99
Moore, Jessica, J,2008576.760.000.000.0076.76
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Brown, Isabella, L,266921266.860.00699.100.00567.76
Young, Kaylee, S,13756298.490.000.0058.47240.02
Peterson, Isabella,2808039.980.000.0039.980.00
Powell, Jack, J,1841156.960.000.000.0056.96
Washington, Lauren, R,229985329.250.003578.271750.980.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
She, Alisha, G,247574343.590.003578.270.00765.32
Evans, Gabriel,2348789.970.000.000.0089.97
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Flores, Julia, E,172631700.990.000.000.001700.99
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Taylor, Edward, C,17442319.880.000.00230.9088.98
Jai, Kevin,1983678.960.000.0038.9839.98
Thompson, Kayla, D,12363273.900.000.000.00273.90
Zeng, Jake,18054106.930.000.000.00106.93
Bradley, Melanie, G,133434720.270.000.000.004720.27
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Bailey, Hailey, R,262704.990.000.000.004.99
Garcia, Jonathan,1888386.960.000.0029.9956.97
Garcia, Victoria, V,245013578.270.003578.270.000.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Davis, Richard, R,15549574.980.000.00574.980.00
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Sanders, Zoe, L,248254.990.000.000.004.99
Mitchell, Bailey, B,267067.280.000.007.280.00
Thompson, Abigail,243324816.090.003578.270.001237.82
Perry, Dalton, A,16149192.040.000.000.00192.04
Ross, Alexia, S,13231247.900.000.000.00247.90
Cooper, Brooke,195361120.490.000.000.001120.49
Blanco, Armando, F,139182397.950.000.000.002397.95
Robinson, Sarah, A,2702859.980.000.000.0059.98
Peterson, Morgan, J,168341750.980.000.000.001750.98
Henderson, Luke,19200109.240.000.000.00109.24
Foster, Samuel, M,18523160.940.000.00128.9731.97
Sanchez, Alex, K,131014736.030.000.000.004736.03
Rodriguez, Natalie,2077330.970.000.000.0030.97
Martin, Joshua, A,276077.280.000.007.280.00
Turner, Morgan,11823178.470.000.000.00178.47
Perry, Brandon,22095141.980.000.000.00141.98
Chen, Jackson, S,270751371.950.00782.990.00588.96
Allen, Luke,113162349.980.000.002349.980.00
Green, Mackenzie, C,280737.280.000.000.007.28
Ross, Kaitlyn,16121614.470.000.000.00614.47
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Ross, Miranda,145984839.000.000.000.004839.00
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Peterson, Julia, P,16497132.710.000.000.00132.71
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Sanders, Sean,14341175.150.000.000.00175.15

Generated 2025-11-04 04:30:50.611 UTC