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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hill, Jordan, J,16005198.730.000.00102.2796.46
Hernandez, Jamie,27283119.980.000.00119.980.00
Chen, Luis, G,2125294.450.000.0094.450.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Patterson, Natalie,16123629.970.000.000.00629.97
Hill, Carlos,12919257.880.000.00158.9398.95
Lopez, Bailey, R,185571179.470.000.001179.470.00
Perez, Amber, D,13318214.260.000.00116.9197.35
Jones, Natalie, A,11845197.200.000.0082.26114.94
Brown, Fernando,1900191.950.000.0069.9721.98
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Walker, Brandon, J,159164793.270.000.000.004793.27
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Gabriel,2765669.990.000.000.0069.99
Hughes, Jasmine,276284.990.000.000.004.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Barnes, Ian, M,16106133.540.000.000.00133.54
Lewis, Zachary, L,14760167.260.000.000.00167.26
Prasad, Summer, M,2214339.980.000.0039.980.00
Martin, Noah, A,1765775.970.000.0075.970.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Collins, Sierra,185491169.460.000.001169.460.00
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
White, James,253317.280.000.000.007.28
Washington, Ryan,2833294.480.000.000.0094.48
Flores, Gabriel,271117.280.000.000.007.28
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Patterson, Abigail, H,144784795.010.000.000.004795.01
Martin, Nicholas,233627.280.000.000.007.28
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Scott, Eric,282484.990.000.004.990.00
Walker, Ian,16771104.550.000.0054.5849.97
Sanders, Angel,16219553.970.000.000.00553.97
Richardson, Evan, J,15488165.300.000.000.00165.30
Gonzales, Jose,2201439.980.000.000.0039.98
Ward, Mariah, J,2158044.910.000.000.0044.91
Sanders, Allison, B,18852268.250.000.000.00268.25
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Stewart, Olivia, B,1874923.780.000.000.0023.78
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Anand, Brendan, L,1984721.980.000.000.0021.98
Lee, Don,188392384.970.000.000.002384.97
Moore, Wyatt, F,189712351.960.000.000.002351.96
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Smith, Hannah, J,2526554.980.000.0054.980.00
Griffin, Melissa, L,287807.950.000.000.007.95
Lewis, Morgan,17410168.740.000.000.00168.74
Cooper, Brian, L,13760128.840.000.000.00128.84
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Wang, Benjamin, R,274547.280.000.000.007.28
Russell, Richard,2763322.260.000.000.0022.26
Gray, Seth, M,2008785.480.000.000.0085.48
Cannata, Gabrielle, C,217254.990.000.000.004.99
Wang, Karen, P,1955331.970.000.000.0031.97
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Adams, Jennifer,153624745.020.000.000.004745.02
Simmons, David, E,120172339.970.000.002339.970.00
Stewart, Melissa,2517336.960.000.000.0036.96
Torres, Dalton,235037.280.000.007.280.00
Torres, Victoria,17551160.920.000.000.00160.92
Taylor, Taylor,159054899.020.000.000.004899.02
Edwards, Amber, B,2051776.970.000.000.0076.97
Hill, Timothy,14871848.470.000.000.00848.47
Foster, Jose, C,2878534.990.000.000.0034.99
Clark, Destiny, L,28600119.980.000.000.00119.98
Richardson, Brian,2860878.980.000.000.0078.98
Henderson, Abigail,2044139.980.000.000.0039.98
White, Nicole,16731155.910.000.0084.9670.95
Jones, Charles,22882101.450.000.000.00101.45
Lee, Alexander, S,18356149.910.000.000.00149.91
Carter, Jesse, E,22141166.280.000.000.00166.28
Simmons, Adam,253274.990.000.000.004.99
Johnson, Jonathan,220597.280.000.000.007.28
Powell, Katherine, C,14574177.600.000.000.00177.60
Blue, Paige,2170313.980.000.000.0013.98
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Watson, Devin, A,18875114.950.000.000.00114.95
Gray, Cindy, A,13198114.950.000.0099.9714.98
Brown, Julia,18065155.470.000.000.00155.47
Rodriguez, Julia, A,264884.990.000.004.990.00
Roberts, Rebecca,2800094.480.000.000.0094.48
Taylor, Edward, C,17442319.880.000.00230.9088.98
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Diaz, Brandon,236764.990.000.004.990.00
Rowe, Todd,14586233.940.000.000.00233.94
Flores, Morgan,19817118.940.000.0039.9878.96
Peterson, Xavier, R,2645639.980.000.000.0039.98
Flores, Brittany,169062359.980.000.000.002359.98
Wilson, Eduardo,15323804.470.000.000.00804.47
Kelly, Trinity,2609515.230.000.000.0015.23
Martinez, Carol, D,17656578.460.000.000.00578.46
Hill, Eric, G,2525667.930.000.0067.930.00
Moreno, Lance, A,2922939.980.000.000.0039.98
Stewart, Garrett, O,15762564.480.000.000.00564.48
Gutierrez, Neil, L,214897.280.000.000.007.28
Russell, Samuel, V,11652310.930.000.000.00310.93
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Roberts, Amanda,171752334.980.000.000.002334.98
Diaz, Faith, M,2236356.970.000.000.0056.97
Flores, Hannah,1952540.230.000.000.0040.23
Walker, Richard, T,19640224.550.000.000.00224.55
Thompson, Madison, L,187882351.960.000.000.002351.96
Sanchez, Shelby,16021539.990.000.000.00539.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Roberts, Hunter,282607.280.000.000.007.28
Collins, Isaac,260777.280.000.000.007.28
Foster, Paige,2742894.480.000.000.0094.48
Rivera, Amanda,11131115.920.000.000.00115.92
Davis, Dylan,15556588.960.000.00588.960.00
Chen, Jack, E,17579151.430.000.000.00151.43
Foster, Jessica,2606951.460.000.0051.460.00
Hayes, Dalton, C,188822322.280.000.000.002322.28
Hughes, Caroline, C,2830278.980.000.0078.980.00
Anderson, Ryan, W,132712319.990.000.000.002319.99
Adams, Mason, T,2052864.470.000.0064.470.00
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Washington, Emma,191231170.480.000.000.001170.48
Howard, Erin, L,183621725.210.000.000.001725.21
Martin, Christian, V,19709197.250.000.000.00197.25
Parker, Kaylee, M,2773878.980.000.000.0078.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Edwards, Alexandra,133582386.940.000.000.002386.94
Price, Rachel, D,2532889.970.000.000.0089.97
Foster, Isabelle,2637739.980.000.000.0039.98
Deng, Wayne,2145336.960.000.0036.960.00
Ma, Tiffany,2157739.980.000.000.0039.98
Roberts, Wyatt,15900699.970.000.00699.970.00
Bailey, Maria, C,1915034.980.000.000.0034.98
Peterson, Mason, A,185701174.480.000.001174.480.00
Reed, Morgan, E,2877923.970.000.000.0023.97
Perry, Natalie,1712669.990.000.000.0069.99
Baker, Gabriella,174041709.980.000.000.001709.98
Evans, Jesse,2191639.980.000.000.0039.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Baker, Mason, A,132702394.950.000.000.002394.95
Griffin, Seth, R,17585164.460.000.0078.9885.48
Stewart, Alexandria,174761700.990.000.000.001700.99
Mitchell, Bailey, B,267067.280.000.007.280.00
Hayes, Jason,261764.990.000.000.004.99
Morgan, Evan, G,14725318.830.000.0069.97248.86
Malhotra, Brenda,133912405.470.000.000.002405.47
Kumar, Elijah,15197156.920.000.000.00156.92
Diaz, Gabrielle,14893839.480.000.000.00839.48
Miller, Jill,129142329.980.000.000.002329.98
Sanchez, Rachel, C,267304.990.000.000.004.99
Flores, Julia, E,172631700.990.000.000.001700.99
Yuan, Brendan, S,247444.990.000.000.004.99
Morgan, Marcus, W,289682.290.000.000.002.29
Collins, Jonathan,16849119.980.000.000.00119.98
White, Emily, M,159174679.060.000.000.004679.06
Stewart, Gabriella,2803469.990.000.000.0069.99
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Li, Eugene, A,15283865.950.000.000.00865.95
Harris, Joshua, L,2028095.940.000.0030.9764.97
Hall, Jason, A,29351119.980.000.000.00119.98
Chandra, Allen,2932753.990.000.000.0053.99
Thompson, Lucas, O,212774.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Henderson, Austin,2764354.980.000.000.0054.98
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Jackson, Andrew,2047985.480.000.000.0085.48
Coleman, Dylan,27403132.970.000.000.00132.97
Ross, Seth, M,184332329.980.000.000.002329.98
Li, Thomas,181162376.960.000.000.002376.96
Jones, Alexandra, B,2020245.950.000.000.0045.95
White, Emma, N,16090604.960.000.000.00604.96
Johnson, Madison, L,15530846.460.000.000.00846.46
Alexander, Gavin, K,2932249.990.000.000.0049.99
Griffin, James,28189567.760.000.000.00567.76
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Torres, Abigail,253674.990.000.000.004.99
Young, Jenna, W,163652490.180.000.000.002490.18
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Gill, Robyn, J,127651750.980.000.001750.980.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Harris, Noah,292562393.060.000.002393.060.00
Wang, Zachary,2214489.970.000.000.0089.97
Gray, Isabella,168203217.790.000.000.003217.79
Harris, Samantha, A,244874.990.000.000.004.99
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Watson, Erin, B,227724.990.000.004.990.00
Smith, Eduardo,2069139.980.000.0039.980.00
Van, Bobby,27757132.970.000.00132.970.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Long, Gavin,13762186.030.000.0036.59149.44
Srini, Ruben,18078200.940.000.0071.97128.97
Hughes, Antonio, P,15913712.270.000.00712.270.00
Sanchez, Katherine, S,24399132.940.000.00132.940.00
Reed, Isaac, D,260747.280.000.000.007.28
Nelson, Kevin,1476584.970.000.000.0084.97
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Evans, Alexandra,2432268.490.000.000.0068.49
Perez, Timothy, L,227304.990.000.000.004.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Brooks, Steven, C,14877889.470.000.000.00889.47
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Edwards, Elijah, D,281577.280.000.000.007.28
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Alexander, Sarah,1941129.990.000.000.0029.99
Wood, Brittany,2877753.990.000.000.0053.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Brooks, Evan,2340139.980.000.000.0039.98
Jackson, Victoria,270194.990.000.000.004.99
Russell, Caleb,23552103.480.000.000.00103.48
Adams, Julia, N,2607359.980.000.000.0059.98
Smith, Megan, J,2671668.970.000.000.0068.97
Rivera, Sara,187852350.960.000.000.002350.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Alvarez, Melody,2507068.490.000.000.0068.49
Scott, Mason,2355139.980.000.000.0039.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Stewart, Marcus, R,2063221.980.000.000.0021.98
Martin, Tyler, L,2772469.990.000.000.0069.99
Allen, Mason,176252431.950.000.000.002431.95
Ortega, Sheila, M,2763239.980.000.000.0039.98
Stewart, Makayla,16649115.940.000.000.00115.94
Nath, Yolanda, A,2462513.980.000.000.0013.98
White, Judith, R,148851155.480.000.000.001155.48
Davis, Jonathan,2925913.980.000.000.0013.98
Perez, Katherine, J,2207924.270.000.000.0024.27
Hall, Wyatt,2382713.980.000.000.0013.98
Li, Rafael, M,217527.280.000.000.007.28
Lal, Jack, R,185251735.980.000.000.001735.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Lee, Samantha, B,2737878.980.000.000.0078.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Morgan, Isabella, L,28602144.470.000.000.00144.47
Thomas, Jeremiah,183721760.470.000.000.001760.47
Perry, James,192051249.840.000.000.001249.84
Gray, Sebastian, B,138782366.960.000.000.002366.96
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Kelly, Bailey, R,28284563.770.000.000.00563.77
Hughes, Austin, P,183681754.980.000.000.001754.98
Allen, Madeline,2924068.970.000.000.0068.97

Generated 2025-11-01 08:57:32.693 UTC