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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Williams, Ryan, R,222475978.610.003578.270.002400.34
Richardson, Devin, G,2131836.960.000.000.0036.96
Hughes, Destiny, P,28027119.980.000.000.00119.98
Gill, Robyn, J,127651750.980.000.001750.980.00
Flores, Logan, K,14631848.470.000.000.00848.47
Fernandez, Ruth,205463246.550.000.002049.101197.45
Blue, Paige,2170313.980.000.000.0013.98
Williams, Edward, D,14274121.560.000.000.00121.56
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Perry, Brandon,22095141.980.000.000.00141.98
Garcia, Victoria, V,245013578.270.003578.270.000.00
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Smith, Andrew,1472387.570.000.0014.9872.59
Gonzales, Jordan,2368113.980.000.000.0013.98
Lazecky, Petr,258642443.350.002443.350.000.00
Butler, Cassidy, L,21792114.460.000.000.00114.46
Brooks, Lucas, S,16089342.030.000.000.00342.03
Wilson, Andrew, R,182362414.990.000.000.002414.99
Smith, Noah,13175166.920.000.000.00166.92
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Brown, Anna,1624795.820.000.000.0095.82
Morris, Alyssa,28072548.980.000.000.00548.98
Morgan, Angela,24665109.970.000.000.00109.97
Thomas, William, A,216142589.090.000.002049.10539.99
Scott, Adam,15863243.010.000.000.00243.01
Long, Julia, R,228895971.330.003578.270.002393.06
Anderson, Isabella,137432349.980.000.000.002349.98
Moreno, Lance, A,2922939.980.000.000.0039.98
Sharma, Kathryn,20740140.940.000.000.00140.94
Yuan, Leonard, F,167911729.970.000.000.001729.97
Patterson, Jeremy,130272319.260.000.000.002319.26
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Johnson, Xavier, R,2325539.980.000.0039.980.00
Townsend, Bryan,14077180.730.000.000.00180.73
Hall, Kaylee, E,1975137.270.000.000.0037.27
Simmons, Dakota, T,14110819.460.000.000.00819.46
Watson, Cole, A,217684118.263578.270.000.00539.99
Morgan, Timothy,14633242.500.000.0071.58170.92
Davis, Marcus, T,17337123.910.000.0086.9536.96
Carter, Marcus, l,2147131.970.000.000.0031.97
Baker, Allison,2649558.980.000.000.0058.98
Long, Natalie,14363192.340.000.000.00192.34
Washington, Emma,191231170.480.000.000.001170.48
Moreno, Meredith, D,2228589.970.000.000.0089.97
Ross, Rachel, C,206693169.590.000.002049.101120.49
Watson, Michelle, H,262352181.560.000.002181.560.00
Brown, Dylan, J,124492351.960.000.000.002351.96
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Ye, Alisha, J,220084141.233578.270.000.00562.96
Wright, Jennifer,2650559.980.000.0059.980.00
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
James, Bryce,13466133.450.000.000.00133.45
Price, Nicole, N,15815141.830.000.000.00141.83
Jones, Madison,246614181.760.003578.27603.490.00
Johnson, Christopher,119794813.760.000.002352.212461.55
Perry, Ryan,132494795.340.000.000.004795.34
Cook, Steven, J,27053782.990.00782.990.000.00
Stewart, Lucas, J,2934198.970.000.000.0098.97
Green, Blake, P,11719287.200.000.000.00287.20
Smith, Megan, J,2671668.970.000.000.0068.97
Richardson, Brian,2860878.980.000.000.0078.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Roberts, Amber, W,215822638.060.000.002049.10588.96
Foster, Jose, C,2878534.990.000.000.0034.99
Perry, Christian,246714354.600.003578.270.00776.33
Campbell, Hailey,15507267.840.000.00228.9638.88
Kumar, Elijah,15197156.920.000.000.00156.92
Martin, Alfredo, P,2148039.980.000.000.0039.98
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Diaz, Faith, M,2236356.970.000.000.0056.97
Foster, Nicole, A,2349489.970.000.000.0089.97
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Russell, Katherine,2877169.990.000.000.0069.99
Clark, Destiny, L,28600119.980.000.000.00119.98
Torres, Mariah,16380195.950.000.000.00195.95
Chen, Luis, G,2125294.450.000.0094.450.00
Long, Chloe,167841735.980.000.000.001735.98
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Thompson, Ethan,199894495.480.003374.990.001120.49
Phillips, Haley, B,2807939.980.000.000.0039.98
Long, Xavier,112512318.960.000.000.002318.96
Simmons, Brittany,2923139.980.000.000.0039.98
Carter, Elijah,216182611.070.000.002611.070.00
Bryant, Gabriel,2765669.990.000.000.0069.99
Patterson, Eric, A,2738478.980.000.000.0078.98
Wilson, Fernando,16643126.960.000.000.00126.96
Flores, Emma, P,15543180.940.000.000.00180.94
Washington, Riley, L,185441155.480.000.001155.480.00
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Baker, Eduardo,180921789.450.000.000.001789.45
Baker, Robert, A,273007.280.000.007.280.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Cook, Megan, J,2029956.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Allen, Amanda,2235339.980.000.000.0039.98
Young, Jenna, W,163652490.180.000.000.002490.18
Diaz, Gabrielle,14893839.480.000.000.00839.48
Washington, Ryan,2833294.480.000.000.0094.48
Yang, Aaron, C,2519654.980.000.000.0054.98
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Gonzales, Emily, P,21777180.980.000.000.00180.98
Reed, Erin, I,14353128.840.000.0074.9853.86
Thompson, Tyler,2750269.990.000.0069.990.00
Barnes, Ian, M,16106133.540.000.000.00133.54
Blue, Makayla,1900029.990.000.000.0029.99
Edwards, Eric,2462768.490.000.000.0068.49
Taylor, Zachary, M,27082782.990.000.00782.990.00
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Coleman, Miguel, D,2740069.990.000.0069.990.00
Anderson, Ashley,206803219.580.000.002049.101170.48
Hall, Amber,20106131.950.000.000.00131.95
Harris, Edward,27062782.990.000.00782.990.00
Ross, Kelly,2607676.960.000.000.0076.96
Wood, Brittany,2877753.990.000.000.0053.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Hall, Taylor, J,169951735.980.000.000.001735.98
Peterson, Christina,2897694.480.000.000.0094.48
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Richardson, Erin, R,1633188.850.000.0038.8849.97
Diaz, Katherine, P,115262376.960.000.002376.960.00
Morris, Jessica,289678.990.000.008.990.00
Green, Gabriella, C,2803569.990.000.000.0069.99
Lal, Caleb, R,1586874.460.000.000.0074.46
Phillips, Isaiah,28631144.470.000.00144.470.00
James, Emma,127812329.980.000.000.002329.98
Isla, Julian, A,13732108.960.000.004.99103.97
James, Morgan, E,2324539.980.000.000.0039.98
Johnson, Ian, E,2173283.470.000.000.0083.47
Rodriguez, Natalie,2077330.970.000.000.0030.97
Prasad, Erick, E,28786127.950.000.000.00127.95
Johnson, Anthony, D,270224.990.000.000.004.99
Deng, Wayne,2145336.960.000.0036.960.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Richardson, Victoria, C,248172181.560.002181.560.000.00
Morris, Mason, J,22349124.990.000.000.00124.99
Smith, Tyler, J,2034156.970.000.000.0056.97
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Carter, Luis, E,258832443.350.002443.350.000.00
Miller, Eduardo,14561158.840.000.0049.97108.87
Bradley, Evan,18506101.940.000.000.00101.94
Thomas, Logan, A,14091251.200.000.0053.99197.21
Alexander, Luke,290432447.050.000.002447.050.00
Li, Jordan,17026261.390.000.00261.390.00
Morris, Chase, F,26789699.100.00699.100.000.00
Simmons, Jose,2464739.980.000.000.0039.98
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Ross, Natalie, J,12916261.220.000.000.00261.22
Howard, Alyssa, A,11513863.950.000.000.00863.95
Foster, Kayla,1969371.950.000.000.0071.95
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Collins, Jose,2474839.980.000.0039.980.00
Gonzales, Miranda,11660324.720.000.000.00324.72
Lee, Emma,16948176.430.000.000.00176.43
Sharma, Thomas, A,18637121.940.000.000.00121.94
Lee, Don,188392384.970.000.000.002384.97
Cooper, Alexandra,19541131.240.000.000.00131.24
Wilson, Tyler, L,15879196.930.000.000.00196.93
Sanders, Zoe, L,248254.990.000.000.004.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Henderson, Hailey, C,171481775.470.000.000.001775.47
Gonzales, Brittany,217104187.233578.270.000.00608.96
Morris, Paige, W,220414167.233578.270.000.00588.96
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Brooks, Evan,2340139.980.000.000.0039.98
Carter, Savannah, M,120902350.960.000.000.002350.96
Turner, Mary,220154.990.000.000.004.99
Zhao, Clarence, R,1982671.970.000.0071.970.00
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Reed, Isaac, D,260747.280.000.000.007.28
Cox, Julia, A,206703228.570.000.002049.101179.47
Rivera, Rachel, S,2899678.980.000.000.0078.98
Carter, Katherine,11861286.300.000.000.00286.30
Adams, Katherine, M,235184.990.000.000.004.99
Sanz, Lori, L,238654891.610.003578.270.001313.34
Cooper, Angela,195261179.470.000.000.001179.47
Ramirez, Brian, M,116182369.960.000.002369.960.00
Griffin, Marcus,2075634.560.000.000.0034.56
Howard, Erin, L,183621725.210.000.000.001725.21
White, Greg, C,174032322.280.000.000.002322.28
Ward, Emma, W,2179659.980.000.000.0059.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Hughes, Samantha,2721564.470.000.000.0064.47
Yuan, Carly,19839194.960.000.000.00194.96
White, Emily, M,159174679.060.000.000.004679.06
Edwards, Angel, J,2912469.990.000.000.0069.99
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Martin, Nicholas,233627.280.000.000.007.28
Griffin, James,28189567.760.000.000.00567.76
Smith, Austin,13707149.050.000.000.00149.05
Torres, Erin,1218287.250.000.0037.2949.96
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Huang, Kristen,251002443.350.002443.350.000.00
Ward, Juan, H,215952649.560.000.002049.10600.46
Roberts, Carlos,2319639.980.000.000.0039.98
Bailey, Mariah, L,2724354.980.000.000.0054.98
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Watson, Victoria,16125588.960.000.000.00588.96
Rivera, Hailey, R,2079239.980.000.000.0039.98
Morgan, Jada, A,11520702.990.000.00137.45565.54
Nelson, Henry,193941155.480.000.000.001155.48
Patterson, Grace, M,27560782.990.000.00782.990.00
Parker, Caleb, A,2631813.980.000.000.0013.98
Ramirez, Emma,29072128.970.000.000.00128.97
Carter, Jesse, E,22141166.280.000.000.00166.28
Diaz, Luis, D,11203801.770.000.00183.97617.80
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Morris, Abigail, C,287762.290.000.000.002.29
Scott, Gabrielle,270614.990.000.000.004.99
Lal, Luke, L,11019698.230.000.00139.93558.30
Cooper, Paige,14119148.940.000.000.00148.94
Deng, Damien, A,16873578.460.000.000.00578.46
Ross, Jose,2744178.980.000.0078.980.00
Turner, Timothy, C,14641119.860.000.000.00119.86
Moore, Anthony, M,2473039.980.000.000.0039.98
Sanchez, Martin, E,216317.280.000.000.007.28
Coleman, Joan, W,2669964.470.000.000.0064.47
Williams, Joshua,260514.990.000.000.004.99
Hughes, Edward,200234530.470.003374.990.001155.48
Hernandez, Haley, L,11769478.950.000.000.00478.95
Foster, Abigail,1982346.470.000.000.0046.47
Cox, Katelyn, B,2174230.970.000.000.0030.97
Flores, Julian,158464943.320.000.000.004943.32
Martin, Lucas, L,221144183.233578.270.000.00604.96
Lopez, Bailey, R,185571179.470.000.001179.470.00
Dominguez, Meghan,14370122.560.000.000.00122.56
Watson, Emma,17481126.940.000.000.00126.94
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Scott, Haley,13701154.540.000.000.00154.54
Thompson, Abigail,243324816.090.003578.270.001237.82
Foster, Aaron,155664912.470.000.000.004912.47
Sanchez, Rachel, C,267304.990.000.000.004.99
James, Sara,198023374.993374.990.000.000.00
Bradley, Jocelyn,230227.280.000.000.007.28
Henderson, Ashley,111851381.370.000.00232.801148.57
Thompson, Devin,207084406.400.000.002071.422334.98
Lal, Jack, R,185251735.980.000.000.001735.98
Stewart, Amanda, M,1531094.440.000.000.0094.44
Martinez, Jonathan,1330366.250.000.000.0066.25
Smith, Justin, P,1982721.980.000.000.0021.98
Sanchez, Allison,1666741.720.000.000.0041.72
Lopez, Isaiah,18968151.430.000.000.00151.43
Bailey, Marcus, L,18329146.530.000.0023.78122.75

Generated 2025-11-04 15:04:48.624 UTC