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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Moore, Jonathan,2047896.460.000.000.0096.46
Moreno, Renee, C,12936265.220.000.000.00265.22
Price, Mariah, C,2074549.480.000.000.0049.48
Evans, Alexandra,2432268.490.000.000.0068.49
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Patterson, Taylor,12147271.450.000.000.00271.45
Perry, Benjamin,291652407.040.000.002407.040.00
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Martin, Samuel,15874225.440.000.0069.99155.45
Bryant, Jackson, J,2533239.980.000.000.0039.98
Hill, Eric, G,2525667.930.000.0067.930.00
Watson, Devin, A,18875114.950.000.000.00114.95
Bryant, Rachel,220197.280.000.007.280.00
Chen, Ethan,2054756.970.000.000.0056.97
Phillips, Devin,18759112.060.000.000.00112.06
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Peterson, Christina,2897694.480.000.000.0094.48
Patterson, Abigail, H,144784795.010.000.000.004795.01
Washington, Victoria,235577.280.000.000.007.28
Scott, Allison,14497804.480.000.000.00804.48
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Ashe, Alexis, S,194141145.480.000.000.001145.48
Davis, Dylan,15556588.960.000.00588.960.00
Russell, Chloe, M,12763589.960.000.000.00589.96
Hayes, Logan, J,19026113.240.000.0037.2775.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Hughes, Caroline, C,2830278.980.000.0078.980.00
Ramos, Kristi,151764703.030.000.000.004703.03
Williams, Destiny, S,15881564.990.000.00564.990.00
Sharma, Samuel,27725119.980.000.000.00119.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Long, Brandon, M,16110650.470.000.000.00650.47
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Williams, Ian, M,175581750.470.000.000.001750.47
Wilson, Grace,17539205.920.000.000.00205.92
Brooks, Steven, C,14877889.470.000.000.00889.47
Moore, Chloe, L,2626913.980.000.000.0013.98
Gutierrez, Neil, L,214897.280.000.000.007.28
Harris, Samantha, A,244874.990.000.000.004.99
Roberts, Amanda,171752334.980.000.000.002334.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Jai, Luis, A,18320185.920.000.000.00185.92
Brooks, Lucas, S,16089342.030.000.000.00342.03
Washington, Aaron, L,246494.990.000.000.004.99
Gomez, Krista,12760273.180.000.0036.27236.91
Thomas, Ian,191181120.490.000.000.001120.49
Flores, Kevin,15878225.920.000.0069.97155.95
Turner, Adam, K,16109548.980.000.000.00548.98
Nelson, James, L,245257.280.000.007.280.00
Hernandez, Marcus,185952329.990.000.000.002329.99
Hernandez, Sierra,27393123.980.000.00123.980.00
Brown, Benjamin, D,151874725.320.000.000.004725.32
Stewart, Allison, R,18826166.430.000.0069.9996.44
Bryant, Samantha,18345115.470.000.000.00115.47
Gray, Mariah,222787.280.000.007.280.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wright, Carol, C,12928247.410.000.0033.98213.43
Brooks, Evan,2340139.980.000.000.0039.98
She, Shawn, J,16902141.980.000.000.00141.98
Jackson, Victoria,270194.990.000.000.004.99
Yuan, Leonard, F,167911729.970.000.000.001729.97
Walker, Richard, T,19640224.550.000.000.00224.55
Henderson, Abigail,2044139.980.000.000.0039.98
Patterson, Eric, A,2738478.980.000.000.0078.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Roberts, Hunter,282607.280.000.000.007.28
Perry, Lauren,248164.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Foster, Isabelle,2637739.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Ma, Tiffany,2157739.980.000.000.0039.98
Watson, Victoria,16125588.960.000.000.00588.96
Davis, Jonathan,2925913.980.000.000.0013.98
Taylor, Taylor,159054899.020.000.000.004899.02
Price, Rachel, D,2532889.970.000.000.0089.97
Long, Elizabeth, F,127822400.950.000.000.002400.95
Cook, Joan,235544.990.000.000.004.99
Lal, Jack, R,185251735.980.000.000.001735.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Taylor, Marcus, A,18944146.940.000.000.00146.94
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Richardson, Lauren, C,14867839.480.000.000.00839.48
Morgan, Isabella, L,28602144.470.000.000.00144.47
Wang, Zachary,2214489.970.000.000.0089.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Li, Brandon,2933973.960.000.000.0073.96
Collins, Eduardo,139872329.990.000.000.002329.99
Williams, Joshua,260514.990.000.000.004.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
White, James,253317.280.000.000.007.28
Thompson, Blake,18390141.960.000.000.00141.96
Hill, Blake,11748131.540.000.000.00131.54
Gonzalez, Morgan,130651700.990.000.000.001700.99
Flores, Gabriel,271117.280.000.000.007.28
Morris, Alyssa,28072548.980.000.000.00548.98
Harris, Destiny, M,137102341.460.000.000.002341.46
Evans, Elijah, S,2588439.980.000.000.0039.98
Gonzales, Jose,2201439.980.000.000.0039.98
Ward, Mariah, J,2158044.910.000.000.0044.91
Baker, Allison,2649558.980.000.000.0058.98
Butler, Benjamin, C,189722369.970.000.000.002369.97
Sanders, Isaiah,2587339.980.000.000.0039.98
Morris, Seth,189592341.460.000.000.002341.46
Hughes, Anna,197052341.970.000.000.002341.97
Morgan, Juan, C,1882191.970.000.000.0091.97
Robinson, Julia,28121119.980.000.000.00119.98
Jai, Logan, H,12031769.490.000.000.00769.49
Wang, Karen, P,1955331.970.000.000.0031.97
Martin, Nicholas,233627.280.000.000.007.28
Perry, Brandon,22095141.980.000.000.00141.98
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Edwards, Hunter,2422067.930.000.000.0067.93
Bennett, Brittany, J,2233239.980.000.000.0039.98
Andersen, Latoya, J,290578.990.000.000.008.99
Miller, Andrew, C,271104.990.000.000.004.99
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Coleman, Dylan,27403132.970.000.000.00132.97
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Moore, Wyatt, F,189712351.960.000.000.002351.96
Raje, Mindy, A,16083561.970.000.000.00561.97
Edwards, Amber, B,2051776.970.000.000.0076.97
Bailey, Maria, C,1915034.980.000.000.0034.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Allen, Mason,176252431.950.000.000.002431.95
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Martin, Katherine, J,2027339.980.000.000.0039.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Collins, Amanda,2078339.980.000.000.0039.98
Gonzales, Emily, P,21777180.980.000.000.00180.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Sanchez, Shelby,16021539.990.000.000.00539.99
Robinson, Ian, D,138522294.990.000.000.002294.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Butler, Cassidy, L,21792114.460.000.000.00114.46
Howard, Erin, L,183621725.210.000.000.001725.21
Foster, Paige,2742894.480.000.000.0094.48
Moore, Ian, L,2463939.980.000.000.0039.98
Nath, Carl, H,29001624.970.000.000.00624.97
Washington, Emma,191231170.480.000.000.001170.48
Martin, Christian, V,19709197.250.000.000.00197.25
Flores, Cassidy, L,233684.990.000.000.004.99
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Thompson, Lucas, O,212774.990.000.000.004.99
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Lewis, Rachel, J,14900839.480.000.000.00839.48
Li, Thomas,181162376.960.000.000.002376.96
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Reed, Kaylee, R,17371151.920.000.000.00151.92
Simmons, David, E,120172339.970.000.002339.970.00
Sara, Ivan, L,2509067.930.000.000.0067.93
King, Gabrielle,263504.990.000.000.004.99
King, Sara,2235439.980.000.000.0039.98
Williams, Austin,2035432.220.000.000.0032.22
Ward, Destiny,16128539.990.000.000.00539.99
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Watson, Erin, B,227724.990.000.004.990.00
Ward, Eduardo, I,139162354.980.000.000.002354.98
Smith, Nathan,217647.280.000.007.280.00
Chandra, Allen,2932753.990.000.000.0053.99
Van, Bobby,27757132.970.000.00132.970.00
Bell, Brooke, H,2325339.980.000.000.0039.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Henderson, Justin, P,235917.280.000.000.007.28
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Clark, Destiny, L,28600119.980.000.000.00119.98
Johnson, Ian, E,2173283.470.000.000.0083.47
Phillips, Luis, G,207347.280.000.000.007.28
Blanco, Armando, F,139182397.950.000.000.002397.95
Chow, Candice,1923260.960.000.000.0060.96
Johnson, Madison, L,15530846.460.000.000.00846.46
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Harris, Anthony,2144721.980.000.000.0021.98
Watson, Shelby, J,14911867.970.000.000.00867.97
Hughes, Austin, P,183681754.980.000.000.001754.98
Thompson, Brianna, X,1864269.970.000.000.0069.97
Griffin, James,28189567.760.000.000.00567.76
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Gonzales, Gavin,2448813.980.000.000.0013.98
Martin, Thomas, A,169521735.980.000.000.001735.98
Kapoor, Preston,2143156.970.000.000.0056.97
Ruiz, Philip,1807781.460.000.000.0081.46
Williams, Sydney, J,15334848.470.000.000.00848.47
Ward, Natalie, J,132412325.960.000.000.002325.96
Adams, Katherine, M,235184.990.000.000.004.99
Alexander, Logan, E,191161183.470.000.000.001183.47
Stewart, Sara,17347119.720.000.000.00119.72
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Flores, Hannah,1952540.230.000.000.0040.23
Bailey, Olivia,238924.990.000.000.004.99
Robinson, Abigail, R,183792362.270.000.000.002362.27
Hughes, Justin, M,181222439.990.000.000.002439.99
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Thomas, Emily,2180339.980.000.000.0039.98
Jones, Joshua,184012294.990.000.000.002294.99
Johnson, Edward, H,23279124.990.000.000.00124.99
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Rodriguez, Taylor,1607166.960.000.000.0066.96
Long, Sarah,173721729.970.000.000.001729.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Washington, Ryan,2833294.480.000.000.0094.48
Hall, Kyle, J,1749169.970.000.000.0069.97
Cook, Seth,2301064.470.000.000.0064.47
Brown, Dylan, J,124492351.960.000.000.002351.96
Gray, Cody, C,144594775.010.000.000.004775.01
Hall, Grace, A,201894.990.000.000.004.99
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28
Blue, Makayla,1900029.990.000.000.0029.99
Nelson, Luis,234884.990.000.000.004.99
Nelson, Henry,193941155.480.000.000.001155.48
Cooper, Brian, L,13760128.840.000.000.00128.84
Scott, Mason,2355139.980.000.000.0039.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Stewart, Olivia, B,1874923.780.000.000.0023.78
Lee, Don,188392384.970.000.000.002384.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Hayes, Gavin, A,194001179.470.000.000.001179.47
Powell, Ian,2608564.470.000.000.0064.47
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Campbell, Lucas,2932953.990.000.000.0053.99
Alexander, Caroline,176541759.970.000.000.001759.97
Stewart, Melissa,2517336.960.000.000.0036.96
Baker, Gabriella,174041709.980.000.000.001709.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Dalton, C,178581700.990.000.000.001700.99
Wilson, Eduardo,15323804.470.000.000.00804.47
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 09:40:30.439 UTC