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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Carter, Jonathan,14578848.470.000.000.00848.47
Parker, Madeline, H,221826006.320.003578.270.002428.05
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Miller, Kayla, A,236734.990.000.000.004.99
Jones, Madison,246614181.760.003578.27603.490.00
Foster, Paige,2742894.480.000.000.0094.48
Perry, Lauren,248164.990.000.000.004.99
Lal, Caleb, R,1586874.460.000.000.0074.46
Kennedy, Bridget,2202639.980.000.000.0039.98
Ross, Haley, T,253612443.350.002443.350.000.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Moore, Anthony, M,2473039.980.000.000.0039.98
Young, Julia, J,274144.990.000.000.004.99
Phillips, Aaron, R,2494739.980.000.000.0039.98
Hughes, Anna,197052341.970.000.000.002341.97
Perry, Christian,246714354.600.003578.270.00776.33
Williams, Ian, M,175581750.470.000.000.001750.47
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Gonzales, Miranda,11660324.720.000.000.00324.72
Walker, Ian,16771104.550.000.0054.5849.97
Harris, Samuel, M,2477159.980.000.0059.980.00
Torres, Xavier,16840176.950.000.000.00176.95
Griffin, Xavier,228775962.340.003578.270.002384.07
Sánchez, Angela, C,176551750.980.000.000.001750.98
Russell, Samuel, V,11652310.930.000.000.00310.93
Ward, Jade, D,14661195.020.000.000.00195.02
Phillips, Adam, R,227484188.240.003578.270.00609.97
Ramirez, Richard, C,282397.280.000.007.280.00
Chow, Candice,1923260.960.000.000.0060.96
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Thomas, Matthew, K,13239185.700.000.000.00185.70
Simmons, Caleb, M,121934833.030.000.000.004833.03
Zhang, Nathan, L,2910478.980.000.000.0078.98
Barnes, Haley, J,2133939.980.000.0039.980.00
Chen, Jackson, S,270751371.950.00782.990.00588.96
Mitchell, Maria, D,27404782.990.000.00782.990.00
Nelson, Luis,234884.990.000.000.004.99
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Williams, Joshua,260514.990.000.000.004.99
Powell, Jack, J,1841156.960.000.000.0056.96
Peterson, Melissa, S,249954.990.000.004.990.00
Foster, Jose, C,2878534.990.000.000.0034.99
Garcia, Chloe, M,110372374.230.000.002374.230.00
Raje, Mindy, A,16083561.970.000.000.00561.97
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Hill, Blake,11748131.540.000.000.00131.54
Gonzalez, Molly,1637021.980.000.000.0021.98
Smith, Samuel, D,2308349.900.000.000.0049.90
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Carter, Elijah,216182611.070.000.002611.070.00
Thomas, Jeremiah,183721760.470.000.000.001760.47
Lazecky, Petr,258642443.350.002443.350.000.00
Parker, Katherine,13268289.700.000.0068.97220.73
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Ryan,2833294.480.000.000.0094.48
Martin, Madison, C,2049271.970.000.0071.970.00
Moore, Chloe, L,2626913.980.000.000.0013.98
Stewart, Garrett, O,15762564.480.000.000.00564.48
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Davis, Richard, R,15549574.980.000.00574.980.00
Campbell, Evan, W,243424828.110.003578.270.001249.84
Brown, Julia,18065155.470.000.000.00155.47
Ward, Kaylee, A,244154.990.000.004.990.00
Perry, Natalie,1712669.990.000.000.0069.99
Jai, Samuel, L,1635887.950.000.0039.9947.96
Umeda, Masaki,16717233.810.000.000.00233.81
Bradley, Jocelyn,230227.280.000.000.007.28
Bennett, Maria, G,229837.280.000.000.007.28
Gray, Seth, M,2008785.480.000.000.0085.48
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Stewart, Cindy,14496804.480.000.000.00804.48
King, Morgan,196811179.970.000.000.001179.97
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Edwards, Hunter,2422067.930.000.000.0067.93
Scott, Adam,15863243.010.000.000.00243.01
Garcia, Hunter, J,213053204.580.000.002049.101155.48
McDonald, Aaron, J,27734119.980.000.000.00119.98
Stewart, Melissa,2517336.960.000.000.0036.96
Morgan, Brianna, D,111362380.470.000.002380.470.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Price, Jocelyn, D,258752443.350.002443.350.000.00
Russell, Isabella, A,11507645.780.000.0028.48617.30
Flores, Kevin,15878225.920.000.0069.97155.95
Baker, Isaiah,12106169.540.000.000.00169.54
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Adams, Julia, N,2607359.980.000.000.0059.98
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Martinez, Kristina, S,2134529.930.000.000.0029.93
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Miller, Sydney, A,134404818.530.000.000.004818.53
Robinson, Julia,28121119.980.000.000.00119.98
Williams, Zachary, B,27099782.990.000.00782.990.00
Flores, Morgan,19817118.940.000.0039.9878.96
Thompson, Tyler,2750269.990.000.0069.990.00
Miller, Eduardo,14561158.840.000.0049.97108.87
Moore, Fernando,265821000.440.000.001000.440.00
Hayes, Oscar,2652729.260.000.000.0029.26
Patterson, Abigail, H,144784795.010.000.000.004795.01
Parker, Blake,15008170.530.000.0074.9895.55
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Diaz, Trevor, B,2051954.960.000.000.0054.96
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Stewart, Andrea, M,27252782.990.000.00782.990.00
Li, Connor,201863191.910.002071.420.001120.49
Jones, Zachary, J,27285782.990.000.00782.990.00
Rivera, Sara,187852350.960.000.000.002350.96
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Brown, Jonathan,11875265.420.000.000.00265.42
Ward, Juan, H,215952649.560.000.002049.10600.46
Flores, Megan, N,230746021.820.003578.270.002443.55
Foster, Carson, L,16959135.350.000.0085.4849.87
Madan, Carmen, V,155674720.270.000.000.004720.27
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Richardson, Evan, J,15488165.300.000.000.00165.30
Perry, Brandon,22095141.980.000.000.00141.98
Scott, Gabrielle,270614.990.000.000.004.99
Garcia, Christian, J,164913106.330.000.00751.342354.99
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Nelson, Adam, B,27402128.970.000.000.00128.97
Long, Rachel,2828339.980.000.000.0039.98
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Morris, Chase, F,26789699.100.00699.100.000.00
Turner, Courtney, A,229753578.270.003578.270.000.00
Perry, Benjamin,291652407.040.000.002407.040.00
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Williams, Austin,2035432.220.000.000.0032.22
Stewart, Gabriella,2803469.990.000.000.0069.99
Edwards, Logan,250024.990.000.000.004.99
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Patterson, Natalie,16123629.970.000.000.00629.97
Collins, Charles, B,29041628.450.000.000.00628.45
Serrano, Albert, E,133284708.020.000.000.004708.02
Hernandez, Jamie,27283119.980.000.00119.980.00
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Walker, Emma, M,2520998.960.000.000.0098.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Baker, Robert, A,273007.280.000.007.280.00
Collins, Lucas, T,219214142.753578.270.000.00564.48
Sharma, Thomas, A,18637121.940.000.000.00121.94
Harris, Anthony,2144721.980.000.000.0021.98
Rodriguez, Destiny, J,227397.280.000.007.280.00
Bryant, Brittany,2254548.970.000.000.0048.97
Rogers, Faith,2468259.980.000.000.0059.98
Miller, Victoria,15816188.020.000.0081.46106.56
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Anderson, David, A,2209761.960.000.0061.960.00
Thomas, Dalton,230097.280.000.000.007.28
Ross, Anna, D,15494275.440.000.0029.99245.45
Prasad, Molly,243924329.610.003578.270.00751.34
Ward, Ian,12056213.920.000.000.00213.92
Edwards, Amber, B,2051776.970.000.000.0076.97
Wright, Carol, C,12928247.410.000.0033.98213.43
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Smith, Noah,13175166.920.000.000.00166.92
White, Christopher, R,260492181.560.000.002181.560.00
Foster, Abigail,1982346.470.000.000.0046.47
Rogers, Jade, I,14332102.250.000.000.00102.25
Smith, Hannah, J,2526554.980.000.0054.980.00
Harris, Isabella,17119214.900.000.0077.96136.94
Ramirez, Brian, M,116182369.960.000.002369.960.00
Cox, Lucas, J,253932443.350.002443.350.000.00
Alexander, Jordan,2141259.980.000.0059.980.00
Johnson, Jonathan,220597.280.000.000.007.28
Thompson, Abigail,243324816.090.003578.270.001237.82
Brown, Dalton, N,218134118.263578.270.000.00539.99
Henderson, Ashley,111851381.370.000.00232.801148.57
Yang, Justin, S,153634719.040.000.000.004719.04
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Parker, Natalie, A,251043018.330.002443.350.00574.98
Alexander, Edward, E,18524195.950.000.000.00195.95
Henderson, Abigail,2044139.980.000.000.0039.98
Collins, Isaac,260777.280.000.000.007.28
Perry, Olivia,203754438.380.000.002071.422366.96
Lopez, Carlos,186171147.770.000.000.001147.77
Campbell, Hailey,15507267.840.000.00228.9638.88
Parker, Jeremy,2866878.980.000.0078.980.00
Harris, Edward,27062782.990.000.00782.990.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
King, Caleb, J,2898678.980.000.000.0078.98
Coleman, Logan,1868691.950.000.000.0091.95
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Cooper, Brian, L,13760128.840.000.000.00128.84
Ross, Seth, M,184332329.980.000.000.002329.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Alvarez, Melody,2507068.490.000.000.0068.49
Reed, Bryan,18884133.930.000.000.00133.93
Henderson, Luke,19200109.240.000.000.00109.24
Lee, Alexander, S,18356149.910.000.000.00149.91
Mr., Smith, Jeff,2928353.990.000.000.0053.99
White, Cameron,238304802.110.003578.270.001223.84
Perez, Jordan, A,292674.990.000.000.004.99
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Smith, Megan, J,2671668.970.000.000.0068.97
Jackson, Edward,290422420.340.000.002420.340.00
Brown, Benjamin, D,151874725.320.000.000.004725.32
Patterson, Jeremy,130272319.260.000.000.002319.26
Robinson, Zachary, L,137092332.280.000.000.002332.28
Gomez, Krista,12760273.180.000.0036.27236.91
Lee, Don,188392384.970.000.000.002384.97
Moore, Ian, L,2463939.980.000.000.0039.98
Carter, Katherine,11861286.300.000.000.00286.30
Peterson, Mason, A,185701174.480.000.001174.480.00
Ross, Kelly,2607676.960.000.000.0076.96
Lewis, Seth,26782699.100.00699.100.000.00
Walker, Brandon, J,159164793.270.000.000.004793.27
Garcia, Rachel, L,129864823.010.000.002369.972453.04
White, Tyler,14291258.440.000.0049.97208.47
White, Miguel, S,13988195.520.000.000.00195.52
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Rodriguez, Natalie,2077330.970.000.000.0030.97
Clark, Zachary, J,2389358.980.000.000.0058.98
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Simmons, Anna, K,124512367.920.000.000.002367.92
Lewis, Ethan,27998144.470.000.000.00144.47
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Smith, Andrew,1472387.570.000.0014.9872.59
Russell, Rachel, C,2158124.270.000.0024.270.00
Washington, Hailey, S,2588559.980.000.000.0059.98
Thomas, Emily,2180339.980.000.000.0039.98
Perry, Dalton, A,16149192.040.000.000.00192.04
Lal, Kyle,17360122.180.000.000.00122.18
Washington, Lauren, R,229985329.250.003578.271750.980.00
Powell, Ian,2608564.470.000.000.0064.47
Richardson, Devin, G,2131836.960.000.000.0036.96
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Murphy, Maria,160113657.260.000.000.003657.26
Wang, Zachary,2214489.970.000.000.0089.97
Mehta, Carmen, C,2743694.480.000.000.0094.48
Sanders, Megan, A,15376136.240.000.000.00136.24
Hayes, Dalton, C,188822322.280.000.000.002322.28
Adams, Mason, T,2052864.470.000.0064.470.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Murphy, Brianna, K,2834269.990.000.000.0069.99
Walker, Jasmine,134604693.040.000.000.004693.04
Brown, Dylan, J,124492351.960.000.000.002351.96
Thomas, Thomas,216292624.080.000.002049.10574.98
Foster, Jessica,2606951.460.000.0051.460.00
Cannata, Gabrielle, C,217254.990.000.000.004.99
Peterson, Steven, L,234497.280.000.007.280.00
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Wu, Randy, J,116472365.940.000.002365.940.00
Phillips, Andrea,1857383.740.000.000.0083.74
Griffin, Julian, M,113284718.040.000.002319.992398.05
Deng, Damien, A,16873578.460.000.000.00578.46
Gray, Alexandria, E,253632443.350.002443.350.000.00
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58

Generated 2025-11-03 14:49:47.396 UTC