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

227 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Powell, Sydney, M,14886539.990.000.000.00539.99
Davis, Justin,2807412.940.000.000.0012.94
Flores, Madison,14416769.490.000.000.00769.49
Foster, Edward, R,18355150.950.000.000.00150.95
Griffin, Melissa, L,287807.950.000.000.007.95
Yang, Aaron, C,2519654.980.000.000.0054.98
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Howard, Danielle,28357133.490.000.000.00133.49
Ruiz, Philip,1807781.460.000.000.0081.46
Ward, Nicole, L,212724435.380.000.002071.422363.96
Srini, Ruben,18078200.940.000.000.00200.94
Brooks, Evan,2340139.980.000.000.0039.98
Smith, Megan, J,2671668.970.000.000.0068.97
Anderson, David, A,2209761.960.000.000.0061.96
Barnes, Ian, M,16106133.540.000.000.00133.54
Campbell, Gabriella,188411145.480.000.000.001145.48
Perez, Amber, D,13318214.260.000.000.00214.26
Sandberg, Nicole, M,12077144.690.000.0089.4755.22
Howard, Erin, L,183621725.210.000.000.001725.21
Smith, Noah,13175166.920.000.000.00166.92
Long, Gavin,13762186.030.000.000.00186.03
Davis, Thomas,167641760.470.000.000.001760.47
Reed, Paige,221126047.320.003578.270.002469.05
Jones, Natalie, A,11845197.200.000.000.00197.20
Bennett, Antonio, C,11631707.500.000.0020.93686.57
Wilson, Andrew, R,182362414.990.000.000.002414.99
Jai, Adam,250952443.350.002443.350.000.00
Shan, Chad, M,2462112.940.000.000.0012.94
Nelson, Adam, B,27402128.970.000.000.00128.97
Harris, Samuel, M,2477159.980.000.000.0059.98
Blue, Paige,2170313.980.000.000.0013.98
Cooper, Andrea,2932378.980.000.000.0078.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Prasad, Erick, E,28786127.950.000.000.00127.95
Coleman, Joan, W,2669964.470.000.000.0064.47
Walker, Charles,11677298.210.000.000.00298.21
He, Micah,2740169.990.000.000.0069.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Evans, Dalton, E,127104774.040.000.000.004774.04
Martin, Lucas, L,221144183.230.003578.270.00604.96
Ramirez, Richard, C,282397.280.000.000.007.28
Henderson, Luke,19200109.240.000.000.00109.24
Bell, Christina,2609939.980.000.000.0039.98
Jai, Logan, H,12031769.490.000.000.00769.49
White, Emma, N,16090604.960.000.000.00604.96
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Richardson, Victoria, C,248172181.560.002181.560.000.00
Parker, James,11808610.190.000.000.00610.19
Moore, Jennifer, A,2175964.470.000.000.0064.47
Foster, Caleb,27112114.460.000.000.00114.46
Bailey, Olivia,238924.990.000.000.004.99
Russell, Katherine,2877169.990.000.000.0069.99
Bradley, Alexandria,176911779.470.000.000.001779.47
Thompson, Xavier, R,15761192.410.000.000.00192.41
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Reed, Isaac, D,260747.280.000.000.007.28
Garcia, Chloe, M,110372374.230.000.002374.230.00
Wood, Brittany,2877753.990.000.000.0053.99
Martin, Brandon, S,2169139.980.000.000.0039.98
Prasad, Molly,243924329.610.003578.270.00751.34
Green, Chloe, J,1465892.820.000.000.0092.82
Flores, Emma, P,15543180.940.000.000.00180.94
Barnes, Blake, A,178651789.970.000.000.001789.97
Nelson, Katherine,2802178.980.000.000.0078.98
Washington, Alexandra, E,15498256.520.000.000.00256.52
Jenkins, Megan, R,12074261.380.000.000.00261.38
Campbell, Adam, A,214002688.890.000.002071.42617.47
Brown, Fernando,1900191.950.000.000.0091.95
Robinson, William,20103103.480.000.000.00103.48
Clark, Emily, R,120862294.990.000.000.002294.99
Walker, Hunter,271007.280.000.000.007.28
Murphy, Brianna, K,2834269.990.000.000.0069.99
Parker, Jordan,216212616.860.000.002049.10567.76
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Martin, Joshua, A,276077.280.000.000.007.28
Phillips, Mackenzie,12444228.430.000.000.00228.43
Bell, Julia,216522646.060.000.002646.060.00
Sanders, Megan, A,15376136.240.000.000.00136.24
Cooper, Angela,195261179.470.000.000.001179.47
Green, Sophia, E,249772181.560.002181.560.000.00
Davis, Emily,27267782.990.000.00782.990.00
Coleman, Luke, A,11723152.550.000.0039.99112.56
Butler, Trevor,2741569.990.000.0069.990.00
Rogers, Jared, J,12166162.220.000.000.00162.22
Long, Sydney,279217.280.000.000.007.28
Van, Bobby,27757132.970.000.000.00132.97
Cox, Julia, A,206703228.570.000.002049.101179.47
Rodriguez, Julia, A,264884.990.000.000.004.99
Chow, Candice,1923260.960.000.000.0060.96
Campbell, Chloe,11212760.930.000.00124.97635.96
Kelly, Erin, D,2351364.470.000.000.0064.47
Sanders, Allison, B,18852268.250.000.000.00268.25
Prasad, Donald,15413318.920.000.00123.98194.94
Griffin, Jack, L,1768632.280.000.000.0032.28
Russell, Chloe, M,12763589.960.000.000.00589.96
Powell, Lauren, E,1966275.970.000.000.0075.97
Gray, Jesse,14626197.040.000.000.00197.04
Anderson, Madison, G,2835978.980.000.000.0078.98
Perry, Benjamin,291652407.040.000.000.002407.04
Thomas, Matthew, K,13239185.700.000.000.00185.70
Lopez, Bailey, R,185571179.470.000.000.001179.47
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Xu, Louis,2010466.530.000.000.0066.53
Diaz, Elijah,200004495.480.003374.990.001120.49
Reed, Bryan,18884133.930.000.000.00133.93
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Russell, Richard,2763322.260.000.000.0022.26
Parker, Caleb, A,2631813.980.000.000.0013.98
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Green, Gabrielle, M,2181564.470.000.000.0064.47
Evans, Jordan,2920939.980.000.000.0039.98
Sandberg, Chase,2190475.970.000.000.0075.97
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Watson, Richard,15943365.410.000.000.00365.41
Alexander, Edward, E,18524195.950.000.000.00195.95
Evans, Kaylee,19642133.540.000.000.00133.54
Nelson, Jennifer,171471700.990.000.000.001700.99
Torres, Christina, M,20746119.950.000.000.00119.95
Jackson, Charles, P,112771305.660.000.0034.991270.67
Jai, Kevin,1983678.960.000.000.0078.96
Sanders, Alexandra,259112181.560.000.002181.560.00
Morgan, Jada, A,11520702.990.000.000.00702.99
Bradley, Evan,18506101.940.000.000.00101.94
Perry, Natalie,1712669.990.000.000.0069.99
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Chen, Jonathan, G,13096200.690.000.000.00200.69
Ma, Tiffany,2157739.980.000.000.0039.98
Coleman, Jose, S,253494.990.000.000.004.99
King, Gabrielle,263504.990.000.000.004.99
Price, Oscar, G,11833240.010.000.000.00240.01
Sanchez, Stephanie,1786756.970.000.000.0056.97
Madan, Carmen, V,155674720.270.000.000.004720.27
Bailey, Lauren,15864103.550.000.000.00103.55
Ward, Eduardo, I,139162354.980.000.000.002354.98
Miller, Kayla, A,236734.990.000.000.004.99
Hall, Luke, E,14745902.460.000.000.00902.46
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Anderson, Ryan, W,132712319.990.000.000.002319.99
Kelly, Haley,15511128.560.000.000.00128.56
Perez, Dalton,110911125.360.000.0013.981111.38
Johnson, Andrew, F,262942443.350.000.002443.350.00
White, Nicole,16731155.910.000.000.00155.91
Zhang, Heather,166543056.320.000.000.003056.32
Thomas, Jessica,1684894.480.000.0094.480.00
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Griffin, Miguel,2146476.970.000.000.0076.97
Gray, Jared, A,264494.990.000.000.004.99
Collins, Alex, S,287812.290.000.000.002.29
Flores, Arianna,217274132.243578.270.000.00553.97
Kumar, Elijah,15197156.920.000.000.00156.92
Patterson, Abigail, H,144784795.010.000.000.004795.01
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Flores, Devin, A,15559172.040.000.000.00172.04
Foster, Emma,15468436.350.000.000.00436.35
Carter, Jose, H,12532235.720.000.000.00235.72
Howard, Alyssa, A,11513863.950.000.000.00863.95
Cox, Lucas, J,253932443.350.000.002443.350.00
Lewis, Seth,26782699.100.00699.100.000.00
Blanco, Randall,263211554.410.000.001000.44553.97
Ross, Kaitlyn,16121614.470.000.000.00614.47
Gonzales, Gavin,2448813.980.000.000.0013.98
Diaz, Alyssa,139084715.330.000.000.004715.33
Phillips, Miguel,2049812.940.000.000.0012.94
Stewart, Gabriella,2803469.990.000.000.0069.99
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Reed, Michelle,2804669.990.000.000.0069.99
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Morgan, Evan, G,14725318.830.000.000.00318.83
Lewis, Rachel, J,14900839.480.000.000.00839.48
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Williams, Ethan,243094793.120.003578.270.001214.85
Taylor, Natalie, M,14338828.740.000.000.00828.74
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Reed, Mariah,263731565.910.000.001000.44565.47
Evans, Gabriel,2348789.970.000.000.0089.97
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Hall, Eduardo,16847189.940.000.000.00189.94
Rivera, Hailey, R,2079239.980.000.000.0039.98
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Tang, Carl,2123832.270.000.000.0032.27
Stewart, Hailey,229036054.220.003578.270.002475.95
Coleman, Spencer,15993597.260.000.000.00597.26
Cook, Seth,2301064.470.000.000.0064.47
Harris, Joshua, L,2028095.940.000.000.0095.94
Washington, Alexia,27613782.990.000.00782.990.00
Miller, Joseph, A,227134148.190.003578.270.00569.92
Rodriguez, Destiny, J,227397.280.000.000.007.28
Bryant, Jackson, J,2533239.980.000.000.0039.98
Davis, Austin, E,133664749.040.000.000.004749.04
Washington, Lauren, R,229985329.250.003578.271750.980.00
She, Alisha, G,247574343.590.003578.270.00765.32
Thomas, Dylan,198737.280.000.000.007.28
Morris, Paige, W,220414167.233578.270.000.00588.96
Brown, Jonathan,11875265.420.000.000.00265.42
Perry, Ana,112151155.520.000.000.001155.52
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Stewart, Alex, M,2008463.150.000.000.0063.15
Scott, Gabrielle,270614.990.000.000.004.99
She, Kenneth,16096212.010.000.000.00212.01
Collins, Amanda,2078339.980.000.000.0039.98
Washington, Alexis,1978146.260.000.007.2838.98
Jackson, Victoria,270194.990.000.000.004.99
Jones, Michael, A,2210771.970.000.000.0071.97
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Reed, Judith, D,2534759.980.000.000.0059.98
Gonzales, Brittany,217104187.233578.270.000.00608.96
Phillips, Haley, B,2807939.980.000.000.0039.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Phillips, Andrea,1857383.740.000.000.0083.74
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Gomez, Briana, A,2878443.980.000.000.0043.98
Watson, Emma,17481126.940.000.000.00126.94
Harris, Samantha, A,244874.990.000.000.004.99
Wilson, Christian,27085782.990.000.00782.990.00
Russell, Oscar, A,12140118.170.000.000.00118.17
Johnson, Jonathan,220597.280.000.000.007.28
Martin, Nicholas,233627.280.000.000.007.28
Morris, Abigail, C,287762.290.000.000.002.29
Martin, Katherine, J,2027339.980.000.000.0039.98
Thomas, William, A,216142589.090.000.002049.10539.99
Bryant, Brittany,2254548.970.000.000.0048.97
Bradley, Melanie, G,133434720.270.000.000.004720.27
Adams, Katherine, M,235184.990.000.000.004.99
Adams, Hailey, M,121544798.530.000.000.004798.53
Li, Rafael, M,217527.280.000.000.007.28

Generated 2025-12-22 00:46:51.861 UTC