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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Rogers, Shelby,11712127.800.000.0042.5985.21
Alexander, Julian,132172351.960.000.000.002351.96
Baker, Robert, A,273007.280.000.007.280.00
Phillips, Jack, R,259952443.350.000.002443.350.00
Foster, Deb,215012661.400.000.002661.400.00
Foster, Trevor, J,2896469.990.000.000.0069.99
Garcia, Isabella,18382204.940.000.000.00204.94
Anderson, Jasmine, A,235534.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Butler, Jackson, J,183241735.980.000.000.001735.98
Bradley, Nathaniel,169551760.470.000.000.001760.47
Martin, Nicholas,233627.280.000.000.007.28
Thames, Bernard,2380368.490.000.000.0068.49
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Gonzalez, James, M,188421155.480.000.000.001155.48
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Murphy, Richard, M,222994145.540.003578.270.00567.27
Roberts, Mason, D,111761106.680.000.00494.64612.04
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Gutierrez, Neil, L,214897.280.000.000.007.28
Brown, Benjamin, D,151874725.320.000.000.004725.32
Blue, Paige,2170313.980.000.000.0013.98
Bryant, Jackson, J,2533239.980.000.000.0039.98
Stewart, Grace, H,247737.280.000.000.007.28
Long, Rachel,2828339.980.000.000.0039.98
Jenkins, Samantha,113311290.330.000.00410.31880.02
Reed, Mariah,263731565.910.000.001000.44565.47
Gonzalez, Morgan,130651700.990.000.000.001700.99
Turner, Courtney, A,229753578.270.003578.270.000.00
Bailey, Olivia,238924.990.000.000.004.99
Martinez, Jonathan,1330366.250.000.000.0066.25
Washington, Alexis,1978146.260.000.007.2838.98
Miller, Katherine, B,27102782.990.000.00782.990.00
Wang, Benjamin, R,274547.280.000.000.007.28
Carter, Savannah, M,120902350.960.000.000.002350.96
Thomas, Jessica,1684894.480.000.0094.480.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Thompson, Isabella,18756128.410.000.000.00128.41
Rogers, Carlos,19645134.440.000.000.00134.44
Collins, Jose,2474839.980.000.0039.980.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Miller, Andrew, C,271104.990.000.000.004.99
Martin, Morgan,248322181.560.002181.560.000.00
Bradley, Rachel,158504813.040.000.000.004813.04
Bennett, Brittany, J,2233239.980.000.000.0039.98
Perry, Ryan,132494795.340.000.000.004795.34
Wilson, Hunter, R,2723013.980.000.000.0013.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Srini, Ruben,18078200.940.000.0071.97128.97
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Martin, Lucas, L,221144183.233578.270.000.00604.96
Campbell, Natalie, L,115122319.990.000.000.002319.99
She, Kenneth,16096212.010.000.0080.96131.05
Ross, Kaitlyn,16121614.470.000.000.00614.47
Gomez, Briana, A,2878443.980.000.000.0043.98
Thompson, Joshua, F,259992181.560.000.002181.560.00
Bennett, Seth,244933578.270.003578.270.000.00
Sanz, Lori, L,238654891.610.003578.270.001313.34
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Moreno, Renee, C,12936265.220.000.000.00265.22
Griffin, Miguel,2146476.970.000.000.0076.97
Collins, Alex, S,287812.290.000.000.002.29
Nath, Yolanda, A,2462513.980.000.000.0013.98
Stewart, Lucas, J,2934198.970.000.000.0098.97
Edwards, Hailey,242584.990.000.000.004.99
Griffin, Haley, L,1892582.180.000.000.0082.18
Zukowski, Jake,220584118.263578.270.000.00539.99
Campbell, Jordan,13290111.890.000.000.00111.89
Harris, Seth, M,161402528.330.000.002528.330.00
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Cook, Bryce,2864069.990.000.000.0069.99
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Smith, Chloe,17619163.920.000.000.00163.92
Davis, Justin,2807412.940.000.000.0012.94
Russell, Fernando,27084782.990.000.00782.990.00
Lopez, Jack, I,2904751.460.000.000.0051.46
Gonzales, Jose,2201439.980.000.000.0039.98
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Smith, Eduardo,2069139.980.000.0039.980.00
Murphy, Catherine, L,1650692.050.000.000.0092.05
Patterson, Aaron, W,191131184.460.000.000.001184.46
Rodriguez, Taylor,1607166.960.000.000.0066.96
Powell, Spencer,14904468.120.000.000.00468.12
Reed, Sean, L,145974803.310.000.000.004803.31
Martin, Noah, A,1765775.970.000.0075.970.00
Sharma, Samuel,27725119.980.000.000.00119.98
Campbell, Adam, A,214002688.890.000.002071.42617.47
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Moore, Fernando,265821000.440.000.001000.440.00
Collins, Jonathan,16849119.980.000.000.00119.98
Gonzales, Luis,15856116.250.000.0037.2778.98
Gonzales, Emily, P,21777180.980.000.000.00180.98
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Butler, Victoria,132844767.530.000.000.004767.53
Wang, Karen, P,1955331.970.000.000.0031.97
James, Emma,127812329.980.000.000.002329.98
Chen, Ethan,2054756.970.000.000.0056.97
Smith, John,198555709.960.003399.990.002309.97
Young, Savannah,259712749.320.002181.560.00567.76
Harris, Edward,27062782.990.00782.990.000.00
Watson, Olivia, S,1386093.850.000.0014.9878.87
Brooks, Steven, C,14877889.470.000.000.00889.47
Long, Kaitlyn,233964891.610.003578.270.001313.34
Brooks, Evan,2340139.980.000.000.0039.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Parker, Amanda,1808151.970.000.000.0051.97
Scott, Mason,2355139.980.000.000.0039.98
Russell, Isabella, A,11507645.780.000.0028.48617.30
Young, Sierra, J,11619634.840.000.0034.99599.85
White, Miguel, S,13988195.520.000.000.00195.52
Ward, Nicole, L,212724435.380.000.002071.422363.96
Gomez, Krista,12760273.180.000.0036.27236.91
Anderson, Megan, A,238594153.250.003578.27574.980.00
Foster, Jessica,2606951.460.000.0051.460.00
Rogers, Bryce,174022304.980.000.000.002304.98
Deng, Wayne,2145336.960.000.0036.960.00
Robinson, Emily,12183228.420.000.0054.96173.46
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Hayes, Gavin, A,194001179.470.000.000.001179.47
Chen, Jackson, S,270751371.950.00782.990.00588.96
Martin, Christian, V,19709197.250.000.000.00197.25
Bell, Alex, M,167543118.600.000.00756.332362.27
Walker, Emma, M,2520998.960.000.000.0098.96
Scott, Eric,282484.990.000.004.990.00
Russell, Nicole, M,182372318.960.000.000.002318.96
Torres, Mariah,16380195.950.000.000.00195.95
Taylor, Christian,2076456.760.000.000.0056.76
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Jones, Michael, A,2210771.970.000.000.0071.97
Kelly, Julia,2379867.930.000.0067.930.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Barnes, Brittany, R,15340156.040.000.0074.4681.58
She, Martha, E,222515971.330.003578.270.002393.06
Gill, Beth,199975814.980.003374.990.002439.99
Foster, Antonio,12795108.540.000.0066.2642.28
Cooper, Brian, L,13760128.840.000.000.00128.84
Smith, Andrew,1472387.570.000.0014.9872.59
Parker, Blake,15008170.530.000.0074.9895.55
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Hall, Jan, M,11740334.120.000.00235.1598.97
Sanchez, Faith,270494.990.000.000.004.99
Johnson, Edward, H,23279124.990.000.000.00124.99
Sanders, Zoe, L,248254.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Sanchez, Stephanie,1786756.970.000.000.0056.97
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Perry, Olivia,203754438.380.000.002071.422366.96
Hughes, Stephanie,263161000.440.001000.440.000.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Jackson, Charles, P,112771305.660.000.00237.821067.84
Hayes, Dalton, C,188822322.280.000.000.002322.28
Jai, Hunter, M,28272111.950.000.000.00111.95
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Butler, Jonathan,261804.990.000.000.004.99
Patterson, Abigail, H,144784795.010.000.000.004795.01
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Mitchell, Maria, D,27404782.990.000.00782.990.00
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Flores, Caleb, S,12165280.640.000.00243.3737.27
Sanders, Megan, A,15376136.240.000.000.00136.24
Bailey, Hailey, R,262704.990.000.000.004.99
Flores, Nathan, C,2463713.980.000.000.0013.98
Powell, Jack, J,1841156.960.000.000.0056.96
Barnes, Haley, J,2133939.980.000.0039.980.00
Stewart, Melissa,2517336.960.000.000.0036.96
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Sandberg, Chase,2190475.970.000.000.0075.97
Thompson, Xavier, R,15761192.410.000.000.00192.41
Ramos, Derrick,18449100.940.000.0030.9769.97
Mitchell, Bailey, B,267067.280.000.007.280.00
Morgan, Angela,24665109.970.000.000.00109.97
Shan, Christian, L,2308439.980.000.000.0039.98
Diaz, Trevor, B,2051954.960.000.000.0054.96
Long, Brandon, M,16110650.470.000.000.00650.47
Diaz, Richard, A,2668264.470.000.000.0064.47
Lobao, Alexandre,1892691.950.000.0091.950.00
Coleman, Lucas, A,27060782.990.00782.990.000.00
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Chen, Jonathan, G,13096200.690.000.000.00200.69
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Diaz, Luis, D,11203801.770.000.00183.97617.80
Howard, Danielle,28357133.490.000.000.00133.49
Price, Mariah, C,2074549.480.000.000.0049.48
Washington, Robert, J,14906143.950.000.000.00143.95
Hall, Natalie, A,230704.990.000.004.990.00
Williams, Ian, M,175581750.470.000.000.001750.47
Gutierrez, Linda, D,2857569.990.000.000.0069.99
White, Jennifer, S,27027782.990.00782.990.000.00
Morgan, Isaiah,18978118.730.000.000.00118.73
Patterson, Taylor,12147271.450.000.000.00271.45
Morgan, Jada, A,11520702.990.000.00137.45565.54
Hughes, Miranda,266784.990.000.000.004.99
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Hughes, Samantha,2721564.470.000.000.0064.47
Wright, Kyle,2371626.970.000.000.0026.97
Russell, Richard,2763322.260.000.000.0022.26
Diaz, Brandon,236764.990.000.004.990.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
_SUM1806517.5068775.49488463.69323085.41926192.91
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Townsend, Bryan,14077180.730.000.000.00180.73
Yuan, Leonard, F,167911729.970.000.000.001729.97
Perry, Melissa,221284142.230.003578.270.00563.96
Morris, Mason, J,22349124.990.000.000.00124.99
Wright, Robert, C,158894848.030.000.000.004848.03
Hill, Fernando,247634.990.000.000.004.99
Cox, Arianna, D,1892789.250.000.000.0089.25
Jackson, Edward,290422420.340.000.002420.340.00
Watson, Devin, A,18875114.950.000.000.00114.95
Patterson, Eric, A,2738478.980.000.000.0078.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Collins, Luis, J,227655978.610.003578.270.002400.34
Foster, Isabel, M,2174571.950.000.000.0071.95
Long, Morgan, H,213522625.390.000.002071.42553.97
Butler, Benjamin, C,189722369.970.000.000.002369.97
Brooks, Lucas, S,16089342.030.000.000.00342.03
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Flores, Hannah,1952540.230.000.000.0040.23
Carter, Katherine,11861286.300.000.000.00286.30
Martin, Thomas, A,169521735.980.000.000.001735.98
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Murphy, Chase, J,2472958.980.000.000.0058.98
Johnson, James,234984.990.000.000.004.99
Alexander, Jordan,2141259.980.000.0059.980.00
Long, Jordyn,1733847.250.000.000.0047.25
Hill, Haley, J,161033142.320.000.00792.342349.98
Sharma, Jackson,16876151.840.000.000.00151.84
Washington, Alexia,27613782.990.000.00782.990.00
Roberts, Amber, W,215822638.060.000.002049.10588.96
Edwards, Alexandra,133582386.940.000.000.002386.94
Long, Gavin,13762186.030.000.0036.59149.44
Diaz, Angela, K,27259782.990.000.00782.990.00
Adams, Julia, N,2607359.980.000.000.0059.98
Ross, Jose,2744178.980.000.0078.980.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Harris, Megan,232814828.110.003578.271249.840.00
Foster, Alyssa, I,14875839.480.000.000.00839.48
Smith, Nathan,217647.280.000.007.280.00
Clark, Joseph, D,153954780.020.000.000.004780.02
Griffin, Isabelle,249864.990.000.000.004.99
Lu, Alejandro,2562039.980.000.000.0039.98

Generated 2025-11-01 00:05:27.298 UTC