[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   SKIP 500   <  SKIP 750  >   <  TAKE 1000   

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Green, Marcus, C,15974208.410.000.000.00208.41
Flores, Logan, K,14631848.470.000.000.00848.47
Griffin, Maria,1840763.250.000.000.0063.25
Stewart, Jessica,16097103.550.000.009.9993.56
Garcia, Cameron,186411120.490.000.000.001120.49
Campbell, Kevin, S,121774811.500.000.000.004811.50
Smith, Katherine, J,13197105.190.000.000.00105.19
Fernandez, Darren,2899278.980.000.000.0078.98
Lal, Jonathan,2009671.460.000.000.0071.46
Simmons, Sarah, V,11500651.980.000.0034.99616.99
Roberts, Thomas, J,219394163.240.003578.270.00584.97
Walker, John, M,2858969.990.000.000.0069.99
Ortega, Byron,233064828.110.003578.270.001249.84
Parker, Natalie, A,251043018.330.000.002443.35574.98
Lopez, Carlos,186171147.770.000.000.001147.77
Murphy, Shelby,244894.990.000.000.004.99
Anderson, Emma, A,185801170.480.000.000.001170.48
Gonzales, Luis,15856116.250.000.0037.2778.98
Stewart, Grace, H,247737.280.000.000.007.28
Diaz, Luke,12054402.530.000.00124.99277.54
Bennett, Maria, G,229837.280.000.000.007.28
Phillips, James, G,16846180.950.000.000.00180.95
Turner, Blake,12136131.740.000.000.00131.74
Edwards, Connor,16950211.010.000.000.00211.01
Morris, Paige, W,220414167.233578.270.000.00588.96
Brown, Dalton, N,218134118.260.003578.270.00539.99
Stewart, Julia, L,129022329.980.000.000.002329.98
Price, Miranda,26629699.100.00699.100.000.00
Zukowski, Jake,220584118.260.003578.270.00539.99
Murphy, Emma,198445807.930.003374.990.002432.94
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Bell, Gabrielle,223735976.320.003578.270.002398.05
Bailey, Hailey, R,262704.990.000.000.004.99
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Phillips, Adam, R,227484188.240.003578.270.00609.97
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Howard, Morgan, T,229713578.270.003578.270.000.00
Miller, Chloe, V,228936056.510.003578.270.002478.24
Thomas, Alexandra, C,231724809.390.003578.270.001231.12
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Morris, Chase, F,26789699.100.00699.100.000.00
Washington, Caroline, D,231145996.320.003578.270.002418.05
Flores, Megan, N,230746021.820.003578.270.002443.55
Torres, Taylor,16666205.440.000.000.00205.44
Shan, Benjamin,235663578.270.003578.270.000.00
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Anderson, Megan, A,238594153.250.003578.27574.980.00
Campbell, Evan, W,243424828.110.003578.270.001249.84
Lopez, Jack, I,2904751.460.000.000.0051.46
Flores, Xavier,238664828.110.003578.270.001249.84
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Hayes, Oscar,2652729.260.000.000.0029.26
Williams, Ethan,243094793.120.003578.270.001214.85
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Murphy, Juan, T,246463578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Gray, Alexandria, E,253632443.350.000.002443.350.00
Cox, Lucas, J,253932443.350.000.002443.350.00
Clark, Anthony,27071782.990.000.00782.990.00
Chen, Jackson, S,270751371.950.000.00782.99588.96
Clark, Lauren,170341750.980.000.000.001750.98
Campbell, Hailey,15507267.840.000.00228.9638.88
Gonzales, Nathan, M,12107222.230.000.000.00222.23
Hall, Charles,234764.990.000.000.004.99
Phillips, Miguel,2049812.940.000.000.0012.94
Reed, Mariah,263731565.910.000.001000.44565.47
Kumar, Austin,204834400.060.000.002049.102350.96
Hill, Sydney,264821000.440.000.001000.440.00
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Cooper, Christina, C,265121000.440.000.001000.440.00
Perry, Marcus, L,206563245.900.000.002071.421174.48
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Evans, James, C,206654408.560.000.002049.102359.46
Anderson, Ashley,206803219.580.000.002049.101170.48
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Taylor, Victoria,260132443.350.000.002443.350.00
Ward, Nicole, L,212724435.380.000.002071.422363.96
Foster, Deb,215012661.400.000.002661.400.00
Ward, Juan, H,215952649.560.000.002049.10600.46
Smith, Justin, P,1982721.980.000.000.0021.98
Jackson, Hannah, G,131432404.970.000.000.002404.97
Hughes, Eduardo,15564188.520.000.000.00188.52
Robinson, Sarah, A,2702859.980.000.000.0059.98
Smith, Lucas, P,1809064.910.000.000.0064.91
Butler, Morgan, E,2050068.490.000.000.0068.49
Zeng, Jake,18054106.930.000.000.00106.93
Watson, Michelle, H,262352181.560.000.002181.560.00
Ramirez, Sydney,267007.280.000.000.007.28
Smith, Samuel, D,2308349.900.000.000.0049.90
Johnson, Andrew, F,262942443.350.000.002443.350.00
Russell, Jessica,265721000.440.000.001000.440.00
Carter, Elijah,216182611.070.000.002611.070.00
Walker, Brandon, J,159164793.270.000.000.004793.27
Wilson, Victoria, R,27536782.990.000.00782.990.00
Williams, Edward, D,14274121.560.000.000.00121.56
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Washington, Alexia,27613782.990.000.00782.990.00
Green, Gabriella, C,2803569.990.000.000.0069.99
Washington, Riley, L,185441155.480.000.001155.480.00
Hill, Haley, J,161033142.320.000.000.003142.32
Cox, Katelyn, B,2174230.970.000.000.0030.97
Cooper, Alexandra,19541131.240.000.000.00131.24
Davis, Richard, R,15549574.980.000.00574.980.00
Jackson, Edward,290422420.340.000.002420.340.00
Johnson, Anthony, D,270224.990.000.000.004.99
Nelson, Sierra,161322459.620.000.002459.620.00
Hughes, Isabella,2304851.460.000.000.0051.46
Sanders, Allison, B,18852268.250.000.000.00268.25
Garcia, Chloe, M,110372374.230.000.002374.230.00
Martinez, Kristina, S,2134529.930.000.000.0029.93
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Price, Lauren, J,14079184.740.000.0037.29147.45
Diaz, Hailey, W,116932294.990.000.002294.990.00
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Hayes, Carson, A,124472331.950.000.000.002331.95
Hall, Lauren, A,19648100.840.000.000.00100.84
Hall, Noah, A,1525175.250.000.000.0075.25
Chavez, Kara, P,13285214.350.000.000.00214.35
Nelson, Jordan, H,201304.990.000.004.990.00
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Barnes, Haley, J,2133939.980.000.0039.980.00
Davis, Ethan,136604750.010.000.000.004750.01
Parker, Caleb, A,2631813.980.000.000.0013.98
Diaz, Alyssa,139084715.330.000.000.004715.33
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Griffin, Jack, L,1768632.280.000.000.0032.28
Rodriguez, Cesar, L,2533559.980.000.000.0059.98
Alexander, Jordan,2141259.980.000.000.0059.98
Alexander, Paige, W,1860459.250.000.000.0059.25
Phillips, Isaiah,28631144.470.000.000.00144.47
Harris, Natalie,2368259.980.000.000.0059.98
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Eduardo, S,2896962.980.000.000.0062.98
Price, Mariah, C,2074549.480.000.000.0049.48
Wilson, Madison, H,1982821.980.000.000.0021.98
Flores, Devin, A,15559172.040.000.000.00172.04
Peterson, Steven, L,234497.280.000.000.007.28
Barnes, Emily, G,15996564.990.000.000.00564.99
Hall, Kaylee, E,1975137.270.000.000.0037.27
Gray, Isabella,168203217.790.000.000.003217.79
Turner, Morgan,11823178.470.000.000.00178.47
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Prasad, Summer, M,2214339.980.000.000.0039.98
Wu, Randy, J,116472365.940.000.000.002365.94
Murphy, Chase, J,2472958.980.000.000.0058.98
Miller, Kayla, A,236734.990.000.000.004.99
Foster, Kayla,1969371.950.000.000.0071.95
Brooks, Lucas, S,16089342.030.000.000.00342.03
Morris, Jessica,289678.990.000.000.008.99
Price, Devin, M,18758158.510.000.000.00158.51
Carter, Jesse, E,22141166.280.000.000.00166.28
Wilson, Nathan, L,13936218.930.000.000.00218.93
Yuan, Leonard, F,167911729.970.000.000.001729.97
Coleman, Spencer,15993597.260.000.000.00597.26
Sanchez, Jared, J,2585064.470.000.000.0064.47
Kennedy, Bridget,2202639.980.000.000.0039.98
Blue, Paige,2170313.980.000.000.0013.98
Evans, Alexandra,2432268.490.000.000.0068.49
Turner, James, E,16841126.960.000.000.00126.96
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Bryant, Jackson, J,2533239.980.000.000.0039.98
Ruiz, Philip,1807781.460.000.000.0081.46
Perry, Benjamin,291652407.040.000.000.002407.04
Hill, Eric, G,2525667.930.000.000.0067.93
Bryant, Rachel,220197.280.000.000.007.28
Chen, Ethan,2054756.970.000.000.0056.97
Ward, Natalie, J,132412325.960.000.000.002325.96
Sandberg, Chase,2190475.970.000.000.0075.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Simmons, Nicole, S,2617729.480.000.000.0029.48
Smith, Zachary, W,2378358.980.000.000.0058.98
Moreno, Lance, A,2922939.980.000.000.0039.98
Flores, Miguel,1975077.250.000.000.0077.25
Lewis, Ethan,27998144.470.000.000.00144.47
Ross, Miranda,145984839.000.000.000.004839.00
Cooper, Angela,195261179.470.000.000.001179.47
Bailey, Olivia,238924.990.000.000.004.99
Brooks, Evan,2340139.980.000.000.0039.98
Ross, Seth, M,184332329.980.000.000.002329.98
Johnson, Ian, E,2173283.470.000.000.0083.47
Wilson, Andrew, R,182362414.990.000.000.002414.99
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Watson, Shelby, J,14911867.970.000.000.00867.97
Nelson, Adam, B,27402128.970.000.000.00128.97
Morgan, Isabella, L,28602144.470.000.000.00144.47
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Williams, Ian, M,175581750.470.000.000.001750.47
Turner, Adam, K,16109548.980.000.000.00548.98
Thomas, Emily,2180339.980.000.000.0039.98
Morris, Alyssa,28072548.980.000.000.00548.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Kumar, Zachary,254334.990.000.000.004.99
Sanders, Isaiah,2587339.980.000.000.0039.98
Morris, Seth,189592341.460.000.000.002341.46
Lee, Ian,19646197.040.000.000.00197.04
Alexander, Thomas,207607.280.000.000.007.28
Henderson, Luke,19200109.240.000.000.00109.24
Patterson, Natalie,16123629.970.000.000.00629.97
Anderson, Isabella,137432349.980.000.000.002349.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Stewart, Olivia, B,1874923.780.000.000.0023.78
Lee, Don,188392384.970.000.000.002384.97
Moore, Seth,138512331.950.000.000.002331.95
Robinson, Zachary, L,137092332.280.000.000.002332.28
Brown, Morgan,2919778.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Miller, Andrew, C,271104.990.000.000.004.99
Lee, Alexander, S,18356149.910.000.000.00149.91
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Anand, Brendan, L,1984721.980.000.000.0021.98
Moore, Wyatt, F,189712351.960.000.000.002351.96
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Barnes, Dalton, C,178581700.990.000.000.001700.99
Martinez, Carol, D,17656578.460.000.000.00578.46
Griffin, Miguel,2146476.970.000.000.0076.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Russell, Caleb,23552103.480.000.000.00103.48
Hayes, Dalton, C,188822322.280.000.000.002322.28
Edwards, Hailey,242584.990.000.000.004.99
Jones, Dalton, T,189512334.970.000.000.002334.97
Smith, Megan, J,2671668.970.000.000.0068.97
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Diaz, Trevor, B,2051954.960.000.000.0054.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Moore, Ian, L,2463939.980.000.000.0039.98
Perry, Jackson, J,213064.990.000.000.004.99
Bell, Chase,180911750.980.000.000.001750.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Jones, Alexandra, B,2020245.950.000.000.0045.95
Garcia, Kayla, L,2130881.460.000.000.0081.46
Gonzalez, Molly,1637021.980.000.000.0021.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Perry, James,192051249.840.000.000.001249.84
Blanco, Armando, F,139182397.950.000.000.002397.95
Howard, Danielle,28357133.490.000.000.00133.49
Kelly, Bailey, R,28284563.770.000.000.00563.77
Ward, Lucas, N,183631700.990.000.000.001700.99
Chen, David,2720839.980.000.000.0039.98
Collins, Charles, B,29041628.450.000.000.00628.45
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kapoor, Preston,2143156.970.000.000.0056.97
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
_SUM1806517.5025543.71492798.22255388.121032787.45

Generated 2025-12-24 07:38:11.178 UTC