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

261 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Ward, Angela, M,2775669.990.000.000.0069.99
Reed, Megan, A,181181750.980.000.000.001750.98
Yang, Jordan, K,14458133.950.000.000.00133.95
Moore, Ian, L,2463939.980.000.000.0039.98
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Price, Caroline,180511735.980.000.000.001735.98
Fernandez, Darren,2899278.980.000.000.0078.98
Ma, Tiffany,2157739.980.000.000.0039.98
Tang, Carl,2123832.270.000.000.0032.27
Watson, Victoria,16125588.960.000.000.00588.96
Johnson, James,234984.990.000.000.004.99
Lobao, Alexandre,1892691.950.000.000.0091.95
Carter, Marcus, l,2147131.970.000.000.0031.97
Thames, Bernard,2380368.490.000.000.0068.49
Reed, Erin, I,14353128.840.000.000.00128.84
Thomas, Ian,191181120.490.000.000.001120.49
Bailey, Jessica, L,12945218.440.000.000.00218.44
Collins, Jonathan,16849119.980.000.000.00119.98
Powell, Jack, J,1841156.960.000.000.0056.96
Nath, Carl, H,29001624.970.000.000.00624.97
Cook, Bryce,2864069.990.000.000.0069.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Bell, Chase,180911750.980.000.000.001750.98
Turner, Blake,12136131.740.000.000.00131.74
Rodriguez, Natalie,2077330.970.000.000.0030.97
Peterson, Alex, M,13423132.900.000.000.00132.90
Roberts, Carlos,2319639.980.000.000.0039.98
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Washington, Ryan,2833294.480.000.000.0094.48
Lopez, Jack, I,2904751.460.000.000.0051.46
Martin, Noah, A,1765775.970.000.000.0075.97
Hayes, Oscar,2652729.260.000.000.0029.26
Sanders, Angel,16219553.970.000.000.00553.97
Hall, Luke, E,14745902.460.000.000.00902.46
Coleman, Stephanie,2226489.970.000.000.0089.97
Scott, Gabrielle,270614.990.000.000.004.99
Brown, Dylan, J,124492351.960.000.000.002351.96
Thompson, Isabella,18756128.410.000.000.00128.41
Ward, Mariah, J,2158044.910.000.000.0044.91
Washington, Thomas, C,2745137.430.000.000.0037.43
Brooks, Makayla,222526047.320.003578.270.002469.05
Townsend, Bryan,14077180.730.000.000.00180.73
Taylor, Christian,2076456.760.000.000.0056.76
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Nelson, Jennifer,171471700.990.000.000.001700.99
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Brittany,2254548.970.000.000.0048.97
Hughes, Jasmine,276284.990.000.000.004.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Griffin, Maria,1840763.250.000.000.0063.25
Murphy, Catherine, L,1650692.050.000.000.0092.05
Harris, Isabella,17119214.900.000.000.00214.90
Patterson, Maria, G,1333094.950.000.000.0094.95
Zhang, Heather,166543056.320.000.000.003056.32
Martinez, Kristina, S,2134529.930.000.000.0029.93
Reed, Mariah,263731565.910.000.001000.44565.47
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Foster, Isabel, M,2174571.950.000.000.0071.95
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
James, Sara,198023374.993374.990.000.000.00
Green, Isabella,26620699.10699.100.000.000.00
Murphy, Emma,198445807.930.003374.990.002432.94
Perry, Jennifer, J,221205962.340.003578.270.002384.07
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Simmons, Mariah,266831270.820.00699.100.00571.72
Brooks, Paige,222325985.310.003578.270.002407.04
Parker, Madeline, H,221826006.320.003578.270.002428.05
Miller, Benjamin, G,26643699.100.00699.100.000.00
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Miller, Joseph, A,227134148.190.003578.270.00569.92
Lewis, Seth,26782699.100.00699.100.000.00
Turner, Courtney, A,229753578.270.003578.270.000.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Jenkins, Megan, R,12074261.380.000.000.00261.38
Cooper, Andrea,2932378.980.000.000.0078.98
Parker, Caleb, A,2631813.980.000.000.0013.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Umeda, Masaki,16717233.810.000.000.00233.81
Phillips, Devin,18759112.060.000.000.00112.06
Flores, Julia, E,172631700.990.000.000.001700.99
Morgan, Marcus, W,289682.290.000.000.002.29
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Wilson, Grace,17539205.920.000.000.00205.92
Hall, Lauren, A,19648100.840.000.000.00100.84
Moore, Chloe, L,2626913.980.000.000.0013.98
Hill, Timothy,14871848.470.000.000.00848.47
Henderson, Abigail,2044139.980.000.000.0039.98
Reed, Isaac, D,260747.280.000.000.007.28
Henderson, Hailey, C,171481775.470.000.000.001775.47
Smith, Andrew,1472387.570.000.000.0087.57
White, Greg, C,174032322.280.000.000.002322.28
Hall, Jan, M,11740334.120.000.000.00334.12
Watson, Devin, A,18875114.950.000.000.00114.95
James, Juan,232674862.090.003578.270.001283.82
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Shan, Benjamin,235663578.270.003578.270.000.00
Bryant, Connor,238424828.110.003578.270.001249.84
Thompson, Jose,237314828.110.003578.270.001249.84
Foster, Olivia,238063578.270.003578.270.000.00
Flores, Xavier,238664828.110.003578.270.001249.84
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Perry, Jonathan, T,27026699.100.00699.100.000.00
Lewis, Morgan,17410168.740.000.000.00168.74
Wright, Kyle,2371626.970.000.000.0026.97
Roberts, Amanda,171752334.980.000.000.002334.98
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Morgan, Isaiah,18978118.730.000.000.00118.73
Turner, Morgan,11823178.470.000.000.00178.47
Harris, Joshua, L,2028095.940.000.000.0095.94
Adams, Connor,214232888.560.000.002049.10839.46
Hall, Grace, A,201894.990.000.000.004.99
Anderson, Ryan, W,132712319.990.000.000.002319.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Srini, Ruben,18078200.940.000.000.00200.94
Walker, Isabella,243864143.740.003578.27565.470.00
Sharma, Yolanda, K,250483046.840.002443.350.00603.49
Green, Sophia, E,249772181.560.002181.560.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Hughes, Julia,250612443.350.002443.350.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
White, Jennifer, S,27027782.990.00782.990.000.00
Cox, Lucas, J,253932443.350.000.002443.350.00
Cook, Steven, J,27053782.990.000.00782.990.00
Coleman, Lucas, A,27060782.990.000.00782.990.00
Lewis, Isabella,2624267.930.000.000.0067.93
Scott, Kaitlyn, A,12159218.910.000.000.00218.91
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Allen, Mason,176252431.950.000.000.002431.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Cooper, Grace, C,1601294.260.000.000.0094.26
Rivera, Makayla, A,2878334.990.000.000.0034.99
Williams, Edward, D,14274121.560.000.000.00121.56
Martin, Brandon, S,2169139.980.000.000.0039.98
Bradley, Evan,18506101.940.000.000.00101.94
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Diaz, Gabrielle,14893839.480.000.000.00839.48
Sanchez, Rachel, C,267304.990.000.000.004.99
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Rogers, Paige, H,17125539.990.000.000.00539.99
Yuan, Brendan, S,247444.990.000.000.004.99
Coleman, Ian,2127639.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Hughes, Brittany,14387898.460.000.000.00898.46
Morgan, Isabella, L,28602144.470.000.000.00144.47
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Long, Xavier,112512318.960.000.000.002318.96
Yang, Justin, S,153634719.040.000.000.004719.04
Watson, Shelby, J,14911867.970.000.000.00867.97
Kumar, Austin,204834400.060.000.002049.102350.96
Wilson, Christian,27085782.990.000.00782.990.00
Miller, Katherine, B,27102782.990.000.00782.990.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Diaz, Hunter, S,27242782.990.000.00782.990.00
Taylor, Victoria,260132443.350.000.002443.350.00
Washington, Taylor,212664525.070.000.002049.102475.97
Davis, Emily,27267782.990.000.00782.990.00
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Foster, Deb,215012661.400.000.002661.400.00
Collins, Connor, J,27270782.990.000.00782.990.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Hayes, Carson, A,124472331.950.000.000.002331.95
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Sharma, Samuel,27725119.980.000.000.00119.98
Thomas, Emily,2180339.980.000.000.0039.98
Brown, Benjamin, D,151874725.320.000.000.004725.32
Carter, Savannah, M,120902350.960.000.000.002350.96
Johnson, Edward, H,23279124.990.000.000.00124.99
Bryant, Nathan,2145059.980.000.000.0059.98
Morris, Alyssa,28072548.980.000.000.00548.98
Cook, Seth,2301064.470.000.000.0064.47
Garcia, Jonathan,1888386.960.000.000.0086.96
Harris, Destiny, M,137102341.460.000.000.002341.46
Kumar, Zachary,254334.990.000.000.004.99
Simmons, Jose,2464739.980.000.000.0039.98
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Eduardo, S,2896962.980.000.000.0062.98
Collins, Xavier, C,16646250.910.000.000.00250.91
Peterson, Christina,2897694.480.000.000.0094.48
Clark, Emily, R,120862294.990.000.000.002294.99
Blue, Makayla,1900029.990.000.000.0029.99
Morgan, Juan, C,1882191.970.000.000.0091.97
Robinson, Julia,28121119.980.000.000.00119.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Nelson, Luis,234884.990.000.000.004.99
Powell, Caleb, G,216132610.580.000.002049.10561.48
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Powell, David, W,266151000.440.000.001000.440.00
Parker, Jordan,216212616.860.000.002049.10567.76
Moore, Fernando,265821000.440.000.001000.440.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Jackson, Edward,290422420.340.000.002420.340.00
Moore, Anthony, M,2473039.980.000.000.0039.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Ward, Destiny,16128539.990.000.000.00539.99
Jackson, Brianna,1537797.910.000.000.0097.91
Green, Xavier,2356739.980.000.000.0039.98
Wang, Karen, P,1955331.970.000.000.0031.97
Diaz, Brandon,236764.990.000.000.004.99
Evans, Jordan,2920939.980.000.000.0039.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Diaz, Kaitlyn, B,292304.990.000.000.004.99
Anderson, Daniel,20694146.970.000.000.00146.97
Hughes, Austin, P,183681754.980.000.000.001754.98
Long, Rachel,2828339.980.000.000.0039.98
Griffin, James,28189567.760.000.000.00567.76
Campbell, Angel, D,195461174.480.000.000.001174.48
Phillips, Mackenzie,12444228.430.000.000.00228.43
Davis, Dylan,15556588.960.000.000.00588.96
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Garcia, Rachel, L,129864823.010.000.000.004823.01
James, Emma,127812329.980.000.000.002329.98
Cooper, Brooke,195361120.490.000.000.001120.49
Shan, Christian, L,2308439.980.000.000.0039.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Collins, Charles, B,29041628.450.000.000.00628.45
Deng, Wayne,2145336.960.000.000.0036.96
Richardson, Erin, R,1633188.850.000.000.0088.85
Peterson, Mason, A,185701174.480.000.000.001174.48
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
James, Morgan, E,2324539.980.000.000.0039.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Nelson, James, L,245257.280.000.000.007.28
Diaz, Faith, M,2236356.970.000.000.0056.97
Luo, Donna, E,248054.990.000.000.004.99
Roberts, Hunter,282607.280.000.000.007.28
Gray, Mariah,222787.280.000.000.007.28
Adams, Katherine, M,235184.990.000.000.004.99
Ross, Aaron, N,118882376.960.000.000.002376.96
Anderson, Tyler, E,131481137.430.000.000.001137.43
Smith, Hannah, J,2526554.980.000.000.0054.98
Long, Elizabeth, F,127822400.950.000.000.002400.95
Simmons, David, E,120172339.970.000.000.002339.97
Peterson, Melissa, S,249954.990.000.000.004.99
Watson, Erin, B,227724.990.000.000.004.99
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Lewis, Christopher,1875586.960.000.000.0086.96
Hughes, Antonio, P,15913712.270.000.000.00712.27
Clark, Destiny, L,28600119.980.000.000.00119.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Ross, David, M,171431763.970.000.000.001763.97
Chandra, Allen,2932753.990.000.000.0053.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
_SUM1806517.5025543.71493581.21254851.631032540.95

Generated 2025-12-23 18:14:29.189 UTC