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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Ward, Stephanie, A,27429782.990.000.00782.990.00
Winston, Ethan, R,216222612.060.000.002049.10562.96
Carter, Elijah,216182611.070.000.002611.070.00
Parker, Jordan,216212616.860.000.002616.860.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Morgan, Brianna, D,111362380.470.000.002380.470.00
Walker, Isabella,243864143.740.003578.27565.470.00
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Davis, Richard, R,15549574.980.000.00574.980.00
Kelly, Bryan,213492989.380.000.002989.380.00
Campbell, Chloe,11212760.930.000.00307.78453.15
Rogers, Jade, I,14332102.250.000.0044.9957.26
Sanchez, Adrian, L,13179190.170.000.0077.92112.25
Wilson, Grace,17539205.920.000.000.00205.92
Brown, Nicholas, S,11506675.640.000.00401.27274.37
Russell, Samuel, V,11652310.930.000.0034.98275.95
Patterson, Hailey, I,112231155.900.000.00637.86518.04
Harris, Samantha, A,244874.990.000.000.004.99
Baker, Isaiah,12106169.540.000.0037.29132.25
Hill, Timothy,14871848.470.000.000.00848.47
Bailey, Jessica, L,12945218.440.000.0049.97168.47
Hernandez, Jonathan, J,1901465.950.000.0030.9734.98
Rubio, Kellie,27653128.970.000.00128.970.00
Turner, Morgan,11823178.470.000.0063.96114.51
Murphy, Chase, J,2472958.980.000.0058.980.00
Kelly, Angel, E,15418232.230.000.00232.230.00
Davis, Ethan,136604750.010.000.002351.962398.05
She, Martha, E,222515971.333578.270.000.002393.06
Thompson, Ryan, M,113301111.360.000.00623.78487.58
Wright, Carol, C,12928247.410.000.00128.46118.95
Nelson, Kevin,1476584.970.000.000.0084.97
Ramirez, Ian,166783162.310.000.00742.352419.96
Barnes, Alexandra, P,222686031.313578.270.000.002453.04
Griffin, Jason, L,112001267.110.000.00724.21542.90
King, Aaron, L,117394758.030.000.004758.030.00
Nelson, Sierra,161322459.620.000.002459.620.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Jones, Madison,246614181.760.003578.27603.490.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Suri, Carolyn, S,12972175.710.000.0098.4577.26
Kelly, Haley,15511128.560.000.00128.560.00
Davis, Thomas,167641760.470.000.001760.470.00
Butler, Dalton, A,133454759.510.000.004759.510.00
Stewart, Alex, M,2008463.150.000.0038.8824.27
Jenkins, Samantha,113311290.330.000.00822.35467.98
Yuan, Leonard, F,167911729.970.000.001729.970.00
Jai, Samuel, L,1635887.950.000.0083.963.99
Torres, Xavier,16840176.950.000.00176.950.00
Green, Mackenzie, C,280737.280.000.007.280.00
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Chen, James, D,11641303.200.000.00265.9137.29
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Howard, Natalie,1349154.960.000.0014.9839.98
Flores, Kevin,15878225.920.000.0069.97155.95
White, Greg, C,174032322.280.000.000.002322.28
Perez, Amber, D,13318214.260.000.00116.9197.35
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Simmons, Jennifer,112621010.560.000.00488.15522.41
Peterson, Alex, M,13423132.900.000.000.00132.90
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Bell, Gabrielle,223735976.323578.270.000.002398.05
Sanchez, Jared, J,2585064.470.000.0064.470.00
Sun, Arturo, C,11498557.540.000.00321.57235.97
Phillips, Andrea,1857383.740.000.0083.740.00
Hu, Gilbert, L,2876769.990.000.0069.990.00
Lee, William,13185149.840.000.00117.2432.60
Carter, Isaac,137191129.480.000.001129.480.00
Lal, Kyle,17360122.180.000.0035.2386.95
Peterson, Jessica, M,11868247.010.000.0081.94165.07
Foster, Antonio,12795108.540.000.0066.2642.28
Russell, Ian, T,2474613.980.000.0013.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Martinez, Jonathan,1330366.250.000.0042.2823.97
Evans, Alexandra,2432268.490.000.000.0068.49
Watson, Devin, A,18875114.950.000.000.00114.95
Ramirez, Garrett, M,173881763.970.000.000.001763.97
James, Zoe, R,14611304.550.000.000.00304.55
Ward, Natalie, J,132412325.960.000.000.002325.96
Nath, Kenneth, W,170372334.970.000.000.002334.97
Stewart, Destiny,13144281.470.000.00236.2345.24
Cooper, Ariana,17348205.420.000.0084.96120.46
Lewis, Morgan,17410168.740.000.000.00168.74
James, Jeremiah, S,11661287.700.000.00104.97182.73
Stewart, Lucas, J,2934198.970.000.000.0098.97
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Chavez, Kara, P,13285214.350.000.00119.8994.46
Simmons, Dylan,16133107.850.000.0038.8868.97
Gonzales, Trevor, K,16085143.530.000.00143.530.00
Torres, Taylor,16666205.440.000.00123.9881.46
Phillips, Luis, G,207347.280.000.007.280.00
Chow, Candice,1923260.960.000.0021.9838.98
Sanders, Paige,252872983.340.002443.35539.990.00
Thompson, Brianna, X,1864269.970.000.0069.970.00
Sanders, Hailey,19647282.040.000.0086.45195.59
Perry, Dalton, A,16149192.040.000.0085.48106.56
Hill, Jordan, J,16005198.730.000.00102.2796.46
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Sanders, Sean,14341175.150.000.00111.9663.19
Flores, Hannah,1952540.230.000.000.0040.23
Anderson, Destiny,12895336.650.000.00123.21213.44
Scott, Allison,14497804.480.000.00804.480.00
Russell, Oscar, A,12140118.170.000.0032.2885.89
Thomas, Wyatt, R,12431154.540.000.00122.2632.28
Baker, Sara, M,11827512.470.000.00218.44294.03
Lopez, Bailey, R,185571179.470.000.001179.470.00
Hill, Carlos,12919257.880.000.00158.9398.95
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Bryant, Kyle,231644807.100.003578.271228.830.00
Rodriguez, Destiny, J,227397.280.000.007.280.00
Sharma, Kathryn,20740140.940.000.0080.9659.98
Davis, Marcus, T,17337123.910.000.00101.9321.98
Thomas, Ian,191181120.490.000.001120.490.00
Johnson, Christopher,119794813.760.000.004813.760.00
Coleman, Isabel, S,12530337.900.000.00262.9274.98
Wu, Randy, J,116472365.940.000.002365.940.00
Morgan, Timothy,14633242.500.000.0095.55146.95
Price, Marissa,15826160.740.000.00120.4840.26
Chen, Jack, E,17579151.430.000.000.00151.43
Gray, Cody, C,144594775.010.000.002376.962398.05
Umeda, Masaki,16717233.810.000.00159.3574.46
Martinez, Grace, M,17385208.690.000.0069.97138.72
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Patterson, Eric, A,2738478.980.000.0078.980.00
Thompson, Blake,18390141.960.000.0021.98119.98
Washington, Kayla, E,14655174.960.000.00174.960.00
Scott, Adam,15863243.010.000.00171.4371.58
Tang, Carl,2123832.270.000.0032.270.00
Gonzales, Ashley, C,1860051.970.000.0021.9829.99
Alexander, Aidan,17387148.190.000.00148.190.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Roberts, Thomas, J,219394163.243578.270.00584.970.00
Perez, Dalton,110911125.360.000.00471.29654.07
Torres, Pedro, E,16958168.020.000.00168.020.00
Russell, Samantha,11211723.560.000.00369.40354.16
Zukowski, Jake,220584118.263578.270.000.00539.99
Reed, Paige,221126047.323578.270.002469.050.00
Powell, Vanessa,26630699.10699.100.000.000.00
Butler, Victoria,132844767.530.000.004767.530.00
Morris, Abigail, C,287762.290.000.000.002.29
Dominguez, Meghan,14370122.560.000.000.00122.56
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Smith, John,198555709.963399.990.000.002309.97
Rogers, Carlos,19645134.440.000.00134.440.00
Brown, Isabella, L,266921266.86699.100.000.00567.76
Flores, Emily,13206163.190.000.0069.9793.22
Walker, Charles,11677298.210.000.0021.49276.72
King, Morgan,196811179.970.000.000.001179.97
Collins, Luis, J,227655978.613578.270.000.002400.34
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Turner, Courtney, A,229753578.273578.270.000.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Reed, Erin, I,14353128.840.000.00128.840.00
Miller, Chloe, V,228936056.510.003578.272478.240.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Long, Jordan,199884555.470.003399.990.001155.48
Russell, Jacqueline,18391100.960.000.00100.960.00
Flores, Megan, N,230746021.820.003578.270.002443.55
Davis, Nicholas,1320173.160.000.000.0073.16
Powell, Elijah, E,231135997.330.003578.270.002419.06
Thompson, Ethan,199894495.480.003374.990.001120.49
James, Juan,232674862.090.003578.271283.820.00
Flores, Logan, K,14631848.470.000.000.00848.47
Harris, Emily, P,1986298.480.000.004.9993.49
Ward, Angela, M,2775669.990.000.000.0069.99
Yang, Jordan, K,14458133.950.000.000.00133.95
Wilson, Tyler, L,15879196.930.000.00126.9669.97
Diaz, Elijah,200004495.480.003374.990.001120.49
Ware, Dennis, L,237254828.110.003578.271249.840.00
Garcia, Cameron,186411120.490.000.001120.490.00
Bryant, Connor,238424828.110.003578.270.001249.84
Young, Julia, J,274144.990.000.000.004.99
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Perry, Ana,112151155.520.000.00839.29316.23
Rodriguez, Joshua, A,235114843.110.003578.271264.840.00
Griffin, Julian, M,113284718.040.000.004718.040.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Campbell, Evan, W,243424828.110.003578.270.001249.84
Martinez, Jill,242354829.390.003578.270.001251.12
Davis, James,11922275.500.000.00131.55143.95
Russell, Isabella, A,11507645.780.000.00278.85366.93
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Yang, Thomas, A,14108839.480.000.00839.480.00
Murphy, Juan, T,246463578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Washington, Ian, M,246644368.580.003578.270.00790.31
Baker, Sean, T,247782858.490.002181.56676.930.00
Miller, Alexis, A,12196124.930.000.0054.9669.97
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Walker, John, M,2858969.990.000.0069.990.00
Green, Sophia, E,249772181.560.002181.560.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Diaz, Luke,12054402.530.000.00139.97262.56
Bennett, Maria, G,229837.280.000.000.007.28
Turner, Amanda, L,203183241.900.002071.420.001170.48
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Jones, Nicole,14504112.270.000.000.00112.27
Cook, Steven, J,27053782.990.00782.990.000.00
Suarez, Juan, R,167631700.990.000.001700.990.00
Rodriguez, Lucas, P,15942191.870.000.0069.99121.88
Harris, Edward,27062782.990.00782.990.000.00
Russell, Fernando,27084782.990.00782.990.000.00
Perry, Olivia,203754438.380.002071.420.002366.96
Lal, Luke, L,11019698.230.000.00305.18393.05
Gonzales, Melissa, W,204704408.690.002071.420.002337.27
Deng, Damien, A,16873578.460.000.000.00578.46
Perez, Jordan, A,292674.990.000.000.004.99
Thomas, Victoria, A,15536249.530.000.000.00249.53
Perez, Angel, S,213362628.350.000.002628.350.00
Washington, Elijah, L,250164.990.000.000.004.99
Walker, Emma, M,2520998.960.000.000.0098.96
Parker, Katherine,13268289.700.000.0068.97220.73
Wright, Jackson,11698225.950.000.00204.4621.49
Stewart, Grace, H,247737.280.000.007.280.00
Isla, Julian, A,13732108.960.000.0073.9635.00
Barnes, Fernando,113001390.550.000.00480.17910.38
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Smith, Tyler, J,2034156.970.000.000.0056.97
Reed, Marcus,14582111.790.000.0061.8149.98
Hall, Luke, E,14745902.460.000.000.00902.46
Robinson, Sarah, A,2702859.980.000.0059.980.00
Lewis, Isabella,2624267.930.000.0067.930.00
Smith, Lucas, P,1809064.910.000.0064.910.00
Lopez, Katelyn,11820232.710.000.00127.74104.97
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Peterson, Jared,11502829.370.000.00446.84382.53
Thompson, Isabella,18756128.410.000.000.00128.41
Brown, Samantha, G,2514739.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Washington, Thomas, C,2745137.430.000.000.0037.43
Ross, Alexia, S,13231247.900.000.00104.97142.93
Green, Blake, P,11719287.200.000.00224.9262.28
Townsend, Bryan,14077180.730.000.000.00180.73
Dominguez, Erika, C,21251191.270.000.0024.99166.28
Taylor, Christian,2076456.760.000.0049.487.28
Clark, William,2902169.990.000.000.0069.99
Carter, Sydney,12959203.920.000.0034.98168.94
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Ramirez, Sydney,267007.280.000.007.280.00
Green, Gabriella, C,2803569.990.000.0069.990.00
Smith, Alexandra,2829261.960.000.0061.960.00
Hall, Amber,20106131.950.000.00131.950.00

Generated 2026-07-21 19:37:38.802 UTC