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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Adams, Gabriel, S,195271219.450.000.000.001219.45
Ward, Stephanie, A,27429782.990.000.00782.990.00
Bailey, Maria, C,1915034.980.000.000.0034.98
Foster, Emma,15468436.350.000.000.00436.35
Tang, Carl,2123832.270.000.000.0032.27
Barnes, Kayla,2425639.980.000.000.0039.98
Martin, Kellie, R,28195574.980.000.000.00574.98
Rogers, Amanda, A,13920266.970.000.000.00266.97
Simmons, Adam,253274.990.000.000.004.99
Patterson, Nicole,1972937.270.000.000.0037.27
Stewart, Lucas, J,2934198.970.000.000.0098.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Turner, Adam, K,16109548.980.000.000.00548.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Morgan, Juan, C,1882191.970.000.000.0091.97
Torres, Dalton,235037.280.000.000.007.28
Thomas, Ian,191181120.490.000.000.001120.49
Phillips, Isaiah,28631144.470.000.000.00144.47
James, Juan,232674862.090.003578.270.001283.82
She, Martha, E,222515971.330.003578.270.002393.06
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Foster, Isabel, M,2174571.950.000.000.0071.95
Perry, Benjamin,291652407.040.000.000.002407.04
Henderson, Hailey, C,171481775.470.000.000.001775.47
Rodriguez, Alexis, L,15244179.190.000.000.00179.19
Howard, Erin, L,183621725.210.000.000.001725.21
Jai, Logan, H,12031769.490.000.000.00769.49
Perez, Timothy, L,227304.990.000.000.004.99
Brown, Samantha, G,2514739.980.000.000.0039.98
Wood, Gavin,16964108.540.000.0021.9886.56
Hall, Kyle, J,1749169.970.000.000.0069.97
Jenkins, Megan, R,12074261.380.000.000.00261.38
Cook, Steven, J,27053782.990.000.00782.990.00
Barnes, Brittany, R,15340156.040.000.000.00156.04
Parker, Jeremy,2866878.980.000.000.0078.98
Brown, Morgan,2919778.980.000.000.0078.98
Allen, Mason,176252431.950.000.000.002431.95
Thompson, Ethan,199894495.480.003374.990.001120.49
Parker, Eduardo, M,12939169.420.000.000.00169.42
Brown, Nicholas, S,11506675.640.000.000.00675.64
Campbell, Hunter,17422174.920.000.000.00174.92
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Butler, Morgan, E,2050068.490.000.000.0068.49
Butler, Isabel,16241126.960.000.000.00126.96
Edwards, Logan,250024.990.000.000.004.99
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Diaz, Thomas, O,16020595.960.000.000.00595.96
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Mitchell, Maria, D,27404782.990.000.00782.990.00
Stewart, Hailey,229036054.220.003578.270.002475.95
Rogers, Carlos,19645134.440.000.000.00134.44
Adams, Carlos,1982236.960.000.000.0036.96
Ward, Eduardo, I,139162354.980.000.000.002354.98
Cooper, Brooke,195361120.490.000.000.001120.49
Lee, William,13185149.840.000.000.00149.84
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Smith, Chloe,17619163.920.000.000.00163.92
King, Jordan, C,110202316.970.000.002316.970.00
Ye, Alisha, J,220084141.230.003578.270.00562.96
Walker, Isabella,243864143.740.003578.27565.470.00
Washington, Adam, G,2543713.980.000.000.0013.98
Bradley, Evan,18506101.940.000.000.00101.94
Miller, Destiny,251577.280.000.000.007.28
Bryant, Nathan,2145059.980.000.000.0059.98
Sanders, Allison, B,18852268.250.000.000.00268.25
Davis, Daniel,11711999.220.000.0010.24988.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
Johnson, Xavier, R,2325539.980.000.000.0039.98
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Griffin, James,28189567.760.000.000.00567.76
Washington, Aaron, L,246494.990.000.000.004.99
Davis, Ethan,136604750.010.000.000.004750.01
James, Zoe, R,14611304.550.000.000.00304.55
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Taylor, Zachary, M,27082782.990.000.00782.990.00
Peterson, Isabella,2808039.980.000.000.0039.98
Yuan, Brendan, S,247444.990.000.000.004.99
Long, Gavin,13762186.030.000.000.00186.03
Young, Julia, J,274144.990.000.000.004.99
Watson, Olivia, S,1386093.850.000.0014.9878.87
Peterson, Alex, M,13423132.900.000.000.00132.90
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Gomez, Rebekah,13486225.440.000.000.00225.44
Miller, Benjamin, G,26643699.100.00699.100.000.00
Thompson, Ryan, M,113301111.360.000.000.001111.36
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Mitchell, Bailey, B,267067.280.000.000.007.28
Moore, Ian, L,2463939.980.000.000.0039.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Perry, Olivia,203754438.380.000.002071.422366.96
Rivera, Sara,187852350.960.000.000.002350.96
Smith, Austin,13707149.050.000.000.00149.05
Cox, Katelyn, B,2174230.970.000.000.0030.97
Ross, Isabelle, D,18554155.450.000.000.00155.45
Sanders, Chloe, C,231375314.250.003578.270.001735.98
Clark, William,2902169.990.000.000.0069.99
Powell, Jordyn, K,153914828.010.000.000.004828.01
Flores, Morgan,19817118.940.000.000.00118.94
Flores, Eduardo, S,2896962.980.000.000.0062.98
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Young, Sierra, J,11619634.840.000.000.00634.84
Bradley, Jocelyn,230227.280.000.000.007.28
Stewart, Melissa,2517336.960.000.000.0036.96
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Martin, Brianna, M,235834829.390.003578.270.001251.12
Li, Kevin, S,2518813.980.000.000.0013.98
Cook, Jacqueline, A,1922360.370.000.000.0060.37
Moore, Andrew, A,13944150.130.000.0036.27113.86
Gutierrez, Jerome,127832420.460.000.000.002420.46
Jackson, Andrew,2047985.480.000.000.0085.48
Edwards, Elijah, D,281577.280.000.000.007.28
Fernandez, Cesar,200355694.980.003374.990.002319.99
Sanders, Alexa, E,217414127.253578.270.000.00548.98
Li, Brandon,2933973.960.000.000.0073.96
Perez, Dalton,110911125.360.000.0013.981111.38
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Washington, Thomas, C,2745137.430.000.000.0037.43
Carter, Savannah, M,120902350.960.000.000.002350.96
Washington, Victoria,235577.280.000.000.007.28
Bennett, Brittany, J,2233239.980.000.000.0039.98
Reed, Mariah,263731565.910.000.001000.44565.47
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Peterson, Julia, P,16497132.710.000.000.00132.71
Hayes, Arianna,259912845.520.000.002181.56663.96
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Harris, Destiny, M,137102341.460.000.000.002341.46
Price, Oscar, G,11833240.010.000.000.00240.01
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Henderson, Ashley,111851381.370.000.000.001381.37
Harris, Isabella,17119214.900.000.000.00214.90
Flores, Devin, A,15559172.040.000.000.00172.04
Russell, Isabella, A,11507645.780.000.000.00645.78
Shan, Chad, M,2462112.940.000.000.0012.94
Long, Morgan, H,213522625.390.000.002071.42553.97
Allen, Angel, G,15571101.850.000.0034.8966.96
Mitchell, Savannah,261153052.800.000.002443.35609.45
Reed, Sean, L,145974803.310.000.000.004803.31
Butler, Jackson, J,183241735.980.000.000.001735.98
Sanders, Hailey,19647282.040.000.000.00282.04
Alexander, Paige, W,1860459.250.000.000.0059.25
Li, Rafael, M,217527.280.000.000.007.28
Carter, Jason,11724210.090.000.0071.58138.51
Flores, Emily,13206163.190.000.000.00163.19
Taylor, Taylor,159054899.020.000.000.004899.02
Miller, Eduardo,14561158.840.000.0049.97108.87
Collins, Xavier, C,16646250.910.000.000.00250.91
Johnson, Edward, H,23279124.990.000.000.00124.99
Turner, Sean,227324133.240.003578.270.00554.97
Bryant, Zachary,216552648.070.000.002049.10598.97
Parker, Jordan,216212616.860.000.002049.10567.76
Campbell, Timothy,2584513.980.000.000.0013.98
Cooper, Andrea,2932378.980.000.000.0078.98
Sanders, Xavier,1672173.750.000.000.0073.75
Bryant, Rachel,220197.280.000.000.007.28
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Collins, Alex, S,287812.290.000.000.002.29
Watson, Cole, A,217684118.263578.270.000.00539.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Prasad, Donald,15413318.920.000.00123.98194.94
Rodriguez, Julia, A,264884.990.000.000.004.99
Davis, Dylan,15556588.960.000.000.00588.96
Stewart, Olivia, B,1874923.780.000.000.0023.78
Gray, Cody, C,144594775.010.000.000.004775.01
Harris, Seth, M,161402528.330.000.000.002528.33
Green, Marcus, C,15974208.410.000.000.00208.41
Flores, Arianna,217274132.243578.270.000.00553.97
Coleman, Jose, S,253494.990.000.000.004.99
Turner, Andrea, A,202093268.550.002049.100.001219.45
Diaz, Brandon,236764.990.000.000.004.99
Clark, Anthony,27071782.990.000.00782.990.00
Johnson, Madison, L,15530846.460.000.000.00846.46
Adams, Hailey, M,121544798.530.000.000.004798.53
Chander, Wayne, S,243444329.610.003578.270.00751.34
Coleman, Luke, A,11723152.550.000.0039.99112.56
Winston, Ethan, R,216222612.060.000.002049.10562.96
Coleman, Ashley,27297782.990.000.00782.990.00
Price, Lauren, J,14079184.740.000.0037.29147.45
Collins, Nathan, F,197041143.460.000.000.001143.46
Sanders, Angel,16219553.970.000.000.00553.97
Simmons, Jennifer,112621010.560.000.000.001010.56
Cooper, Amanda, P,146064716.020.000.000.004716.02
Turner, Timothy, C,14641119.860.000.000.00119.86
Jones, Zachary, J,27285782.990.000.00782.990.00
Griffin, Jason, L,112001267.110.000.00193.891073.22
Bell, Christina,2609939.980.000.000.0039.98
Long, Jordan,199884555.470.003399.990.001155.48
Hughes, Luis,130841798.960.000.000.001798.96
Sanchez, Jeremiah, E,2226521.980.000.000.0021.98
Nelson, James, L,245257.280.000.000.007.28
Hughes, Zachary,12203157.910.000.000.00157.91
Price, Jeremy,259892744.520.000.002181.56562.96
Li, Eugene, A,15283865.950.000.000.00865.95
Phillips, Kaylee,211384371.380.000.002049.102322.28
Ross, Antonio,18322148.890.000.000.00148.89
Martin, James, M,1987077.250.000.000.0077.25
White, Judith, R,148851155.480.000.000.001155.48
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Wang, Benjamin, R,274547.280.000.000.007.28
Griffin, Marcus,2075634.560.000.000.0034.56
Thomas, Zachary, D,28045119.980.000.000.00119.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Anderson, David, A,2209761.960.000.000.0061.96
Wilson, Nathan, L,13936218.930.000.000.00218.93
Green, Kaylee, C,2618567.970.000.000.0067.97
Clark, Emily, R,120862294.990.000.000.002294.99
Ramirez, Emma,29072128.970.000.000.00128.97
Scott, Haley,13701154.540.000.000.00154.54
Gonzales, Miranda,11660324.720.000.000.00324.72
Foster, Jose, C,2878534.990.000.000.0034.99
Bell, Julia,216522646.060.000.002646.060.00
Li, Connor,201863191.910.002071.420.001120.49
James, Christina,17409219.920.000.000.00219.92
Chen, Ethan,2054756.970.000.000.0056.97
Coleman, Stephanie,2226489.970.000.000.0089.97
Scott, Mason,2355139.980.000.000.0039.98
Hall, Amber,20106131.950.000.000.00131.95
Edwards, Alexandra,133582386.940.000.000.002386.94
Richardson, Erin, R,1633188.850.000.000.0088.85
Turner, Eduardo,158764789.020.000.000.004789.02
Luo, Donna, E,248054.990.000.000.004.99
Butler, Ana,260403018.330.000.002443.35574.98
Lewis, Brianna, H,14282166.240.000.000.00166.24
Perry, Samuel,18811100.960.000.000.00100.96
Evans, Dalton, E,127104774.040.000.000.004774.04
Davis, Thomas,167641760.470.000.000.001760.47
Martin, Nicholas,233627.280.000.000.007.28
Brooks, Makayla,222526047.320.003578.270.002469.05
Powell, Elijah, E,231135997.330.003578.270.002419.06
Wu, Randy, J,116472365.940.000.000.002365.94
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Anderson, Lucas,2926639.980.000.000.0039.98
Cooper, Christina, C,265121000.440.000.001000.440.00
Evans, Kaylee,19642133.540.000.000.00133.54
Peterson, Christina,2897694.480.000.000.0094.48
Campbell, Alex,119844730.320.000.000.004730.32
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Barnes, Dalton, C,178581700.990.000.000.001700.99
Richardson, Arianna, C,1205534.980.000.000.0034.98
Hall, Luke, E,14745902.460.000.000.00902.46
Bell, Brooke, H,2325339.980.000.000.0039.98
Russell, Oscar, A,12140118.170.000.000.00118.17
Lee, Don,188392384.970.000.000.002384.97
Clark, Lauren,170341750.980.000.000.001750.98
McDonald, Aaron, J,27734119.980.000.000.00119.98
White, Cameron,238304802.110.003578.270.001223.84
Turner, Mary,220154.990.000.000.004.99
Perry, Justin, E,167583062.340.000.000.003062.34
Collins, Allison,28581119.980.000.000.00119.98
Harris, Edward,27062782.990.000.00782.990.00

Generated 2025-12-22 03:10:23.624 UTC