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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Walker, Ian,16771104.550.000.0054.5849.97
Phillips, Kaylee,211384371.380.000.002049.102322.28
Baker, Sara, M,11827512.470.000.00148.47364.00
Washington, Taylor,212664525.070.000.002049.102475.97
Russell, Samantha,11211723.560.000.00118.46605.10
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Carter, Bailey,213322616.860.000.002616.860.00
Scott, Haley,13701154.540.000.000.00154.54
Simmons, Haley, T,262022749.320.000.002181.56567.76
Diaz, Luis, D,11203801.770.000.00124.99676.78
Sharma, Jackson,16876151.840.000.000.00151.84
Perry, Dalton, A,16149192.040.000.000.00192.04
Young, Adam,12984200.200.000.0037.29162.91
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Peterson, Jared,11502829.370.000.00171.95657.42
Coleman, Ashley,27297782.990.000.00782.990.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Scott, Sean, F,2475539.980.000.000.0039.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Mitchell, Maria, D,27404782.990.000.00782.990.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Bryant, Nathan,2145059.980.000.000.0059.98
Jai, Samuel, L,1635887.950.000.0039.9947.96
Morris, Alyssa,28072548.980.000.000.00548.98
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Miller, Eduardo,14561158.840.000.0049.97108.87
Martin, John, A,144364776.010.000.000.004776.01
Flores, Brittany,169062359.980.000.000.002359.98
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Kumar, Cameron, S,185711120.490.000.001120.490.00
Cook, Seth,2301064.470.000.000.0064.47
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Patterson, Hailey, I,112231155.900.000.00196.04959.86
Cooper, Brianna,2592513.980.000.000.0013.98
James, Richard, D,15760109.230.000.003.99105.24
Smith, Alexandra,2829261.960.000.000.0061.96
Harris, Megan,232814828.110.003578.271249.840.00
Hill, Blake,11748131.540.000.000.00131.54
Powell, Sydney, M,14886539.990.000.000.00539.99
Sanders, Megan, A,15376136.240.000.000.00136.24
Lewis, Christopher,1875586.960.000.000.0086.96
Johnson, Anthony, D,270224.990.000.000.004.99
Parker, Blake,15008170.530.000.000.00170.53
Rivera, Ariana,261734.990.000.000.004.99
Sanders, Xavier,1672173.750.000.000.0073.75
Coleman, Joan, W,2669964.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Cox, Devin, C,134184768.050.000.000.004768.05
Hughes, Antonio, P,15913712.270.000.000.00712.27
Davis, Ethan,136604750.010.000.000.004750.01
Perry, Ana,112151155.520.000.00292.94862.58
Collins, Xavier, C,16646250.910.000.000.00250.91
Simmons, Caleb, M,121934833.030.000.000.004833.03
Mitchell, Caleb, K,268064.990.000.000.004.99
Patterson, Nicole,1972937.270.000.000.0037.27
Powell, Jordyn, K,153914828.010.000.000.004828.01
Cooper, Paige,14119148.940.000.000.00148.94
Li, Kevin, S,2518813.980.000.000.0013.98
Bailey, Richard, N,220504160.533578.270.000.00582.26
Long, Chloe,167841735.980.000.000.001735.98
Powell, Ian,2608564.470.000.000.0064.47
Price, Marissa,15826160.740.000.00120.4840.26
Jones, Kayla, C,1854194.260.000.000.0094.26
Wright, Carol, C,12928247.410.000.0033.98213.43
Hill, Katherine, L,2670139.980.000.000.0039.98
Morris, Seth,189592341.460.000.000.002341.46
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Garcia, Christian, J,164913106.330.000.00751.342354.99
Cooper, Amanda, P,146064716.020.000.000.004716.02
Hall, Lauren, A,19648100.840.000.000.00100.84
Allen, Angel, G,15571101.850.000.0034.8966.96
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Phillips, Devin,18759112.060.000.000.00112.06
Martinez, Jill,242354829.390.003578.270.001251.12
Morgan, Marcus, W,289682.290.000.000.002.29
Allen, Sean, L,12097159.220.000.000.00159.22
Barnes, Elizabeth, J,249397.280.000.000.007.28
Thomas, Seth,14567161.280.000.0096.0765.21
Ward, Emma, W,2179659.980.000.000.0059.98
Wood, Gavin,16964108.540.000.0093.5614.98
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Henderson, Luke,19200109.240.000.000.00109.24
Townsend, Bryan,14077180.730.000.000.00180.73
Hughes, Anna,197052341.970.000.000.002341.97
Russell, Xavier,12964119.950.000.000.00119.95
Zhang, Nathan, L,2910478.980.000.000.0078.98
Ross, Xavier, A,12202171.470.000.0049.97121.50
Simmons, Brittany,2923139.980.000.000.0039.98
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Jai, Logan, H,12031769.490.000.000.00769.49
Adams, Miguel,11659213.520.000.000.00213.52
Alexander, Lauren,189502351.960.000.000.002351.96
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Powell, Caleb, G,216132610.580.000.002049.10561.48
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Russell, Jessica,265721000.440.000.001000.440.00
Kelly, Angel, E,15418232.230.000.000.00232.23
Thomas, Richard,27557782.990.000.00782.990.00
Walker, Richard, T,19640224.550.000.000.00224.55
Winston, Ethan, R,216222612.060.000.002049.10562.96
Rogers, Amanda, A,13920266.970.000.000.00266.97
Moore, Fernando,265821000.440.000.001000.440.00
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Wilson, Victoria, R,27536782.990.000.00782.990.00
Stewart, Amanda, M,1531094.440.000.000.0094.44
Washington, Alexia,27613782.990.000.00782.990.00
Scott, Adam,15863243.010.000.000.00243.01
King, Jordan, C,110202316.970.000.002316.970.00
Roberts, Hunter,282607.280.000.000.007.28
Washington, Riley, L,185441155.480.000.001155.480.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
Russell, Elijah, M,118354772.300.000.002319.262453.04
Bradley, Nathaniel,169551760.470.000.000.001760.47
Jackson, Edward,290422420.340.000.002420.340.00
Adams, Carlos,1982236.960.000.000.0036.96
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Robinson, Madison, W,183772394.970.000.000.002394.97
Griffin, Jack, L,1768632.280.000.000.0032.28
Sanchez, Rachel, C,267304.990.000.000.004.99
Bailey, Lauren,15864103.550.000.000.00103.55
Brown, Isabella, L,266921266.860.00699.100.00567.76
Barnes, Jeremy,2144654.980.000.000.0054.98
Perez, Barry, M,2728269.990.000.000.0069.99
Griffin, Thomas, J,19015125.430.000.0094.4630.97
James, Zoe, R,14611304.550.000.000.00304.55
Foster, Carson, L,16959135.350.000.0085.4849.87
Li, Eugene, A,15283865.950.000.000.00865.95
Torres, Victoria,17551160.920.000.000.00160.92
Turner, Andrea, A,202093268.550.002049.100.001219.45
Harris, Samantha, A,244874.990.000.000.004.99
Brown, Julia,18065155.470.000.000.00155.47
Richardson, Evan, J,15488165.300.000.000.00165.30
Coleman, Ian,2127639.980.000.000.0039.98
Hill, Timothy,14871848.470.000.000.00848.47
Jackson, Andrew,2047985.480.000.000.0085.48
Martin, Nicholas,233627.280.000.000.007.28
Turner, Kaylee, M,16213154.540.000.000.00154.54
Roberts, Seth, H,11510258.150.000.0039.47218.68
Rogers, Olivia,12020804.470.000.000.00804.47
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Flores, Nathan, C,2463713.980.000.000.0013.98
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Sanders, Lucas, W,268024.990.000.000.004.99
Smith, Noah,13175166.920.000.000.00166.92
Peterson, Julia, P,16497132.710.000.000.00132.71
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Long, Elizabeth, F,127822400.950.000.000.002400.95
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Reed, Isaac, D,260747.280.000.000.007.28
Lewis, Zachary, L,14760167.260.000.000.00167.26
Jones, Charles,22882101.450.000.000.00101.45
Cook, Joan,235544.990.000.000.004.99
Ramirez, Ian,166783162.310.000.00742.352419.96
Walker, Thomas,1307193.980.000.000.0093.98
Brown, Morgan,2919778.980.000.000.0078.98
Thompson, Jose,237314828.110.003578.270.001249.84
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Foster, Antonio,12795108.540.000.0066.2642.28
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Reed, Kaylee, R,17371151.920.000.000.00151.92
Hall, Jan, M,11740334.120.000.00235.1598.97
Kumar, Elijah,15197156.920.000.000.00156.92
Flores, Eduardo, S,2896962.980.000.000.0062.98
Blanco, Randall,263211554.410.000.001000.44553.97
Brooks, Ian, W,2829064.470.000.000.0064.47
Davis, Justin,2807412.940.000.000.0012.94
Jai, Edwin,169211754.980.000.000.001754.98
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Anderson, Madison, G,2835978.980.000.000.0078.98
Allen, Allison, A,1975737.270.000.000.0037.27
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Edwards, Angel, J,2912469.990.000.000.0069.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Washington, Victoria,235577.280.000.000.007.28
Lewis, Morgan,17410168.740.000.000.00168.74
Bell, Christina,2609939.980.000.000.0039.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Mehta, Carmen, C,2743694.480.000.000.0094.48
Thomas, Logan, A,14091251.200.000.0053.99197.21
Young, Jenna, W,163652490.180.000.000.002490.18
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Alexander, Caroline,176541759.970.000.000.001759.97
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Long, Natalie,14363192.340.000.000.00192.34
Rubio, Kellie,27653128.970.000.000.00128.97
Sanchez, Martin, E,216317.280.000.000.007.28
Lal, Caleb, R,1586874.460.000.000.0074.46
Martin, Lucas, L,221144183.233578.270.000.00604.96
Flores, Caleb, S,12165280.640.000.00243.3737.27
Torres, Pedro, E,16958168.020.000.00153.0414.98
Thompson, Tyler,2750269.990.000.0069.990.00
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Martin, Madison, C,2049271.970.000.0071.970.00
Murphy, Emma,198445807.930.003374.990.002432.94
Washington, Alexis,1978146.260.000.007.2838.98
Williams, Ryan, R,222475978.610.003578.270.002400.34
Coleman, Luke, A,11723152.550.000.0069.9882.57
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Miller, Kayla, A,236734.990.000.000.004.99
Sanchez, Alex, K,131014736.030.000.000.004736.03
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Perry, Melissa,221284142.230.003578.270.00563.96
Butler, Trevor,2741569.990.000.0069.990.00
Miller, Benjamin, G,26643699.100.00699.100.000.00
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Johnson, James,234984.990.000.000.004.99
Russell, Ian, T,2474613.980.000.0013.980.00
She, Martha, E,222515971.330.003578.270.002393.06
Hall, Natalie, A,230704.990.000.004.990.00
Washington, Christian, R,2668639.980.000.000.0039.98
Diaz, Katherine, P,115262376.960.000.002376.960.00
Collins, Luis, J,227655978.610.003578.270.002400.34
Davis, Thomas,167641760.470.000.000.001760.47
Turner, Courtney, A,229753578.270.003578.270.000.00
Shan, Chad, M,2462112.940.000.000.0012.94
Washington, Lauren, R,229985329.250.003578.271750.980.00
Green, Mackenzie, C,280737.280.000.000.007.28
Harris, Emily, P,1986298.480.000.000.0098.48
Alexander, Jordan,2141259.980.000.0059.980.00
Wilson, Tyler, L,15879196.930.000.000.00196.93
Ross, Jose,2744178.980.000.0078.980.00
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Washington, Hannah, A,291307.280.000.007.280.00
Stewart, Jessica,16097103.550.000.0046.5856.97
Thompson, Madison, L,187882351.960.000.000.002351.96
Mitchell, Savannah,261153052.800.000.002443.35609.45
Hall, Eduardo,16847189.940.000.000.00189.94
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Alexander, Sarah,1941129.990.000.000.0029.99
Ramos, Kristi,151764703.030.000.000.004703.03
Griffin, Marcus,2075634.560.000.000.0034.56
Young, Julia, J,274144.990.000.000.004.99

Generated 2025-11-06 20:56:41.459 UTC