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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Edwards, Logan,250024.990.000.000.004.99
Jones, Dalton, T,189512334.970.000.000.002334.97
Long, Rachel,2828339.980.000.000.0039.98
Cook, Seth,2301064.470.000.000.0064.47
Srini, Evelyn,16855150.950.000.000.00150.95
Johnson, Jacob, I,28069553.970.000.000.00553.97
Reed, Morgan, E,2877923.970.000.000.0023.97
Garcia, Jonathan,1888386.960.000.000.0086.96
Taylor, Marcus, A,18944146.940.000.000.00146.94
Coleman, Stephanie,2226489.970.000.000.0089.97
Garcia, Xavier, M,2030071.970.000.000.0071.97
Kumar, Zachary,254334.990.000.000.004.99
Kumar, Elijah,15197156.920.000.000.00156.92
Gonzales, Jose,2201439.980.000.000.0039.98
Bryant, Dakota, L,176132401.950.000.000.002401.95
Simmons, Jose,2464739.980.000.000.0039.98
Miller, Jill,129142329.980.000.000.002329.98
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Turner, James, E,16841126.960.000.000.00126.96
Ross, David, M,171431763.970.000.000.001763.97
Roberts, Jordan, M,1680039.250.000.000.0039.25
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Evans, Jordan,2920939.980.000.000.0039.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Murphy, Maria,160113657.260.000.000.003657.26
Allen, Mason,176252431.950.000.000.002431.95
Smith, Alexandra,2829261.960.000.000.0061.96
Hughes, Austin, P,183681754.980.000.000.001754.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Harris, Anthony,2144721.980.000.000.0021.98
Cox, Katelyn, B,2174230.970.000.000.0030.97
Chandra, Allen,2932753.990.000.000.0053.99
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Nath, Alison, J,171161764.960.000.000.001764.96
Hall, Amber,20106131.950.000.000.00131.95
Russell, Richard,2763322.260.000.000.0022.26
Jones, Michael, A,2210771.970.000.000.0071.97
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Johnson, Anthony, D,270224.990.000.000.004.99
Wang, Zachary,2214489.970.000.000.0089.97
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Hill, Eric, G,2525667.930.000.000.0067.93
Ortega, Sheila, M,2763239.980.000.000.0039.98
Cooper, Brian, L,13760128.840.000.000.00128.84
Richardson, Devin, G,2131836.960.000.000.0036.96
Diaz, Kaitlyn, B,292304.990.000.000.004.99
Gonzales, Gavin,2448813.980.000.000.0013.98
Turner, Eduardo,158764789.020.000.000.004789.02
Rivera, Hailey, R,2079239.980.000.000.0039.98
Adams, Kyle, E,1881269.990.000.000.0069.99
Hayes, Jason,261764.990.000.000.004.99
Baker, Eduardo,180921789.450.000.000.001789.45
Flores, Brandon, L,2562189.970.000.000.0089.97
Harris, Samuel, M,2477159.980.000.000.0059.98
Martin, Alfredo, P,2148039.980.000.000.0039.98
Foster, Abigail,1982346.470.000.000.0046.47
Ramirez, Emma,29072128.970.000.000.00128.97
Thompson, Blake,18390141.960.000.000.00141.96
Kapoor, Preston,2143156.970.000.000.0056.97
Watson, Victoria,16125588.960.000.000.00588.96
Stewart, Alexandria,174761700.990.000.000.001700.99
Griffin, Isabelle,249864.990.000.000.004.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Walker, Destiny, M,169961754.980.000.000.001754.98
Malhotra, Brenda,133912405.470.000.000.002405.47
Morris, Seth,189592341.460.000.000.002341.46
Nath, Yolanda, A,2462513.980.000.000.0013.98
Hayes, Gavin, A,194001179.470.000.000.001179.47
Williams, Joshua,260514.990.000.000.004.99
Alexander, Thomas,207607.280.000.000.007.28
Robinson, Madison, W,183772394.970.000.000.002394.97
Adams, Jennifer,153624745.020.000.000.004745.02
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Walker, Jasmine,134604693.040.000.000.004693.04
Perez, Barry, M,2728269.990.000.000.0069.99
Andersen, Latoya, J,290578.990.000.000.008.99
Hall, Jason, A,29351119.980.000.000.00119.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Rogers, Paige, H,17125539.990.000.000.00539.99
Nath, Kenneth, W,170372334.970.000.000.002334.97
Coleman, Ian,2127639.980.000.000.0039.98
Long, Chloe,167841735.980.000.000.001735.98
Gray, Marcus, T,183892401.450.000.000.002401.45
Roberts, Rebecca,2800094.480.000.000.0094.48
Henderson, Austin,2764354.980.000.000.0054.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Li, Eugene, A,15283865.950.000.000.00865.95
Thomas, Zachary, D,28045119.980.000.000.00119.98
Ross, Seth, M,184332329.980.000.000.002329.98
Sanchez, Faith,270494.990.000.000.004.99
Thompson, Lucas, O,212774.990.000.000.004.99
Rogers, Olivia,12020804.470.000.000.00804.47
Carter, Madeline, A,2752269.990.000.000.0069.99
Davis, Justin,2807412.940.000.000.0012.94
Lewis, Rachel, J,14900839.480.000.000.00839.48
Hughes, Eduardo,15564188.520.000.000.00188.52
Li, Thomas,181162376.960.000.000.002376.96
Foster, Jessica,2606951.460.000.000.0051.46
Morgan, Isabella, L,28602144.470.000.000.00144.47
Bell, Danielle,140414765.020.000.000.004765.02
James, Julia,2497567.930.000.000.0067.93
Suri, Carolyn, S,12972175.710.000.000.00175.71
Torres, Abigail,253674.990.000.000.004.99
Green, Chloe, J,1465892.820.000.000.0092.82
Robinson, Julia,28121119.980.000.000.00119.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Wilson, Grace,17539205.920.000.000.00205.92
Lewis, Brandon, A,2903769.990.000.000.0069.99
Griffin, Jack, L,1768632.280.000.000.0032.28
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Gabriel,2765669.990.000.000.0069.99
Bryant, Brittany,2254548.970.000.000.0048.97
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Eduardo, S,2896962.980.000.000.0062.98
Price, Mariah, C,2074549.480.000.000.0049.48
Roberts, Wyatt,15900699.970.000.000.00699.97
Peterson, Mason, A,185701174.480.000.000.001174.48
Peterson, Christina,2897694.480.000.000.0094.48
Thomas, Megan,2907169.990.000.000.0069.99
Jai, Jose,12944164.210.000.000.00164.21
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Lal, Caleb, R,1586874.460.000.000.0074.46
Griffin, Seth, R,17585164.460.000.000.00164.46
Davis, Ethan,136604750.010.000.000.004750.01
Gray, Mariah,222787.280.000.000.007.28
Shan, Chad, M,2462112.940.000.000.0012.94
She, Shawn, J,16902141.980.000.000.00141.98
Coleman, Spencer,15993597.260.000.000.00597.26
Cook, Jacqueline, A,1922360.370.000.000.0060.37
Kelly, Julia,2379867.930.000.000.0067.93
Baker, Robert, A,273007.280.000.000.007.28
Smith, Hannah, J,2526554.980.000.000.0054.98
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Bradley, Jocelyn,230227.280.000.000.007.28
Carter, Isaac,137191129.480.000.000.001129.48
King, Gabrielle,263504.990.000.000.004.99
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Simmons, David, E,120172339.970.000.000.002339.97
Peterson, Melissa, S,249954.990.000.000.004.99
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Gonzales, Kayla,214947.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Ruiz, Philip,1807781.460.000.000.0081.46
Smith, Eduardo,2069139.980.000.000.0039.98
Barnes, Kayla,2425639.980.000.000.0039.98
Lewis, Christopher,1875586.960.000.000.0086.96
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Clark, Destiny, L,28600119.980.000.000.00119.98
Russell, Chloe, M,12763589.960.000.000.00589.96
Reed, Gabriella, A,2743778.980.000.000.0078.98
Richardson, Brian,2860878.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Alexander, Jason,2932849.990.000.000.0049.99
Parker, Caleb, A,2631813.980.000.000.0013.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Morris, Mason, J,22349124.990.000.000.00124.99
Flores, Julia, E,172631700.990.000.000.001700.99
Barnes, Elizabeth, J,249397.280.000.000.007.28
Long, Sydney,279217.280.000.000.007.28
Wilson, Madison, H,1982821.980.000.000.0021.98
Griffin, Marcus,2075634.560.000.000.0034.56
Ross, Kaitlyn,16121614.470.000.000.00614.47
Blue, Melanie, L,178611749.960.000.000.001749.96
Torres, Victoria,17551160.920.000.000.00160.92
Barnes, Ian, M,16106133.540.000.000.00133.54
Reed, Isaac, D,260747.280.000.000.007.28
Roberts, Carlos,2319639.980.000.000.0039.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Flores, Gabriel,271117.280.000.000.007.28
Howard, Alyssa, A,11513863.950.000.000.00863.95
Russell, Caleb,23552103.480.000.000.00103.48
Hayes, Dalton, C,188822322.280.000.000.002322.28
Hughes, Luis,130841798.960.000.000.001798.96
Brown, Dylan, J,124492351.960.000.000.002351.96
Ward, Mariah, J,2158044.910.000.000.0044.91
Robinson, Ian, D,138522294.990.000.000.002294.99
Rivera, Sara,187852350.960.000.000.002350.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Gonzales, Jordan,2368113.980.000.000.0013.98
Diaz, Trevor, B,2051954.960.000.000.0054.96
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Reed, Megan, A,181181750.980.000.000.001750.98
Smith, Austin,13707149.050.000.000.00149.05
Phillips, Haley, B,2807939.980.000.000.0039.98
White, Greg, C,174032322.280.000.000.002322.28
Griffin, Melissa, L,287807.950.000.000.007.95
Gray, Seth, M,2008785.480.000.000.0085.48
Foster, Isabelle,2637739.980.000.000.0039.98
Price, Caroline,180511735.980.000.000.001735.98
Evans, Alexandra,2432268.490.000.000.0068.49
Bennett, Brittany, J,2233239.980.000.000.0039.98
Chen, Ethan,2054756.970.000.000.0056.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Collins, Jonathan,16849119.980.000.000.00119.98
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Luke, L,247337.280.000.000.007.28
Thomas, Dalton,230097.280.000.000.007.28
Edwards, Amber, B,2051776.970.000.000.0076.97
Foster, Jose, C,2878534.990.000.000.0034.99
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Gonzalez, Molly,1637021.980.000.000.0021.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Stewart, Garrett, O,15762564.480.000.000.00564.48
Foster, Caleb,27112114.460.000.000.00114.46
Diaz, Faith, M,2236356.970.000.000.0056.97
Butler, Jonathan,261804.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Anderson, Ryan, W,132712319.990.000.000.002319.99
Perry, Lauren,248164.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Thomas, Jeremiah,183721760.470.000.000.001760.47
Perry, James,192051249.840.000.000.001249.84
Walker, Jacob, N,29027574.980.000.000.00574.98
Rogers, Bryce,174022304.980.000.000.002304.98
Sanders, Lucas, W,268024.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Moore, Jennifer, A,2175964.470.000.000.0064.47
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Miller, Destiny,251577.280.000.000.007.28
Edwards, Hunter,2422067.930.000.000.0067.93
Jones, Alexander, I,2002180.960.000.000.0080.96
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Baker, Gabriella,174041709.980.000.000.001709.98
Turner, Mary,220154.990.000.000.004.99
Nelson, Katherine,2802178.980.000.000.0078.98
Bell, Brooke, H,2325339.980.000.000.0039.98
Baker, Mason, A,132702394.950.000.000.002394.95
Li, Brandon,2933973.960.000.000.0073.96
Stewart, Makayla,16649115.940.000.000.00115.94
Washington, Adam, G,2543713.980.000.000.0013.98
Campbell, Timothy,2584513.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
White, Judith, R,148851155.480.000.000.001155.48
Davis, Jonathan,2925913.980.000.000.0013.98
Sanchez, Rachel, C,267304.990.000.000.004.99
Lee, Samantha, B,2737878.980.000.000.0078.98
Kelly, Erin, D,2351364.470.000.000.0064.47
_SUM1806517.5025543.71493581.21255540.501031852.08

Generated 2025-12-21 16:18:59.162 UTC