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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Campbell, Natalie, L,115122319.990.000.000.002319.99
Hall, Eduardo,16847189.940.000.000.00189.94
Richardson, Erin, R,1633188.850.000.0038.8849.97
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Jai, Logan, H,12031769.490.000.000.00769.49
Walker, Isabella,243864143.740.003578.27565.470.00
Powell, Angela, R,12970471.110.000.000.00471.11
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Mitchell, Bailey, B,267067.280.000.007.280.00
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Bryant, Kyle,231644807.100.003578.271228.830.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Young, Kaylee, S,13756298.490.000.0058.47240.02
Thomas, Thomas,216292624.080.000.002049.10574.98
Evans, Dalton, E,127104774.040.000.002354.982419.06
Coleman, Joan, W,2669964.470.000.000.0064.47
Bradley, Jocelyn,230227.280.000.000.007.28
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Gray, Isabella,168203217.790.000.000.003217.79
Foster, Edward, R,18355150.950.000.000.00150.95
Ross, Miranda,145984839.000.000.000.004839.00
Cook, Megan, J,2029956.970.000.000.0056.97
Coleman, Miguel, D,2740069.990.000.0069.990.00
Lopez, Katelyn,11820232.710.000.0060.47172.24
Price, Miranda,26629699.10699.100.000.000.00
Brooks, Ian, W,2829064.470.000.000.0064.47
Powell, Ian,2608564.470.000.000.0064.47
Taylor, Christian,2076456.760.000.000.0056.76
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Kelly, Angel, E,15418232.230.000.000.00232.23
Garcia, Chloe, M,110372374.230.000.002374.230.00
Parker, James,11808610.190.000.00186.77423.42
Smith, John,198555709.960.003399.990.002309.97
Harris, Emily, P,1986298.480.000.000.0098.48
Murphy, Dalton, N,27043782.990.00782.990.000.00
Dominguez, Meghan,14370122.560.000.000.00122.56
Shan, Benjamin,235663578.270.003578.270.000.00
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Russell, Ian, T,2474613.980.000.0013.980.00
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Robinson, William,20103103.480.000.000.00103.48
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Henderson, Austin,2764354.980.000.000.0054.98
Washington, Vanessa,238194802.110.003578.270.001223.84
Howard, Erin, L,183621725.210.000.000.001725.21
Johnson, Ian, E,2173283.470.000.000.0083.47
Bailey, Hailey, R,262704.990.000.000.004.99
Murphy, Juan, T,246463578.270.003578.270.000.00
Parker, Amanda,1808151.970.000.000.0051.97
Washington, Riley, L,185441155.480.000.001155.480.00
Hill, Fernando,247634.990.000.000.004.99
Roberts, Hunter,282607.280.000.000.007.28
Lee, Kayla, M,2078115.230.000.000.0015.23
Taylor, Taylor,159054899.020.000.000.004899.02
Flores, Morgan,19817118.940.000.0039.9878.96
Baker, Mason, A,132702394.950.000.000.002394.95
Hayes, Brittany,13941286.820.000.000.00286.82
Roberts, Carlos,2319639.980.000.000.0039.98
Davis, Austin, E,133664749.040.000.000.004749.04
Richardson, Devin, G,2131836.960.000.000.0036.96
Clark, Zachary, J,2389358.980.000.000.0058.98
Wang, Benjamin, R,274547.280.000.000.007.28
Foster, Trevor, J,2896469.990.000.000.0069.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Johnson, James,234984.990.000.000.004.99
Gill, Beth,199975814.980.003374.990.002439.99
Chen, Jonathan, G,13096200.690.000.000.00200.69
Davis, Thomas,167641760.470.000.000.001760.47
Gray, Alexandria, E,253632443.350.002443.350.000.00
Butler, Dalton, A,133454759.510.000.000.004759.51
Stewart, Cindy,14496804.480.000.000.00804.48
Morgan, Timothy,14633242.500.000.0071.58170.92
Coleman, Logan,1868691.950.000.000.0091.95
Henderson, Luke,19200109.240.000.000.00109.24
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Jones, Charles,22882101.450.000.000.00101.45
Cox, Devin, C,134184768.050.000.000.004768.05
Collins, Eduardo,139872329.990.000.000.002329.99
Flores, Zachary, H,233765314.250.003578.270.001735.98
Coleman, Ian,2127639.980.000.000.0039.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Powell, Miranda, J,153044843.000.000.000.004843.00
Perez, Angel, S,213362628.350.000.002071.42556.93
Brown, Fernando,1900191.950.000.0069.9721.98
Lewis, Ethan,27998144.470.000.000.00144.47
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Martin, Joshua, A,276077.280.000.007.280.00
Coleman, Samuel, N,17450123.980.000.000.00123.98
Martin, Madison, C,2049271.970.000.0071.970.00
Morgan, Evan, G,14725318.830.000.0069.97248.86
Anderson, Madison, G,2835978.980.000.000.0078.98
Wood, Alexandria, M,248242181.560.002181.560.000.00
Harris, Joshua, L,2028095.940.000.0030.9764.97
Washington, Lauren, R,229985329.250.003578.271750.980.00
Howard, Alexandra,207363194.580.000.002049.101145.48
Griffin, James,28189567.760.000.000.00567.76
Smith, Samuel, D,2308349.900.000.000.0049.90
Martinez, Carol, D,17656578.460.000.000.00578.46
Long, Caleb, P,250462181.560.002181.560.000.00
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Stewart, Destiny,13144281.470.000.00134.98146.49
Liu, Arturo,13222150.410.000.0013.98136.43
Henderson, Caroline,2008256.970.000.000.0056.97
Bryant, Isabelle,233974828.110.003578.270.001249.84
Rivera, Rachel, S,2899678.980.000.000.0078.98
Green, Chloe, J,1465892.820.000.000.0092.82
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Ward, Devin, J,15378170.910.000.0076.9593.96
Patterson, Eric, A,2738478.980.000.000.0078.98
Stewart, Grace, H,247737.280.000.000.007.28
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Ashe, Alexis, S,194141145.480.000.000.001145.48
Lewis, Zachary, L,14760167.260.000.000.00167.26
Davis, Jonathan,2925913.980.000.000.0013.98
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Foster, Samuel, M,18523160.940.000.00128.9731.97
Davis, Nicholas,1320173.160.000.000.0073.16
Morgan, Isabella, L,28602144.470.000.000.00144.47
Taylor, Zachary, M,27082782.990.000.00782.990.00
Simmons, James,198844588.450.003399.990.001188.46
Moore, Matthew, W,13267109.950.000.000.00109.95
Harris, Anthony,2144721.980.000.000.0021.98
Cox, Lucas, J,253932443.350.002443.350.000.00
Hughes, Miranda,266784.990.000.000.004.99
Garcia, Henry, B,112871009.240.000.00219.26789.98
Chen, Jackson, S,270751371.950.00782.990.00588.96
Rogers, Sara,198744544.450.003374.990.001169.46
She, Shawn, J,16902141.980.000.000.00141.98
Flores, Miguel,1975077.250.000.000.0077.25
Butler, Victoria,132844767.530.000.000.004767.53
Moore, Wyatt, F,189712351.960.000.000.002351.96
Cox, Julia, A,206703228.570.000.002049.101179.47
Ruiz, Philip,1807781.460.000.000.0081.46
Moore, Seth,138512331.950.000.000.002331.95
Baker, Ian, V,262002756.540.000.002181.56574.98
Gonzales, Brittany,217104187.233578.270.000.00608.96
Srini, Evelyn,16855150.950.000.000.00150.95
Cooper, Amanda, P,146064716.020.000.000.004716.02
Perry, Natalie,1712669.990.000.000.0069.99
Sanders, Angel,16219553.970.000.000.00553.97
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Washington, Victoria,235577.280.000.000.007.28
Morgan, Abigail, C,244314334.600.003578.270.00756.33
James, Maria,1624391.970.000.0069.9921.98
Stewart, Andrea, M,27252782.990.000.00782.990.00
Thomas, Richard,27557782.990.000.00782.990.00
Robinson, Dylan, L,1472481.530.000.000.0081.53
Clark, Anthony,27071782.990.00782.990.000.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Garcia, Anna, B,15572104.550.000.000.00104.55
Alexander, Ryan, J,14078839.480.000.00839.480.00
Patterson, Aaron, W,191131184.460.000.000.001184.46
Patterson, Alexis,213484392.020.000.002049.102342.92
Rogers, Paige, H,17125539.990.000.000.00539.99
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Sanders, Mason, G,2345939.980.000.000.0039.98
King, Sara,2235439.980.000.000.0039.98
Brown, Benjamin, D,151874725.320.000.000.004725.32
Howard, Brianna, D,246304.990.000.000.004.99
Ramirez, Sydney,267007.280.000.000.007.28
Bailey, Richard, N,220504160.533578.270.000.00582.26
Sanchez, Stephanie,1786756.970.000.000.0056.97
Stewart, Garrett, O,15762564.480.000.000.00564.48
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Wilson, Madison, H,1982821.980.000.000.0021.98
Russell, Samantha,11211723.560.000.00118.46605.10
Smith, Justin, P,1982721.980.000.000.0021.98
Patterson, Natalie,16123629.970.000.000.00629.97
Moore, Anthony, M,2473039.980.000.000.0039.98
Bennett, Seth,244933578.270.003578.270.000.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Huang, Kristen,251002443.350.002443.350.000.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Martin, Nicholas,233627.280.000.000.007.28
Parker, Caleb, A,2631813.980.000.000.0013.98
Sanders, Allison, B,18852268.250.000.000.00268.25
Fernandez, Darren,2899278.980.000.000.0078.98
Morris, Chase, F,26789699.100.00699.100.000.00
Hayes, Jason,261764.990.000.000.004.99
Wilson, Daniel, K,142814746.300.000.000.004746.30
Ware, Dennis, L,237254828.110.003578.270.001249.84
Adams, Katherine, M,235184.990.000.000.004.99
Nath, Kenneth, W,170372334.970.000.000.002334.97
Moore, Fernando,265821000.440.000.001000.440.00
Hughes, Austin, P,183681754.980.000.000.001754.98
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Turner, Andrea, A,202093268.550.002049.100.001219.45
Ramos, Derrick,18449100.940.000.0030.9769.97
Cooper, Alexandra,19541131.240.000.000.00131.24
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Bell, Alex, M,167543118.600.000.00756.332362.27
Jones, Zachary, J,27285782.990.000.00782.990.00
Harris, Natalie,2368259.980.000.0059.980.00
Williams, Joshua,260514.990.000.000.004.99
Jenkins, Megan, R,12074261.380.000.000.00261.38
Sandberg, Chase,2190475.970.000.000.0075.97
Martinez, Matthew, L,16009170.450.000.000.00170.45
Alexander, Julian,132172351.960.000.000.002351.96
Powell, Vanessa,26630699.100.00699.100.000.00
Stewart, Alex, M,2008463.150.000.000.0063.15
Sanders, Sean,14341175.150.000.000.00175.15
Wilson, Emily,174002331.950.000.000.002331.95
Torres, Xavier,16840176.950.000.000.00176.95
Thomas, Jeremiah,183721760.470.000.000.001760.47
Zhao, Clarence, R,1982671.970.000.0071.970.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Thompson, Jose,237314828.110.003578.270.001249.84
Hughes, Anna,197052341.970.000.000.002341.97
Stewart, Cody, A,212843223.580.000.002049.101174.48
Chow, Candice,1923260.960.000.000.0060.96
Perry, Benjamin,291652407.040.000.002407.040.00
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Campbell, Hunter,17422174.920.000.000.00174.92
Hall, Jan, M,11740334.120.000.00235.1598.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Long, Julia, R,228895971.330.003578.270.002393.06
Williams, Austin,2035432.220.000.000.0032.22
Perry, Eric,18314115.730.000.0056.9758.76
Price, Riley, R,139094764.020.000.000.004764.02
White, Miguel, S,13988195.520.000.000.00195.52
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Torres, Victoria,17551160.920.000.000.00160.92
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Cook, Seth,2301064.470.000.000.0064.47
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Coleman, Spencer,15993597.260.000.000.00597.26
Foster, Deb,215012661.400.000.002661.400.00
Bradley, Alexandria,176911779.470.000.000.001779.47
Sanchez, Rachel, C,267304.990.000.000.004.99
Torres, Abigail,253674.990.000.000.004.99
Smith, Nathan,217647.280.000.007.280.00
Bryant, Nathan,2145059.980.000.000.0059.98
Lal, Kyle,17360122.180.000.000.00122.18
Cooper, Paige,14119148.940.000.000.00148.94
Price, Caroline,180511735.980.000.000.001735.98
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Robinson, Madison, W,183772394.970.000.000.002394.97
Sara, Ivan, L,2509067.930.000.000.0067.93
Brooks, Allison,146054750.010.000.000.004750.01
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Powell, David, W,266151000.440.000.001000.440.00
Allen, Jack, M,291372419.060.000.002419.060.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Wang, Zachary,2214489.970.000.000.0089.97
Edwards, Madeline,2077146.470.000.000.0046.47
Diaz, Katherine, P,115262376.960.000.002376.960.00
Gonzales, Kayla,214947.280.000.000.007.28
Russell, Jessica,265721000.440.000.001000.440.00

Generated 2025-11-04 08:27:33.108 UTC