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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Price, Riley, R,139094764.020.000.000.004764.02
Allen, Angel, G,15571101.850.000.0034.8966.96
James, Zoe, R,14611304.550.000.000.00304.55
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Russell, Samantha,11211723.560.000.0064.47659.09
Jai, Samuel, L,1635887.950.000.0039.9947.96
Zukowski, Jake,220584118.263578.270.000.00539.99
Sharma, Jackson,16876151.840.000.000.00151.84
Alexander, Edward, E,18524195.950.000.000.00195.95
Stewart, Marcus, R,2063221.980.000.000.0021.98
Hernandez, José, M,11253696.610.000.0098.97597.64
Garcia, Xavier, M,2030071.970.000.000.0071.97
Sun, Arturo, C,11498557.540.000.007.95549.59
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Barnes, Ian, M,16106133.540.000.000.00133.54
Hayes, Brittany,13941286.820.000.000.00286.82
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Kelly, Bailey, R,28284563.770.000.000.00563.77
Rubio, Ruben, D,1887186.960.000.0086.960.00
Rowe, Todd,14586233.940.000.000.00233.94
Ross, Xavier, A,12202171.470.000.0049.97121.50
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Ross, Jose,2744178.980.000.0078.980.00
Griffin, James,28189567.760.000.000.00567.76
Brooks, Bryce,12061140.170.000.00112.2527.92
Garcia, Patricia,11651226.430.000.0099.97126.46
Torres, Taylor,16666205.440.000.00123.9881.46
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Patterson, Hailey, I,112231155.900.000.00103.961051.94
Alexander, Elijah,11738331.680.000.00141.73189.95
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Williams, Destiny, S,15881564.990.000.00564.990.00
Chen, Luis, G,2125294.450.000.0094.450.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Reed, Marcus,14582111.790.000.0014.9896.81
Rogers, Shelby,11712127.800.000.0042.5985.21
Bell, Timothy, J,2810178.980.000.0078.980.00
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Russell, Isabella, A,11507645.780.000.0028.48617.30
Chen, Ethan,2054756.970.000.000.0056.97
Hayes, Austin,202083219.580.002049.100.001170.48
Martinez, Jonathan,1330366.250.000.000.0066.25
Morgan, Jada, A,11520702.990.000.0062.97640.02
Bell, Danielle,140414765.020.000.000.004765.02
Young, Kaylee, S,13756298.490.000.0058.47240.02
Hughes, Edward,200234530.470.003374.990.001155.48
Cooper, Grace, C,1601294.260.000.000.0094.26
Adams, Kaitlyn, A,11869239.600.000.000.00239.60
Patterson, Eduardo,11142866.810.000.0072.26794.55
Nelson, Kevin,1476584.970.000.000.0084.97
Wood, Gavin,16964108.540.000.0093.5614.98
Roberts, Rebecca,2800094.480.000.000.0094.48
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Thomas, Zachary, D,28045119.980.000.000.00119.98
Howard, Alexandra,207363194.580.000.002049.101145.48
Price, Jeremy,259892744.520.000.002181.56562.96
Rivera, Amanda,11131115.920.000.000.00115.92
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Gray, Jesse,14626197.040.000.000.00197.04
Rodriguez, Richard,12969180.790.000.000.00180.79
Li, Brandon,2933973.960.000.000.0073.96
Russell, Oscar, A,12140118.170.000.000.00118.17
Collins, Xavier, C,16646250.910.000.000.00250.91
Miller, Victoria,15816188.020.000.0081.46106.56
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Martin, Christian, V,19709197.250.000.000.00197.25
Powell, Miranda, J,153044843.000.000.000.004843.00
Collins, Eduardo,139872329.990.000.000.002329.99
Stewart, Gabriella,2803469.990.000.000.0069.99
Kumar, Austin,204834400.060.000.002049.102350.96
Phillips, Kaylee,211384371.380.000.002049.102322.28
Campbell, Chloe,11212760.930.000.00231.72529.21
Ross, Rachel, C,206693169.590.000.002049.101120.49
Collins, Hailey,11709325.890.000.0021.49304.40
Williams, Ethan,243094793.120.003578.270.001214.85
Robinson, Emily,12183228.420.000.0054.96173.46
Martin, Kellie, R,28195574.980.000.000.00574.98
Nelson, James, L,245257.280.000.007.280.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Lal, Luke, L,11019698.230.000.00139.93558.30
Xu, Louis,2010466.530.000.0066.530.00
Garcia, Henry, B,112871009.240.000.00219.26789.98
Flores, Devin, A,15559172.040.000.0086.5685.48
Martinez, Grace, M,17385208.690.000.0069.97138.72
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Hayes, Jason,261764.990.000.000.004.99
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Washington, Miranda,152014793.020.000.000.004793.02
Peterson, Steven, L,234497.280.000.007.280.00
Russell, Samuel, V,11652310.930.000.000.00310.93
Miller, Chloe, V,228936056.510.003578.272478.240.00
Foster, Caleb,27112114.460.000.000.00114.46
Cooper, Angela,195261179.470.000.000.001179.47
Kelly, Angel, E,15418232.230.000.000.00232.23
Washington, Aaron, L,246494.990.000.000.004.99
Powell, Jordyn, K,153914828.010.000.000.004828.01
Ward, Jade, D,14661195.020.000.000.00195.02
Walker, Richard, T,19640224.550.000.000.00224.55
Davis, Marcus, T,17337123.910.000.0086.9536.96
Nelson, Jose,19217185.020.000.0091.9593.07
Thames, Bernard,2380368.490.000.000.0068.49
Luo, Donna, E,248054.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Torres, Xavier,16840176.950.000.000.00176.95
Moreno, Lance, A,2922939.980.000.000.0039.98
Taylor, Madison, A,11802215.290.000.00127.9687.33
Sanders, Allison, B,18852268.250.000.000.00268.25
Torres, Erin,1218287.250.000.0037.2949.96
Barnes, Fernando,113001390.550.000.00240.431150.12
Jackson, Charles, P,112771305.660.000.00237.821067.84
Henderson, Ashley,111851381.370.000.00232.801148.57
Parker, Morgan, S,1677236.960.000.0014.9821.98
Roberts, Amanda,171752334.980.000.000.002334.98
Gray, Mariah,222787.280.000.007.280.00
Patterson, Maria, G,1333094.950.000.000.0094.95
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Lewis, Ethan,27998144.470.000.000.00144.47
Lee, William,13185149.840.000.0069.9779.87
Diaz, Luke,12054402.530.000.00139.97262.56
Brooks, Mariah,216202620.400.000.002071.42548.98
Johnson, Christopher,119794813.760.000.002352.212461.55
Roberts, Hunter,282607.280.000.000.007.28
Wu, Randy, J,116472365.940.000.002365.940.00
Perry, Lauren,248164.990.000.000.004.99
Campbell, Alex,119844730.320.000.002329.982400.34
Phillips, Andrea,1857383.740.000.000.0083.74
Parker, Madeline, H,221826006.320.003578.270.002428.05
Adams, Gabriel, S,195271219.450.000.000.001219.45
Bradley, Nathaniel,169551760.470.000.000.001760.47
Green, Blake, P,11719287.200.000.000.00287.20
Stewart, Cody, A,212843223.580.000.002049.101174.48
Russell, Katherine,2877169.990.000.000.0069.99
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Williams, Sydney, J,15334848.470.000.000.00848.47
Thompson, Xavier, R,15761192.410.000.000.00192.41
White, Judith, R,148851155.480.000.000.001155.48
Davis, Jonathan,2925913.980.000.000.0013.98
Evans, Dalton, E,127104774.040.000.002354.982419.06
Baker, Robert, A,273007.280.000.000.007.28
Hayes, Jeremiah, W,20086128.550.000.000.00128.55
Wright, Carol, C,12928247.410.000.000.00247.41
Butler, Victoria,132844767.530.000.000.004767.53
Perry, Eric,18314115.730.000.000.00115.73
Hill, Jordan, J,16005198.730.000.0069.99128.74
Watson, Richard,15943365.410.000.000.00365.41
Robinson, Lauren,2719668.490.000.000.0068.49
Gray, Brianna,249603008.820.002443.350.00565.47
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Sharma, Yolanda, K,250483046.840.002443.350.00603.49
Garcia, Anna, B,15572104.550.000.000.00104.55
Miller, Destiny,251577.280.000.000.007.28
Baker, Ian, V,262002756.540.000.002181.56574.98
Brown, Isabella, L,266921266.860.00699.100.00567.76
Bailey, Lauren,15864103.550.000.000.00103.55
Rogers, Paige, H,17125539.990.000.000.00539.99
Zeng, Jake,18054106.930.000.000.00106.93
Li, Eugene, A,15283865.950.000.000.00865.95
Brown, Julia,18065155.470.000.000.00155.47
Li, Thomas,181162376.960.000.000.002376.96
James, Jeremiah, S,11661287.700.000.000.00287.70
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Lee, Samantha, B,2737878.980.000.000.0078.98
Flores, Miguel,1975077.250.000.000.0077.25
Kelly, Erin, D,2351364.470.000.000.0064.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Lee, Alexander, S,18356149.910.000.000.00149.91
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Murphy, Brianna, K,2834269.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Blanco, Randall,263211554.410.000.001000.44553.97
Cooper, Amanda, P,146064716.020.000.000.004716.02
Sanders, Sean,14341175.150.000.000.00175.15
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
James, Julia,2497567.930.000.000.0067.93
Anderson, Madison, G,2835978.980.000.000.0078.98
Chandra, Allen,2932753.990.000.000.0053.99
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Nelson, Katherine,2802178.980.000.000.0078.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Butler, Dalton, A,133454759.510.000.000.004759.51
Simmons, Haley, T,262022749.320.000.002181.56567.76
Harris, Megan,232814828.110.003578.270.001249.84
Cox, Sara, P,2775869.990.000.000.0069.99
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Harris, Seth, M,161402528.330.000.000.002528.33
Parker, Blake,15008170.530.000.000.00170.53
Harris, Anthony,2144721.980.000.000.0021.98
Turner, Eduardo,158764789.020.000.000.004789.02
Nath, Alison, J,171161764.960.000.000.001764.96
Gray, Sara,292472447.050.000.002447.050.00
Martin, James, M,1987077.250.000.000.0077.25
Rodriguez, Natalie,2077330.970.000.000.0030.97
Thompson, Devin,207084406.400.000.002071.422334.98
Foster, Aaron,155664912.470.000.000.004912.47
Chandra, Brandy, P,11501603.530.000.000.00603.53
Jones, Alexandra, B,2020245.950.000.000.0045.95
Wright, Robert, C,158894848.030.000.000.004848.03
Morgan, Evan, G,14725318.830.000.000.00318.83
Sharma, Kathryn,20740140.940.000.000.00140.94
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Morgan, Isaiah,18978118.730.000.000.00118.73
Watson, Devin, A,18875114.950.000.000.00114.95
Harris, Joshua, L,2028095.940.000.0030.9764.97
Rogers, Jade, I,14332102.250.000.000.00102.25
Hill, Blake,11748131.540.000.000.00131.54
Washington, Ryan,2833294.480.000.000.0094.48
Gonzalez, Morgan,130651700.990.000.000.001700.99
Peterson, Jared,11502829.370.000.0053.99775.38
Flores, Emily,13206163.190.000.0069.9793.22
Martin, Noah, A,1765775.970.000.0075.970.00
Price, Devin, M,18758158.510.000.0073.5584.96
Taylor, Tyler, A,12032614.960.000.00614.960.00
Reed, Kaylee, R,17371151.920.000.000.00151.92
Sara, Ivan, L,2509067.930.000.000.0067.93
Peterson, Julia, P,16497132.710.000.000.00132.71
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Hughes, Zachary,12203157.910.000.000.00157.91
Perry, Christian,246714354.600.003578.270.00776.33
Bradley, Rachel,158504813.040.000.000.004813.04
Hughes, Luis,130841798.960.000.000.001798.96
Butler, Jonathan,261804.990.000.000.004.99
Umeda, Masaki,16717233.810.000.000.00233.81
Washington, Kayla, E,14655174.960.000.0069.97104.99
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Alexander, Aidan,17387148.190.000.0056.9791.22
Robinson, Joseph,2814194.480.000.0094.480.00
Perry, Samuel,18811100.960.000.0069.9930.97
Foster, Emma,15468436.350.000.00159.99276.36
Price, Oscar, G,11833240.010.000.000.00240.01
Flores, Stephanie,259922721.550.000.002181.56539.99
Wang, Benjamin, R,274547.280.000.000.007.28
Gonzales, Miranda,11660324.720.000.000.00324.72
Morgan, Juan, C,1882191.970.000.000.0091.97
Gray, Cindy, A,13198114.950.000.0099.9714.98
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Flores, Caleb, S,12165280.640.000.00243.3737.27
Simmons, Mariah,266831270.820.00699.100.00571.72
Hernandez, Haley, L,11769478.950.000.000.00478.95
Rivera, Allison, M,13751224.910.000.000.00224.91
Alvarez, Melody,2507068.490.000.000.0068.49
Flores, Emma, P,15543180.940.000.000.00180.94
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Scott, Mason,2355139.980.000.000.0039.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Martin, Samuel,15874225.440.000.0069.99155.45
Hill, Haley, J,161033142.320.000.00792.342349.98
Peterson, Isabella,2808039.980.000.0039.980.00

Generated 2024-11-12 22:35:00.762 UTC