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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Foster, Emma,15468436.350.000.00159.99276.36
Lopez, Isaiah,18968151.430.000.000.00151.43
Johnson, Edward, H,23279124.990.000.000.00124.99
Bryant, Nathan,2145059.980.000.000.0059.98
Taylor, Edward, C,17442319.880.000.00230.9088.98
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Simmons, Jose,2464739.980.000.000.0039.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alexander, Julian,132172351.960.000.000.002351.96
Scott, Mason,2355139.980.000.000.0039.98
Lee, Kayla, M,2078115.230.000.000.0015.23
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Collins, Xavier, C,16646250.910.000.000.00250.91
Sanders, Isaiah,2587339.980.000.000.0039.98
Wang, Austin, A,1463284.970.000.009.9974.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Ramirez, Richard, C,282397.280.000.007.280.00
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Thompson, Xavier, R,15761192.410.000.000.00192.41
Zhang, Nathan, L,2910478.980.000.000.0078.98
Martin, Nicholas,233627.280.000.000.007.28
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Bradley, Alexandria,176911779.470.000.000.001779.47
Scott, Allison,14497804.480.000.000.00804.48
Foster, Paige,2742894.480.000.000.0094.48
Phillips, Aaron, R,2494739.980.000.000.0039.98
Perez, Timothy, L,227304.990.000.000.004.99
Alexander, Logan, E,191161183.470.000.000.001183.47
Washington, Emma,191231170.480.000.000.001170.48
Garcia, Anna, B,15572104.550.000.000.00104.55
Sanders, Lucas, W,268024.990.000.000.004.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Flores, Cassidy, L,233684.990.000.000.004.99
Garcia, Christian, J,164913106.330.000.00751.342354.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Barnes, Ian, M,16106133.540.000.000.00133.54
Rubio, Ruben, D,1887186.960.000.0086.960.00
Perry, Justin, E,167583062.340.000.000.003062.34
Harris, Jacob, G,2367939.980.000.0039.980.00
Bailey, Olivia,238924.990.000.000.004.99
Bell, Timothy, J,2810178.980.000.0078.980.00
Rogers, Jade, I,14332102.250.000.000.00102.25
Harris, Natalie,2368259.980.000.0059.980.00
Washington, Ryan,2833294.480.000.000.0094.48
Nath, Kenneth, W,170372334.970.000.000.002334.97
Allen, Allison, A,1975737.270.000.000.0037.27
Sandberg, Chase,2190475.970.000.000.0075.97
Howard, Alyssa, A,11513863.950.000.000.00863.95
Thomas, Zachary, D,28045119.980.000.000.00119.98
Barnes, Elizabeth, J,249397.280.000.000.007.28
Anderson, Madison, G,2835978.980.000.000.0078.98
Long, Sydney,279217.280.000.000.007.28
Chandra, Allen,2932753.990.000.000.0053.99
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Nelson, Katherine,2802178.980.000.000.0078.98
Sanders, Angel,16219553.970.000.000.00553.97
Russell, Richard,2763322.260.000.000.0022.26
Evans, Elijah, S,2588439.980.000.000.0039.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Coleman, Stephanie,2226489.970.000.000.0089.97
Peterson, Steven, L,234497.280.000.007.280.00
Richardson, Evan, J,15488165.300.000.000.00165.30
Gutierrez, Neil, L,214897.280.000.000.007.28
Ward, Mariah, J,2158044.910.000.000.0044.91
Roberts, Amanda,171752334.980.000.000.002334.98
Thomas, Richard,27557782.990.000.00782.990.00
Rubio, Javier, E,1972664.240.000.0064.240.00
Davis, Richard, R,15549574.980.000.00574.980.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Gray, Sara,292472447.050.000.002447.050.00
Hall, Eduardo,16847189.940.000.000.00189.94
Anderson, David, A,2209761.960.000.0061.960.00
Torres, Victoria,17551160.920.000.000.00160.92
Nelson, Adam, B,27402128.970.000.000.00128.97
Moore, Chloe, L,2626913.980.000.000.0013.98
Hughes, Samantha,2721564.470.000.000.0064.47
Campbell, Angel, D,195461174.480.000.000.001174.48
Rodriguez, Taylor,1607166.960.000.000.0066.96
Powell, Ian,2608564.470.000.000.0064.47
Brooks, Evan,2340139.980.000.000.0039.98
Adams, Jennifer,153624745.020.000.000.004745.02
Johnson, Cameron, R,137201155.480.000.000.001155.48
Stewart, Melissa,2517336.960.000.000.0036.96
Sharma, Samuel,27725119.980.000.000.00119.98
Raje, Mindy, A,16083561.970.000.000.00561.97
Butler, Jonathan,261804.990.000.000.004.99
James, Emma,127812329.980.000.000.002329.98
Luo, Jodi,2921368.490.000.000.0068.49
Shan, Christian, L,2308439.980.000.000.0039.98
Hall, Grace, A,201894.990.000.000.004.99
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Anderson, Ryan, W,132712319.990.000.000.002319.99
Smith, Chloe,17619163.920.000.000.00163.92
Young, Courtney,176222374.980.000.000.002374.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Martinez, Dominique,287888.990.000.008.990.00
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Anderson, Jasmine, A,235534.990.000.000.004.99
Harris, Destiny, M,137102341.460.000.000.002341.46
Thomas, Jessica,1684894.480.000.0094.480.00
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Martin, Madison, C,2049271.970.000.0071.970.00
Rogers, Bryce,174022304.980.000.000.002304.98
Ross, Kelly,2607676.960.000.000.0076.96
Butler, Benjamin, C,189722369.970.000.000.002369.97
Alexander, Angelica,2271471.950.000.000.0071.95
Morris, Seth,189592341.460.000.000.002341.46
Foster, Caleb,27112114.460.000.000.00114.46
Torres, Mackenzie,28153570.470.000.000.00570.47
Luo, Donna, E,248054.990.000.000.004.99
Alexander, Thomas,207607.280.000.000.007.28
White, Greg, C,174032322.280.000.000.002322.28
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Coleman, Miguel, D,2740069.990.000.0069.990.00
Anderson, Daniel,20694146.970.000.00146.970.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Adams, Gabriel, S,195271219.450.000.000.001219.45
Hughes, Anna,197052341.970.000.000.002341.97
Blue, Paige,2170313.980.000.000.0013.98
Blue, Makayla,1900029.990.000.000.0029.99
Evans, Alexandra,2432268.490.000.000.0068.49
Simmons, Brittany,2923139.980.000.000.0039.98
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Jai, Logan, H,12031769.490.000.000.00769.49
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Alexander, Lauren,189502351.960.000.000.002351.96
Edwards, Logan,250024.990.000.000.004.99
Hughes, Destiny, P,28027119.980.000.000.00119.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Edwards, Madeline,2077146.470.000.000.0046.47
Alexander, Jordan,2141259.980.000.0059.980.00
Flores, Nathan, C,2463713.980.000.000.0013.98
Russell, Rachel, C,2158124.270.000.0024.270.00
Davis, Dylan,15556588.960.000.00588.960.00
Simmons, Dylan,16133107.850.000.0038.8868.97
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Moore, Logan,2634889.970.000.0089.970.00
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
King, Sara,2235439.980.000.000.0039.98
Stewart, Olivia, B,1874923.780.000.000.0023.78
Hernandez, Jamie,27283119.980.000.00119.980.00
Perry, Brandon,22095141.980.000.000.00141.98
Ramirez, Brian, M,116182369.960.000.002369.960.00
Evans, Gabriel,2348789.970.000.000.0089.97
Martin, Katherine, J,2027339.980.000.000.0039.98
Williams, Destiny, S,15881564.990.000.00564.990.00
Russell, Nicole, M,182372318.960.000.000.002318.96
Richardson, Brian,2860878.980.000.000.0078.98
Adams, Mason, T,2052864.470.000.0064.470.00
Bailey, Maria, C,1915034.980.000.000.0034.98
Chen, Jonathan, G,13096200.690.000.000.00200.69
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Richardson, Erin, R,1633188.850.000.0088.850.00
Robinson, Zachary, L,137092332.280.000.000.002332.28
Lee, Alexander, S,18356149.910.000.000.00149.91
Baker, Mason, A,132702394.950.000.000.002394.95
Rivera, Hailey, R,2079239.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Wright, Katelyn, A,14502122.260.000.0084.9737.29
Alexander, Julia, J,15291889.470.000.000.00889.47
Anand, Brendan, L,1984721.980.000.000.0021.98
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Ward, Cole,214907.280.000.000.007.28
Diaz, Gabrielle,14893839.480.000.000.00839.48
White, Judith, R,148851155.480.000.000.001155.48
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Johnson, Jacob, I,28069553.970.000.000.00553.97
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Torres, Dalton,235037.280.000.007.280.00
Reed, Megan, A,181181750.980.000.000.001750.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Perez, Katherine, J,2207924.270.000.000.0024.27
Gray, Marcus, T,183892401.450.000.000.002401.45
Watson, Victoria,16125588.960.000.000.00588.96
Hall, Jason, A,29351119.980.000.000.00119.98
Coleman, Ian,2127639.980.000.000.0039.98
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Li, Thomas,181162376.960.000.000.002376.96
Hall, Wyatt,2382713.980.000.000.0013.98
Thomas, Dalton,230097.280.000.000.007.28
Van, Bobby,27757132.970.000.00132.970.00
Barnes, Kayla,2425639.980.000.0039.980.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Garcia, Kayla, L,2130881.460.000.000.0081.46
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Hill, Katherine, L,2670139.980.000.0039.980.00
Perry, James,192051249.840.000.000.001249.84
Gray, Sebastian, B,138782366.960.000.000.002366.96
Moore, Jennifer, A,2175964.470.000.000.0064.47
Foster, Nicole, A,2349489.970.000.000.0089.97
Alexander, Gavin, K,2932249.990.000.000.0049.99
Long, Rachel,2828339.980.000.000.0039.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Collins, Eduardo,139872329.990.000.000.002329.99
Chen, David,2720839.980.000.000.0039.98
Collins, Charles, B,29041628.450.000.000.00628.45
Campbell, Natalie, L,115122319.990.000.000.002319.99
Campbell, Lucas,2932953.990.000.000.0053.99
Price, Mariah, C,2074549.480.000.000.0049.48
Coleman, Dylan,27403132.970.000.000.00132.97
Jai, Edwin,169211754.980.000.000.001754.98
Mitchell, Thomas, J,137112380.470.000.000.002380.47
White, Edward, J,15847205.460.000.000.00205.46
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Peterson, Christina,2897694.480.000.000.0094.48
Alexander, Caroline,176541759.970.000.000.001759.97
Harris, Matthew,14330806.760.000.000.00806.76
Stewart, Allison, R,18826166.430.000.0069.9996.44
Moreno, Marie,2773969.990.000.000.0069.99
Hernandez, Sierra,27393123.980.000.00123.980.00
Barnes, Emily, G,15996564.990.000.000.00564.99
Barnes, Dalton, C,178581700.990.000.000.001700.99
Hall, Kaylee, E,1975137.270.000.000.0037.27
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Thompson, Madison, L,187882351.960.000.000.002351.96
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Alexander, Sarah,1941129.990.000.000.0029.99
Hill, Jordan, J,16005198.730.000.00102.2796.46
Collins, Amanda,2078339.980.000.000.0039.98
Bryant, Gabriel,2765669.990.000.000.0069.99
Ross, Kaitlyn,16121614.470.000.000.00614.47
Hughes, Jasmine,276284.990.000.000.004.99
Wood, Brittany,2877753.990.000.000.0053.99
Gomez, Krista,12760273.180.000.0036.27236.91
Collins, Isaac,260777.280.000.000.007.28
Allen, Sean, L,12097159.220.000.000.00159.22
Nath, Yolanda, A,2462513.980.000.000.0013.98
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Stewart, Alex, M,2008463.150.000.000.0063.15
Sánchez, Angela, C,176551750.980.000.000.001750.98
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Reed, Melanie, A,28160574.980.000.000.00574.98
Torres, Xavier,16840176.950.000.000.00176.95
Edwards, Hailey,242584.990.000.000.004.99
Martinez, Kristina, S,2134529.930.000.000.0029.93
Harris, Noah,292562393.060.000.002393.060.00

Generated 2024-09-20 00:43:58.876 UTC