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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Chander, Wayne, S,243444329.610.003578.27751.340.00
Ward, Emma, W,2179659.980.000.000.0059.98
Garcia, Christian, J,164913106.330.000.00751.342354.99
Young, Julia, J,274144.990.000.000.004.99
Zukowski, Jake,220584118.263578.270.000.00539.99
Barnes, Emily, G,15996564.990.000.000.00564.99
Parker, Katherine,13268289.700.000.0068.97220.73
Rivera, Ariana,261734.990.000.000.004.99
Shan, Chad, M,2462112.940.000.000.0012.94
Fernandez, Darren,2899278.980.000.000.0078.98
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Thomas, Samantha,2169093.970.000.000.0093.97
Henderson, Ashley,111851381.370.000.00232.801148.57
Henderson, Caroline,2008256.970.000.000.0056.97
Suarez, Juan, R,167631700.990.000.000.001700.99
Griffin, Jack, L,1768632.280.000.000.0032.28
Hayes, Jason,261764.990.000.000.004.99
Hughes, Luis,130841798.960.000.000.001798.96
Perry, Lauren,248164.990.000.000.004.99
Carter, Marcus, l,2147131.970.000.000.0031.97
Thompson, Joshua, F,259992181.560.000.002181.560.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Coleman, Vanessa,215892589.090.000.002049.10539.99
Murphy, Juan, T,246463578.270.003578.270.000.00
Price, Oscar, G,11833240.010.000.000.00240.01
Gray, Sebastian, B,138782366.960.000.000.002366.96
Powell, Vanessa,26630699.100.00699.100.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Gomez, Renee, L,253712181.560.002181.560.000.00
Smith, Alexandra,2829261.960.000.000.0061.96
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Stewart, Olivia, B,1874923.780.000.000.0023.78
Lewis, Rachel, J,14900839.480.000.000.00839.48
Hall, Noah, A,1525175.250.000.000.0075.25
Reed, Paige,221126047.323578.270.002469.050.00
Wilson, Nathan, L,13936218.930.000.000.00218.93
Rubio, Ruben, D,1887186.960.000.0086.960.00
Davis, Nicholas,1320173.160.000.000.0073.16
Coleman, Miguel, D,2740069.990.000.0069.990.00
Evans, Dalton, E,127104774.040.000.002354.982419.06
Alexander, Angelica,2271471.950.000.000.0071.95
Green, Mackenzie, C,280737.280.000.000.007.28
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Jackson, Charles, P,112771305.660.000.00237.821067.84
Gomez, Krista,12760273.180.000.0036.27236.91
Torres, Mackenzie,28153570.470.000.000.00570.47
Powell, Caleb, G,216132610.580.000.002049.10561.48
Coleman, Stephanie,2226489.970.000.000.0089.97
Gonzalez, Molly,1637021.980.000.000.0021.98
Scott, Sean, F,2475539.980.000.000.0039.98
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Hall, Natalie, A,230704.990.000.004.990.00
Robinson, Julia,28121119.980.000.000.00119.98
Green, Gabriella, C,2803569.990.000.000.0069.99
Long, Gavin,13762186.030.000.0036.59149.44
Gray, Cody, C,144594775.010.000.000.004775.01
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Coleman, Dylan,27403132.970.000.000.00132.97
Roberts, Amber, W,215822638.060.000.002049.10588.96
Walker, Thomas,1307193.980.000.000.0093.98
Taylor, Tyler, A,12032614.960.000.00614.960.00
Collins, Isaac,260777.280.000.000.007.28
Sanchez, Trinity, J,262792181.560.000.002181.560.00
White, Greg, C,174032322.280.000.000.002322.28
Smith, Zachary, W,2378358.980.000.0058.980.00
Murphy, Shelby,244894.990.000.000.004.99
Walker, Jacob, N,29027574.980.000.000.00574.98
Henderson, Hailey, C,171481775.470.000.000.001775.47
Bryant, Nathan,2145059.980.000.000.0059.98
Stewart, Sara,17347119.720.000.000.00119.72
Foster, Kayla,1969371.950.000.000.0071.95
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Miller, Joseph, A,227134148.190.003578.270.00569.92
Bailey, Hailey, R,262704.990.000.000.004.99
Morris, Mason, J,22349124.990.000.000.00124.99
Bradley, Evan,18506101.940.000.000.00101.94
Long, Rachel,2828339.980.000.000.0039.98
Gray, Sara,292472447.050.000.002447.050.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Johnson, Ian, E,2173283.470.000.000.0083.47
Kumar, Zachary,254334.990.000.000.004.99
Murphy, Emma,198445807.930.003374.990.002432.94
Robinson, Lauren,2719668.490.000.0068.490.00
Moreno, Renee, C,12936265.220.000.000.00265.22
Phillips, Kaylee,211384371.380.000.002049.102322.28
Davis, Emily,27267782.990.000.00782.990.00
Gray, Marcus, T,183892401.450.000.000.002401.45
Thomas, Ian,191181120.490.000.000.001120.49
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Nelson, Henry,193941155.480.000.000.001155.48
Kelly, Bryan,213492989.380.000.002989.380.00
Hall, Fernando,2210090.950.000.000.0090.95
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Long, Julia, R,228895971.330.003578.270.002393.06
Phillips, Jack, R,259952443.350.000.002443.350.00
Baker, Allison,2649558.980.000.000.0058.98
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Butler, Cassidy, L,21792114.460.000.000.00114.46
Williams, Ian, M,175581750.470.000.000.001750.47
Watson, Janet, S,2320859.980.000.000.0059.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Stewart, Melissa,2517336.960.000.000.0036.96
Collins, Luis, J,227655978.610.003578.270.002400.34
Reed, Judith, D,2534759.980.000.000.0059.98
Ramirez, Ian,166783162.310.000.00742.352419.96
Taylor, Zachary, M,27082782.990.000.00782.990.00
Russell, Oscar, A,12140118.170.000.000.00118.17
Roberts, Robert, R,1898656.970.000.0056.970.00
Martin, Madison, C,2049271.970.000.0071.970.00
Fernandez, Ruth,205463246.550.000.002049.101197.45
James, Richard, D,15760109.230.000.003.99105.24
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Campbell, Hailey,15507267.840.000.00228.9638.88
Thompson, Kayla, D,12363273.900.000.000.00273.90
Wilson, Emily,174002331.950.000.000.002331.95
Edwards, Hailey,242584.990.000.000.004.99
Gonzalez, Morgan,130651700.990.000.000.001700.99
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Thompson, Abigail,243324816.090.003578.270.001237.82
Harris, Noah,292562393.060.000.002393.060.00
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Ward, Eduardo, I,139162354.980.000.000.002354.98
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Moreno, Marie,2773969.990.000.000.0069.99
Murphy, Maria,160113657.260.000.000.003657.26
Roberts, Jordan, M,1680039.250.000.000.0039.25
Wright, Jennifer,2650559.980.000.0059.980.00
Wang, Zachary,2214489.970.000.000.0089.97
Barnes, Elizabeth, J,249397.280.000.000.007.28
Watson, Emma,17481126.940.000.000.00126.94
Reed, Megan, A,181181750.980.000.000.001750.98
Thompson, Xavier, R,15761192.410.000.000.00192.41
Collins, Amanda,2078339.980.000.000.0039.98
Rodriguez, Destiny, J,227397.280.000.007.280.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Perry, Justin, E,167583062.340.000.000.003062.34
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Grace, A,201894.990.000.000.004.99
Cox, Arianna, D,1892789.250.000.000.0089.25
Davis, Jonathan,2925913.980.000.000.0013.98
Thompson, Tyler,2750269.990.000.0069.990.00
Hernandez, Marcus,185952329.990.000.000.002329.99
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Sánchez, Angela, C,176551750.980.000.000.001750.98
Sanders, Lucas, W,268024.990.000.000.004.99
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Sanchez, Faith,270494.990.000.000.004.99
Diaz, Thomas, O,16020595.960.000.000.00595.96
Bryant, Gabriel,2765669.990.000.000.0069.99
Rogers, Faith,2468259.980.000.000.0059.98
Moore, Andrew, A,13944150.130.000.0036.27113.86
Powell, Jack, J,1841156.960.000.000.0056.96
Hall, Amber,20106131.950.000.000.00131.95
Roberts, Amanda,171752334.980.000.000.002334.98
Coleman, Ian,2127639.980.000.000.0039.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Moore, Wyatt, F,189712351.960.000.000.002351.96
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Price, Marissa,15826160.740.000.00120.4840.26
Allen, Madeline,2924068.970.000.000.0068.97
Rivera, Rachel, S,2899678.980.000.000.0078.98
Baker, Ian, V,262002756.540.000.002181.56574.98
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Thompson, Jose,237314828.110.003578.270.001249.84
Jones, Michael, A,2210771.970.000.000.0071.97
Evans, James, C,206654408.560.000.002049.102359.46
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Simmons, Adam,253274.990.000.000.004.99
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Hayes, Carson, A,124472331.950.000.000.002331.95
Ramirez, Sydney,267007.280.000.000.007.28
Young, Savannah,259712749.320.002181.560.00567.76
Williams, Zachary, B,27099782.990.000.00782.990.00
Sharma, Thomas, A,18637121.940.000.000.00121.94
Perez, Charles,266937.280.000.007.280.00
Gutierrez, Jerome,127832420.460.000.000.002420.46
Ramos, Derrick,18449100.940.000.0030.9769.97
Martin, Brandon, S,2169139.980.000.000.0039.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Washington, Thomas, C,2745137.430.000.000.0037.43
Stewart, Amanda, M,1531094.440.000.000.0094.44
Alexander, Edward, E,18524195.950.000.000.00195.95
Stewart, Cody, A,212843223.580.000.002049.101174.48
Sanchez, Martin, E,216317.280.000.000.007.28
Alexander, Thomas,207607.280.000.000.007.28
Winston, Ethan, R,216222612.060.000.002049.10562.96
Li, Rafael, M,217527.280.000.000.007.28
Ross, Anna, D,15494275.440.000.0029.99245.45
Smith, Noah,13175166.920.000.000.00166.92
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Nelson, James, L,245257.280.000.007.280.00
Chen, Jonathan, G,13096200.690.000.000.00200.69
Ross, Kelly,2607676.960.000.000.0076.96
Lazecky, Petr,258642443.350.002443.350.000.00
Sandberg, Chase,2190475.970.000.000.0075.97
Simmons, Dylan,16133107.850.000.0038.8868.97
Roberts, Seth, H,11510258.150.000.0039.47218.68
Mitchell, Evan, R,247314.990.000.000.004.99
Sun, Arturo, C,11498557.540.000.0072.92484.62
James, Morgan, E,2324539.980.000.000.0039.98
James, Adrian, C,253404.990.000.000.004.99
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Hernandez, Jamie,27283119.980.000.00119.980.00
Morgan, Isaiah,18978118.730.000.000.00118.73
Jai, Kevin,1983678.960.000.0038.9839.98
Bryant, Samantha,18345115.470.000.000.00115.47
Washington, Miranda,152014793.020.000.000.004793.02
Phillips, Aaron, R,2494739.980.000.000.0039.98
Coleman, Jose, S,253494.990.000.000.004.99
Butler, Ana,260403018.330.000.002443.35574.98
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Blue, Paige,2170313.980.000.000.0013.98
Brown, Jonathan,11875265.420.000.000.00265.42
Rowe, Todd,14586233.940.000.000.00233.94
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Collins, Allison,28581119.980.000.000.00119.98
Morris, Seth,189592341.460.000.000.002341.46
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Gomez, Rebekah,13486225.440.000.000.00225.44
Hall, Lauren, A,19648100.840.000.000.00100.84
Watson, Erin, B,227724.990.000.004.990.00
Sanders, Zoe, L,248254.990.000.000.004.99
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Davis, Daniel,11711999.220.000.0086.48912.74
Wang, Benjamin, R,274547.280.000.000.007.28
Clark, Zachary, J,2389358.980.000.000.0058.98
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Jones, Joshua,184012294.990.000.000.002294.99
Moore, Taylor, A,199874564.450.003374.990.001189.46
Collins, Xavier, C,16646250.910.000.000.00250.91
Hall, Jason, A,29351119.980.000.000.00119.98
Rogers, Paige, H,17125539.990.000.000.00539.99
Wright, Carol, C,12928247.410.000.0033.98213.43
Martinez, Carol, D,17656578.460.000.000.00578.46
Wright, Robert, C,158894848.030.000.000.004848.03
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Collins, Sierra,185491169.460.000.001169.460.00
Young, Kaylee, S,13756298.490.000.0058.47240.02
Howard, Alyssa, A,11513863.950.000.000.00863.95
Collins, Eduardo,139872329.990.000.000.002329.99
Johnson, Madison, L,15530846.460.000.000.00846.46
Ward, Jade, D,14661195.020.000.000.00195.02
Price, Rachel, D,2532889.970.000.000.0089.97
Sanders, Megan, A,15376136.240.000.000.00136.24
Smith, Katherine, J,13197105.190.000.000.00105.19
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Cook, Seth,2301064.470.000.000.0064.47
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Adams, Hailey, M,121544798.530.000.002379.472419.06
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Long, Sarah,173721729.970.000.000.001729.97

Generated 2025-11-03 19:39:30.301 UTC