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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Chapman, Nancy, E,11276840.150.000.00520.87319.28
Campbell, Hailey,15507267.840.000.00267.840.00
Henderson, Ashley,111851381.370.000.00982.08399.29
Parker, Amanda,1808151.970.000.0051.970.00
Scott, Gabrielle,270614.990.000.004.990.00
Navarro, Jerome, B,11519717.280.000.00653.3163.97
Morgan, Angela,24665109.970.000.00109.970.00
Green, Blake, P,11719287.200.000.00259.9227.28
Martinez, Matthew, L,16009170.450.000.0094.4875.97
Zhang, Robert,188551155.480.000.001155.480.00
Flores, Madison,14416769.490.000.00769.490.00
Alexander, Luke,290432447.050.000.002447.050.00
Nelson, Sierra,161322459.620.000.002459.620.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Diaz, Jasmine, A,160983101.290.000.003101.290.00
Jones, Madison,246614181.760.003578.27603.490.00
Martinez, Dominique,287888.990.000.008.990.00
Gonzales, Luis,15856116.250.000.00116.250.00
Kelly, Haley,15511128.560.000.00128.560.00
Davis, Thomas,167641760.470.000.001760.470.00
Shan, Chad, M,2462112.940.000.0012.940.00
Young, Adam,12984200.200.000.00131.2368.97
Perry, Ana,112151155.520.000.00924.27231.25
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Russell, Melanie, B,15478182.830.000.00182.830.00
Flores, Caleb, S,12165280.640.000.00280.640.00
Thompson, Tyler,2750269.990.000.0069.990.00
Jenkins, Alexandra, D,11632924.610.000.00822.36102.25
Prasad, Donald,15413318.920.000.00318.920.00
Long, Gabrielle,198305765.923374.990.000.002390.93
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Green, Eric,2738069.990.000.0069.990.00
Sanchez, Jared, J,2585064.470.000.0064.470.00
Rogers, Shelby,11712127.800.000.0097.8129.99
Hu, Gilbert, L,2876769.990.000.0069.990.00
Moore, Matthew, W,13267109.950.000.0079.9729.98
King, Gabrielle,263504.990.000.004.990.00
Watson, Richard,15943365.410.000.00365.410.00
Griffin, Jason, L,112001267.110.000.00988.01279.10
Turner, Timothy, C,14641119.860.000.0084.8635.00
Alexander, Taylor,17482146.940.000.00146.940.00
Carter, Madeline, A,2752269.990.000.0069.990.00
Bell, Alex, M,167543118.600.000.003118.600.00
Watson, Olivia, S,1386093.850.000.0054.9738.88
Butler, Trevor,2741569.990.000.0069.990.00
Richardson, Nathaniel,120894710.030.000.004710.030.00
Isla, Julian, A,13732108.960.000.00108.960.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Chow, Candice,1923260.960.000.0021.9838.98
Ruiz, Philip,1807781.460.000.0081.460.00
Martin, Lucas, L,221144183.233578.270.00604.960.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Chavez, Kara, P,13285214.350.000.00119.8994.46
Thompson, Xavier, R,15761192.410.000.000.00192.41
Price, Isabelle,201825749.970.003374.990.002374.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Simmons, Brittany,2923139.980.000.000.0039.98
Alexander, Lauren,189502351.960.000.000.002351.96
Stewart, Katherine, Z,229015971.333578.270.000.002393.06
Hill, Carlos,12919257.880.000.00158.9398.95
Williams, Ethan,243094793.120.003578.270.001214.85
Lopez, Katelyn,11820232.710.000.00197.7334.98
Miller, Destiny,251577.280.000.007.280.00
Moore, Taylor, A,199874564.453374.990.001189.460.00
Sun, Arturo, C,11498557.540.000.00346.83210.71
Cook, Joan,235544.990.000.004.990.00
Liu, Arturo,13222150.410.000.0088.4461.97
Smith, Nathan,217647.280.000.007.280.00
Perry, Samuel,18811100.960.000.00100.960.00
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Barnes, Kayla,2425639.980.000.0039.980.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Patterson, Hailey, I,112231155.900.000.00964.63191.27
Lewis, Christopher,1875586.960.000.0086.960.00
Jai, Jose,12944164.210.000.00164.210.00
Brooks, Steven, C,14877889.470.000.00889.470.00
Smith, Austin,13707149.050.000.00134.0714.98
Campbell, Jordan,13290111.890.000.0088.9622.93
Campbell, Chloe,11212760.930.000.00645.19115.74
Simmons, Jennifer,112621010.560.000.00694.54316.02
Jai, Luis, A,18320185.920.000.00154.9530.97
Lewis, Ethan,27998144.470.000.00144.470.00
Thompson, Ryan, M,113301111.360.000.00792.22319.14
Reed, Kaylee, R,17371151.920.000.00136.9414.98
Kumar, Elijah,15197156.920.000.0049.97106.95
Murphy, Brianna, K,2834269.990.000.0069.990.00
King, Sara,2235439.980.000.0039.980.00
Miller, Jill,129142329.980.000.002329.980.00
Parker, Jordan,216212616.860.000.002616.860.00
Ross, Natalie, J,12916261.220.000.00188.9572.27
Garcia, Kayla, L,2130881.460.000.000.0081.46
Hernandez, José, M,11253696.610.000.00434.21262.40
Thompson, Kayla, D,12363273.900.000.00139.94133.96
Simmons, Caleb, M,121934833.030.000.004833.030.00
Green, Samuel, D,14096174.730.000.00174.730.00
Hill, Blake,11748131.540.000.0054.9576.59
Butler, Ana,260403018.330.002443.35574.980.00
Bell, Brooke, H,2325339.980.000.0039.980.00
Butler, Dalton, A,133454759.510.000.004759.510.00
Simmons, Haley, T,262022749.320.002181.56567.760.00
Collins, Luis, J,227655978.613578.270.002400.340.00
Perez, Dalton,110911125.360.000.00742.57382.79
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Brooks, Evan,2340139.980.000.000.0039.98
Long, Sarah,173721729.970.000.000.001729.97
Walker, Richard, T,19640224.550.000.00152.6071.95
Harris, Joshua, L,2028095.940.000.0030.9764.97
Washington, Caroline, D,231145996.323578.270.000.002418.05
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Perry, Christian,246714354.600.003578.270.00776.33
Russell, Samantha,11211723.560.000.00458.36265.20
Gonzalez, Jordan,15157213.940.000.00198.9614.98
Mitchell, Alexandra,14455218.930.000.00143.9574.98
Harris, Anthony,2144721.980.000.0021.980.00
Bailey, Lauren,15864103.550.000.0031.9771.58
Lewis, Kaitlyn,159064761.030.000.002341.972419.06
Brown, Anna,1624795.820.000.0095.820.00
Russell, Richard,2763322.260.000.0022.260.00
Cannata, Gabrielle, C,217254.990.000.004.990.00
Diaz, Ryan, J,16910141.960.000.00141.960.00
Adams, Connor,214232888.560.000.002049.10839.46
Luo, Jodi,2921368.490.000.000.0068.49
Hall, Grace, A,201894.990.000.000.004.99
Anderson, Ryan, W,132712319.990.000.000.002319.99
Russell, Oscar, A,12140118.170.000.0046.2671.91
Ward, Ian,12056213.920.000.00138.9474.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Rogers, Sean, G,18685124.460.000.0085.4838.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Collins, Lucas, T,219214142.753578.270.000.00564.48
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Lal, Kyle,17360122.180.000.00107.2014.98
Walker, Jacob, N,29027574.980.000.000.00574.98
Alexander, Julian,132172351.960.000.000.002351.96
Simmons, Mariah,266831270.82699.100.000.00571.72
Hernandez, Haley, L,11769478.950.000.00326.68152.27
Alvarez, Melody,2507068.490.000.000.0068.49
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Bryant, Connor,238424828.110.003578.270.001249.84
Griffin, Haley, L,1892582.180.000.0045.2236.96
Bell, Alexandria, A,13758284.130.000.00255.1428.99
Diaz, Luke,12054402.530.000.00332.5669.97
Peterson, Jessica, M,11868247.010.000.0081.94165.07
Jackson, Elizabeth, K,16837155.470.000.0085.4869.99
Alexander, Paige, W,1860459.250.000.0037.2721.98
Walker, Ian,16771104.550.000.0054.5849.97
Scott, Haley,13701154.540.000.0079.5674.98
Young, Sierra, J,11619634.840.000.00358.72276.12
Price, Oscar, G,11833240.010.000.00100.56139.45
Kelly, Bailey, R,28284563.770.000.000.00563.77
Lee, Ian,19646197.040.000.000.00197.04
Martin, Jill, C,11824181.030.000.00109.9671.07
Allen, Madeline,2924068.970.000.000.0068.97
Gomez, Briana, A,2878443.980.000.000.0043.98
Baker, Gabriella,174041709.980.000.000.001709.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Moreno, Renee, C,12936265.220.000.000.00265.22
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Martin, Tyler, L,2772469.990.000.000.0069.99
Allen, Mason,176252431.950.000.000.002431.95
Martin, Christian, V,19709197.250.000.0069.97127.28
Gonzales, Paige,2170291.940.000.0039.9851.96
Malhotra, Brenda,133912405.470.000.000.002405.47
Martin, Gina, E,11078793.270.000.00648.83144.44
Miller, Joseph, A,227134148.193578.270.000.00569.92
Collins, Charles, B,29041628.450.000.000.00628.45
Martin, Alfredo, P,2148039.980.000.000.0039.98
Anderson, Ashley,206803219.580.002049.100.001170.48
Phillips, Adam, R,227484188.243578.270.000.00609.97
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Russell, Xavier,12964119.950.000.0064.9954.96
Ross, Xavier, A,12202171.470.000.0099.5371.94
Nath, Yolanda, A,2462513.980.000.000.0013.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
Foster, Emma,15468436.350.000.00159.99276.36
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Ramirez, Abigail, S,1585974.140.000.0039.2534.89
Price, Marissa,15826160.740.000.00154.466.28
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Zeng, Jake,18054106.930.000.0036.9669.97
Turner, Andrea, A,202093268.550.002049.100.001219.45
Turner, Blake,12136131.740.000.00126.754.99
Li, Thomas,181162376.960.000.000.002376.96
She, Alisha, G,247574343.590.003578.270.00765.32
Lee, Alexander, S,18356149.910.000.000.00149.91
Henderson, Luke,19200109.240.000.000.00109.24
Diaz, Richard, A,2668264.470.000.0064.470.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Jenkins, Samantha,113311290.330.000.00923.85366.48
Harris, Isabella,17119214.900.000.00214.900.00
Russell, Arianna,22728149.930.000.00149.930.00
Nelson, Jose,19217185.020.000.00124.5560.47
Sanchez, Mariah, R,1922066.650.000.0066.650.00
Turner, James, E,16841126.960.000.00126.960.00
Evans, Jordan,2920939.980.000.0039.980.00
Green, Xavier,2356739.980.000.0039.980.00
Martin, Brianna, M,235834829.390.003578.271251.120.00
Barnes, Fernando,113001390.550.000.00913.68476.87
Gray, Seth, M,2008785.480.000.0085.480.00
Morgan, Juan, C,1882191.970.000.0021.9869.99
Anand, Brendan, L,1984721.980.000.000.0021.98
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Peterson, Julia, P,16497132.710.000.0048.9683.75
Moore, Wyatt, F,189712351.960.000.000.002351.96
Perry, Benjamin,291652407.040.000.002407.040.00
James, Maria,1624391.970.000.0091.970.00
Hill, Haley, J,161033142.320.000.003142.320.00
Wood, Gavin,16964108.540.000.00108.540.00
She, Kenneth,16096212.010.000.00188.0423.97
Harris, Samuel, M,2477159.980.000.0059.980.00
Flores, Julia, E,172631700.990.000.001700.990.00
Simmons, Sarah, V,11500651.980.000.00397.65254.33
Powell, Spencer,14904468.120.000.00207.26260.86
Ward, Emma, W,2179659.980.000.0059.980.00
White, Emily, M,159174679.060.000.002294.992384.07
Long, Sydney,279217.280.000.007.280.00
Patterson, Nicole,1972937.270.000.0037.270.00
Walker, Destiny, M,169961754.980.000.001754.980.00
Evans, Kaylee,19642133.540.000.0096.9536.59
Bailey, Richard, N,220504160.533578.270.00582.260.00
Bryant, Isabelle,233974828.110.003578.271249.840.00
Roberts, Jordan, M,1680039.250.000.0014.9824.27
Adams, Jennifer,153624745.020.000.002351.962393.06
Andersen, Latoya, J,290578.990.000.008.990.00
White, Abigail, T,15866145.820.000.0038.88106.94
Walker, Thomas,1307193.980.000.0063.9929.99
Green, Marcus, C,15974208.410.000.00138.4269.99
Hayes, Logan, J,19026113.240.000.0037.2775.97
Martinez, Carol, D,17656578.460.000.000.00578.46
Peterson, Jared,11502829.370.000.00613.28216.09
Griffin, Miguel,2146476.970.000.000.0076.97
Chen, Jonathan, G,13096200.690.000.000.00200.69
Sanders, Alexa, E,217414127.253578.270.00548.980.00
White, Nicole,16731155.910.000.00116.9338.98
Smith, Zachary, W,2378358.980.000.0058.980.00
Davis, Dylan,15556588.960.000.00588.960.00
Stewart, Destiny,13144281.470.000.00281.470.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Richardson, Arianna, C,1205534.980.000.0034.980.00
Moore, Jessica, J,2008576.760.000.0076.760.00
Gray, Isabella,168203217.790.000.002341.46876.33
Stewart, Melissa,2517336.960.000.0036.960.00
Thomas, William, A,216142589.090.000.002589.090.00

Generated 2024-05-19 04:40:07.097 UTC