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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
James, Bryce,13466133.450.000.000.00133.45
Barnes, Ian, M,16106133.540.000.000.00133.54
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Brown, Anthony, J,19399151.430.000.000.00151.43
Foster, Abigail,1982346.470.000.000.0046.47
Lee, Don,188392384.970.000.000.002384.97
Campbell, Gabriella,188411145.480.000.000.001145.48
Watson, Victoria,16125588.960.000.000.00588.96
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Lee, Ethan, J,223597.280.000.000.007.28
Hughes, Antonio, P,15913712.270.000.000.00712.27
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Evans, Jordan,2920939.980.000.0039.980.00
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Sanders, Zoe, L,248254.990.000.000.004.99
Bryant, Rachel,220197.280.000.007.280.00
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Luo, Jodi,2921368.490.000.000.0068.49
Li, Jordan,17026261.390.000.00171.9389.46
Peterson, Isabella,2808039.980.000.0039.980.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Clark, Joseph, D,153954780.020.000.000.004780.02
Richardson, Charles, I,121144719.020.000.002325.962393.06
Smith, Zachary, W,2378358.980.000.0058.980.00
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Bailey, Maria, C,1915034.980.000.000.0034.98
Baker, Gabriella,174041709.980.000.000.001709.98
Griffin, Jack, L,1768632.280.000.000.0032.28
Bailey, Lauren,15864103.550.000.000.00103.55
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Mehta, Carmen, C,2743694.480.000.000.0094.48
Anand, Brendan, L,1984721.980.000.000.0021.98
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Barnes, Jeremy,2144654.980.000.000.0054.98
Peterson, Julia, P,16497132.710.000.000.00132.71
Moore, Wyatt, F,189712351.960.000.000.002351.96
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Luo, Franklin, J,2202759.980.000.000.0059.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Moore, Jonathan,2047896.460.000.000.0096.46
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Rowe, Todd,14586233.940.000.000.00233.94
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Nelson, James, L,245257.280.000.007.280.00
Stewart, Alexandria,174761700.990.000.000.001700.99
Adams, Jennifer,153624745.020.000.000.004745.02
Washington, Victoria,235577.280.000.000.007.28
Moreno, Marie,2773969.990.000.000.0069.99
Brooks, Victoria, H,16479158.510.000.000.00158.51
Alexander, Sarah,1941129.990.000.000.0029.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Rubio, Kellie,27653128.970.000.000.00128.97
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Zhang, Robert,188551155.480.000.000.001155.48
Foster, Kayla,1969371.950.000.000.0071.95
Sánchez, Angela, C,176551750.980.000.000.001750.98
Powell, Katherine, C,14574177.600.000.000.00177.60
Edwards, Hailey,242584.990.000.000.004.99
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Kumar, Cameron, S,185711120.490.000.001120.490.00
Robinson, Lauren,2719668.490.000.000.0068.49
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Perry, Eric,18314115.730.000.000.00115.73
Robinson, Madison, W,183772394.970.000.000.002394.97
Sanchez, Rachel, C,267304.990.000.000.004.99
Butler, Dalton, A,133454759.510.000.000.004759.51
Hall, Grace, A,201894.990.000.000.004.99
Stewart, Alex, M,2008463.150.000.000.0063.15
Anderson, Ryan, W,132712319.990.000.000.002319.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Li, Kevin, S,2518813.980.000.000.0013.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
Long, Chloe,167841735.980.000.000.001735.98
Perez, Katherine, J,2207924.270.000.000.0024.27
Hughes, Brittany,14387898.460.000.000.00898.46
Torres, Xavier,16840176.950.000.000.00176.95
Sanchez, Faith,270494.990.000.000.004.99
Gonzales, Jordan,2368113.980.000.000.0013.98
Rodriguez, Julia, A,264884.990.000.004.990.00
Cox, Sara, P,2775869.990.000.000.0069.99
Russell, Arianna,22728149.930.000.00149.930.00
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Alvarez, Melody,2507068.490.000.000.0068.49
Bradley, Jocelyn,230227.280.000.000.007.28
Scott, Mason,2355139.980.000.000.0039.98
Thomas, Matthew, K,13239185.700.000.000.00185.70
Perry, Benjamin,291652407.040.000.002407.040.00
Sanchez, Jared, J,2585064.470.000.000.0064.47
Robinson, Zachary, L,137092332.280.000.000.002332.28
Phillips, Andrea,1857383.740.000.000.0083.74
Lee, Alexander, S,18356149.910.000.000.00149.91
Peterson, Morgan, J,168341750.980.000.000.001750.98
Henderson, Justin, P,235917.280.000.000.007.28
Howard, Brianna, D,246304.990.000.000.004.99
Martin, Thomas, A,169521735.980.000.000.001735.98
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Collins, Jonathan,16849119.980.000.000.00119.98
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Taylor, Taylor,159054899.020.000.000.004899.02
Perry, Jackson, J,213064.990.000.000.004.99
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Lal, Jack, R,185251735.980.000.000.001735.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Garcia, Kayla, L,2130881.460.000.000.0081.46
Washington, Aaron, L,246494.990.000.000.004.99
Stewart, Cindy,14496804.480.000.000.00804.48
Thomas, Ian,191181120.490.000.000.001120.49
Reed, Kaylee, R,17371151.920.000.000.00151.92
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Hughes, Riley,2928449.990.000.000.0049.99
Bradley, Rachel,158504813.040.000.000.004813.04
Shan, Gabriel, T,2773169.990.000.000.0069.99
White, James,253317.280.000.000.007.28
Gonzalez, Morgan,130651700.990.000.000.001700.99
Ward, Destiny,16128539.990.000.000.00539.99
Zhang, Connor, R,138532329.980.000.000.002329.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Hughes, Luis,130841798.960.000.000.001798.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Nelson, Henry,193941155.480.000.000.001155.48
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Griffin, Melissa, L,287807.950.000.000.007.95
Green, Xavier,2356739.980.000.000.0039.98
Wang, Benjamin, R,274547.280.000.000.007.28
Gray, Seth, M,2008785.480.000.000.0085.48
Jones, Alexander, I,2002180.960.000.000.0080.96
Hughes, Austin, P,183681754.980.000.000.001754.98
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Campbell, Angel, D,195461174.480.000.000.001174.48
Clark, Zachary, J,2389358.980.000.000.0058.98
Li, Brandon,2933973.960.000.000.0073.96
Raje, Mindy, A,16083561.970.000.000.00561.97
Edwards, Amber, B,2051776.970.000.000.0076.97
Martin, Alfredo, P,2148039.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Simmons, Adam,253274.990.000.000.004.99
Stewart, Garrett, O,15762564.480.000.000.00564.48
Luo, Donna, E,248054.990.000.000.004.99
Adams, Carlos,1982236.960.000.000.0036.96
Murphy, Brianna, K,2834269.990.000.000.0069.99
Ross, David, M,171431763.970.000.000.001763.97
Torres, Abigail,253674.990.000.000.004.99
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Russell, Richard,2763322.260.000.000.0022.26
Simmons, Caleb, M,121934833.030.000.000.004833.03
Johnson, Ian, E,2173283.470.000.000.0083.47
Hall, Wyatt,2382713.980.000.000.0013.98
Nath, Carl, H,29001624.970.000.000.00624.97
Li, Rafael, M,217527.280.000.000.007.28
Bell, Chase,180911750.980.000.000.001750.98
Thomas, Dalton,230097.280.000.000.007.28
Sanchez, Grace,120802354.990.000.000.002354.99
Johnson, Jonathan,220597.280.000.000.007.28
Hill, Katherine, L,2670139.980.000.000.0039.98
Srini, Evelyn,16855150.950.000.000.00150.95
Ashe, Alexis, S,194141145.480.000.000.001145.48
Green, Kaylee, C,2618567.970.000.000.0067.97
Rodriguez, Natalie,2077330.970.000.000.0030.97
Cooper, Angela,195261179.470.000.000.001179.47
Bailey, Olivia,238924.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Sanders, Angel,16219553.970.000.000.00553.97
Coleman, Stephanie,2226489.970.000.000.0089.97
Gonzales, Jose,2201439.980.000.000.0039.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Blanco, Armando, F,139182397.950.000.000.002397.95
Taylor, Marcus, A,18944146.940.000.000.00146.94
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Washington, Adam, G,2543713.980.000.000.0013.98
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Shan, Christian, L,2308439.980.000.000.0039.98
Collins, Charles, B,29041628.450.000.000.00628.45
Kapoor, Preston,2143156.970.000.000.0056.97
Bradley, Nathaniel,169551760.470.000.000.001760.47
Price, Rachel, D,2532889.970.000.000.0089.97
Edwards, Logan,250024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Adams, Katherine, M,235184.990.000.000.004.99
Turner, Mary,220154.990.000.000.004.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Harris, Anthony,2144721.980.000.000.0021.98
Nath, Alison, J,171161764.960.000.000.001764.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Wang, Zachary,2214489.970.000.000.0089.97
Davis, Austin, E,133664749.040.000.000.004749.04
Moore, Ian, L,2463939.980.000.000.0039.98
Torres, Christina, M,20746119.950.000.000.00119.95
Martin, James, M,1987077.250.000.000.0077.25
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Phillips, Luis, G,207347.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Bryant, Jackson, J,2533239.980.000.000.0039.98
Ruiz, Philip,1807781.460.000.000.0081.46
Stewart, Gabriella,2803469.990.000.000.0069.99
Reed, Gabriella, A,2743778.980.000.000.0078.98
James, Julia,2497567.930.000.000.0067.93
Scott, Allison,14497804.480.000.000.00804.48
Gonzalez, Molly,1637021.980.000.000.0021.98
Patterson, Eric, A,2738478.980.000.000.0078.98
Flores, Gabriel,271117.280.000.000.007.28
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Eduardo, I,139162354.980.000.000.002354.98
Walker, Jacob, N,29027574.980.000.000.00574.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Foster, Nicole, A,2349489.970.000.000.0089.97
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Alexander, Gavin, K,2932249.990.000.000.0049.99
Kelly, Bailey, R,28284563.770.000.000.00563.77
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Long, Rachel,2828339.980.000.000.0039.98
Ramirez, Emma,29072128.970.000.000.00128.97
Martin, Christian, V,19709197.250.000.000.00197.25
Collins, Eduardo,139872329.990.000.000.002329.99
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Foster, Caleb,27112114.460.000.000.00114.46
Diaz, Faith, M,2236356.970.000.000.0056.97
Roberts, Hunter,282607.280.000.000.007.28
Perry, Lauren,248164.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Sanders, Lucas, W,268024.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95

Generated 2024-11-10 08:45:38.328 UTC