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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Harris, Seth, M,161402528.330.000.000.002528.33
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Lewis, Christopher,1875586.960.000.000.0086.96
Sánchez, Angela, C,176551750.980.000.000.001750.98
Jenkins, Austin, D,15748296.910.000.000.00296.91
Powell, Katherine, C,14574177.600.000.000.00177.60
Hayes, Dalton, C,188822322.280.000.000.002322.28
Edwards, Hailey,242584.990.000.000.004.99
Davis, Thomas,167641760.470.000.000.001760.47
Jones, Dalton, T,189512334.970.000.000.002334.97
Coleman, Spencer,15993597.260.000.000.00597.26
Johnson, Jacob, I,28069553.970.000.000.00553.97
Hughes, Antonio, P,15913712.270.000.000.00712.27
Butler, Dalton, A,133454759.510.000.000.004759.51
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Stewart, Alex, M,2008463.150.000.000.0063.15
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Yuan, Leonard, F,167911729.970.000.000.001729.97
Simmons, Caleb, M,121934833.030.000.000.004833.03
Torres, Xavier,16840176.950.000.000.00176.95
Johnson, Ian, E,2173283.470.000.000.0083.47
Torres, Christina, M,20746119.950.000.000.00119.95
Rivera, Sara,187852350.960.000.000.002350.96
Martin, James, M,1987077.250.000.000.0077.25
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Thomas, Matthew, K,13239185.700.000.000.00185.70
Reed, Megan, A,181181750.980.000.000.001750.98
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Bell, Garrett, J,14265161.230.000.000.00161.23
Lee, Samantha, B,2737878.980.000.000.0078.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
White, Emma, N,16090604.960.000.000.00604.96
Hu, Gilbert, L,2876769.990.000.000.0069.99
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
Martinez, Dominique,287888.990.000.008.990.00
Srini, Evelyn,16855150.950.000.000.00150.95
Henderson, Abigail,2044139.980.000.000.0039.98
Turner, Eduardo,158764789.020.000.000.004789.02
Reed, Isaac, D,260747.280.000.000.007.28
Barnes, Ian, M,16106133.540.000.000.00133.54
Jones, Charles,22882101.450.000.000.00101.45
Foster, Abigail,1982346.470.000.000.0046.47
Torres, Mackenzie,28153570.470.000.000.00570.47
Watson, Victoria,16125588.960.000.000.00588.96
Smith, Austin,13707149.050.000.000.00149.05
Hall, Wyatt,2382713.980.000.000.0013.98
Reed, Catherine, M,203807.280.000.000.007.28
Nath, Carl, H,29001624.970.000.000.00624.97
Campbell, Jordan,13290111.890.000.000.00111.89
Li, Rafael, M,217527.280.000.000.007.28
Evans, Alexandra,2432268.490.000.000.0068.49
Bell, Chase,180911750.980.000.000.001750.98
Perez, Timothy, L,227304.990.000.000.004.99
Thomas, Dalton,230097.280.000.000.007.28
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Ashe, Alexis, S,194141145.480.000.000.001145.48
Rubio, Ruben, D,1887186.960.000.0086.960.00
Green, Kaylee, C,2618567.970.000.000.0067.97
Ross, Jose,2744178.980.000.0078.980.00
Rodriguez, Natalie,2077330.970.000.000.0030.97
Harris, Jacob, G,2367939.980.000.0039.980.00
Cooper, Angela,195261179.470.000.000.001179.47
Moore, Logan,2634889.970.000.0089.970.00
Bailey, Olivia,238924.990.000.000.004.99
Chen, Luis, G,2125294.450.000.0094.450.00
Thames, Bernard,2380368.490.000.000.0068.49
Bell, Timothy, J,2810178.980.000.0078.980.00
Sara, Ivan, L,2509067.930.000.000.0067.93
Harris, Natalie,2368259.980.000.0059.980.00
Roberts, Noah, S,2704268.490.000.000.0068.49
Hughes, Anna,197052341.970.000.000.002341.97
Roberts, Carlos,2319639.980.000.000.0039.98
Robinson, Julia,28121119.980.000.000.00119.98
Russell, Gail, L,212634.990.000.000.004.99
Yang, Aaron, C,2519654.980.000.000.0054.98
Howard, Alyssa, A,11513863.950.000.000.00863.95
Nelson, Luis,234884.990.000.000.004.99
Sanders, Angel,16219553.970.000.000.00553.97
Liu, Arturo,13222150.410.000.000.00150.41
Coleman, Stephanie,2226489.970.000.000.0089.97
Hill, Carlos,12919257.880.000.00158.9398.95
Gonzales, Jose,2201439.980.000.000.0039.98
Chen, Ethan,2054756.970.000.000.0056.97
Brown, Christian,227554.990.000.000.004.99
Brown, Julia,18065155.470.000.000.00155.47
Perry, James,192051249.840.000.000.001249.84
Stewart, Lucas, J,2934198.970.000.000.0098.97
Moore, Jennifer, A,2175964.470.000.000.0064.47
Thomas, Zachary, D,28045119.980.000.000.00119.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Roberts, Robert, R,1898656.970.000.0056.970.00
Walker, Destiny, M,169961754.980.000.000.001754.98
Lobao, Alexandre,1892691.950.000.0091.950.00
Bennett, Brittany, J,2233239.980.000.000.0039.98
Xu, Louis,2010466.530.000.0066.530.00
Taylor, Marcus, A,18944146.940.000.000.00146.94
Peterson, Steven, L,234497.280.000.007.280.00
Cooper, Brooke,195361120.490.000.000.001120.49
Butler, Isabel,16241126.960.000.000.00126.96
Henderson, Olivia,188591155.480.000.000.001155.48
Cox, Katelyn, B,2174230.970.000.000.0030.97
Shan, Christian, L,2308439.980.000.000.0039.98
He, Micah,2740169.990.000.000.0069.99
Washington, Adam, G,2543713.980.000.000.0013.98
Coleman, Joan, W,2669964.470.000.000.0064.47
Collins, Charles, B,29041628.450.000.000.00628.45
Brooks, Steven, C,14877889.470.000.000.00889.47
Kapoor, Preston,2143156.970.000.000.0056.97
Roberts, Amanda,171752334.980.000.000.002334.98
Bradley, Nathaniel,169551760.470.000.000.001760.47
Rubio, Javier, E,1972664.240.000.0064.240.00
Price, Rachel, D,2532889.970.000.000.0089.97
Prasad, Summer, M,2214339.980.000.0039.980.00
Edwards, Logan,250024.990.000.000.004.99
Anderson, David, A,2209761.960.000.0061.960.00
Flores, Cassidy, L,233684.990.000.000.004.99
Hughes, Destiny, P,28027119.980.000.000.00119.98
Miller, Destiny,251577.280.000.000.007.28
Sanchez, Stephanie,1786756.970.000.000.0056.97
Turner, Mary,220154.990.000.000.004.99
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Bell, Brooke, H,2325339.980.000.000.0039.98
Richardson, Arianna, C,1205534.980.000.0034.980.00
Adams, Katherine, M,235184.990.000.000.004.99
Scott, Eric,282484.990.000.004.990.00
Harris, Anthony,2144721.980.000.000.0021.98
Johnson, Xavier, R,2325539.980.000.0039.980.00
Nath, Alison, J,171161764.960.000.000.001764.96
Baker, Allison,2649558.980.000.000.0058.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Young, Courtney,176222374.980.000.000.002374.98
Bradley, Jocelyn,230227.280.000.000.007.28
Wang, Zachary,2214489.970.000.000.0089.97
Hughes, Isabella,2304851.460.000.000.0051.46
Sanchez, Jared, J,2585064.470.000.000.0064.47
Collins, Jose,2474839.980.000.0039.980.00
Phillips, Andrea,1857383.740.000.000.0083.74
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Peterson, Morgan, J,168341750.980.000.000.001750.98
Flores, Morgan,19817118.940.000.0039.9878.96
Davis, Austin, E,133664749.040.000.000.004749.04
Alexander, Julian,132172351.960.000.000.002351.96
Reed, Gabriella, A,2743778.980.000.000.0078.98
Gonzales, Ryan, M,173731735.980.000.000.001735.98
James, Julia,2497567.930.000.000.0067.93
Rogers, Bryce,174022304.980.000.000.002304.98
Moore, Ian, L,2463939.980.000.000.0039.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Phillips, Luis, G,207347.280.000.000.007.28
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Ramirez, Richard, C,282397.280.000.007.280.00
Bryant, Jackson, J,2533239.980.000.000.0039.98
Anderson, Daniel,20694146.970.000.00146.970.00
Ruiz, Philip,1807781.460.000.000.0081.46
Lewis, Ryan, A,203124.990.000.000.004.99
Stewart, Gabriella,2803469.990.000.000.0069.99
Hayes, Logan, J,19026113.240.000.0037.2775.97
Scott, Allison,14497804.480.000.000.00804.48
Foster, Jessica,2606951.460.000.0051.460.00
Gonzalez, Molly,1637021.980.000.000.0021.98
Richardson, Brian,2860878.980.000.000.0078.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
Brown, Dylan, J,124492351.960.000.000.002351.96
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
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Foster, Nicole, A,2349489.970.000.000.0089.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
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
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
Cook, Joan,235544.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Cannata, Gabrielle, C,217254.990.000.000.004.99
Brown, Morgan,2919778.980.000.000.0078.98
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Bryant, Dakota, L,176132401.950.000.000.002401.95
Allen, Mason,176252431.950.000.000.002431.95
Deng, Wayne,2145336.960.000.0036.960.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Peterson, Mason, A,185701174.480.000.001174.480.00
Lewis, Brandon, A,2903769.990.000.000.0069.99
Carter, Savannah, M,120902350.960.000.000.002350.96
Flores, Brandon, L,2562189.970.000.000.0089.97
Moore, Hunter,14897196.270.000.0071.58124.69
Russell, Nicole, M,182372318.960.000.000.002318.96
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Alexander, Caroline,176541759.970.000.000.001759.97
Malhotra, Brenda,133912405.470.000.000.002405.47
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Gray, Mariah,222787.280.000.007.280.00
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Nath, Yolanda, A,2462513.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Baker, Robert, A,273007.280.000.007.280.00
Edwards, Angel, J,2912469.990.000.000.0069.99
Clark, Emily, R,120862294.990.000.000.002294.99
Thomas, Megan,2907169.990.000.000.0069.99
Watson, Marcus,2271585.480.000.000.0085.48
Simmons, David, E,120172339.970.000.000.002339.97
Torres, Dalton,235037.280.000.000.007.28
Moore, Anthony, M,2473039.980.000.000.0039.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Jones, Samantha,1831721.980.000.000.0021.98
Gonzales, Emily, P,21777180.980.000.000.00180.98
Gray, Marcus, T,183892401.450.000.000.002401.45
Murphy, Chase, J,2472958.980.000.000.0058.98
Hall, Jason, A,29351119.980.000.000.00119.98
Henderson, Austin,2764354.980.000.000.0054.98
Rogers, Olivia,12020804.470.000.000.00804.47
Parker, Jeremy,2866878.980.000.000.0078.98
Van, Bobby,27757132.970.000.000.00132.97
Powell, Sydney, M,14886539.990.000.000.00539.99
Reed, Melanie, A,28160574.980.000.000.00574.98
Shan, Chad, M,2462112.940.000.000.0012.94
She, Shawn, J,16902141.980.000.000.00141.98
Green, Mackenzie, C,280737.280.000.000.007.28
Gray, Jared, A,264494.990.000.000.004.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99

Generated 2024-11-10 08:41:07.795 UTC