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

319 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Clark, Miguel, D,169872414.990.000.000.002414.99
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Mohamed, Samantha, A,292772419.060.000.000.002419.06
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Phillips, Jack, R,259952443.350.000.002443.350.00
Rogers, Bryce,174022304.980.000.000.002304.98
White, Christopher, R,260492181.560.000.002181.560.00
Edwards, Hunter,2422067.930.000.000.0067.93
Thompson, Devin,207084406.400.000.002071.422334.98
Butler, Benjamin, C,189722369.970.000.000.002369.97
Phillips, Kaylee,211384371.380.000.002049.102322.28
Morris, Seth,189592341.460.000.000.002341.46
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Torres, Mackenzie,28153570.470.000.000.00570.47
Foster, Deb,215012661.400.000.002661.400.00
Alexander, Thomas,207607.280.000.000.007.28
Coleman, Ashley,27297782.990.000.00782.990.00
Thompson, Xavier, R,15761192.410.000.000.00192.41
Simmons, Dakota, T,14110819.460.000.000.00819.46
Henderson, Luke,19200109.240.000.000.00109.24
Foster, Trevor, J,2896469.990.000.000.0069.99
Yang, Aaron, C,2519654.980.000.000.0054.98
Cooper, Grace, C,1601294.260.000.000.0094.26
Bryant, Dakota, L,176132401.950.000.000.002401.95
Cox, Katelyn, B,2174230.970.000.000.0030.97
Allen, Mason,176252431.950.000.000.002431.95
Martin, Brandon, S,2169139.980.000.000.0039.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Rivera, Hailey, R,2079239.980.000.000.0039.98
Li, Kevin, S,2518813.980.000.000.0013.98
Evans, Gabriel,2348789.970.000.000.0089.97
Long, Chloe,167841735.980.000.000.001735.98
Moore, Seth,138512331.950.000.000.002331.95
Sanchez, Faith,270494.990.000.000.004.99
Hayes, Jason,261764.990.000.000.004.99
Martinez, Jonathan,1330366.250.000.000.0066.25
Stewart, Makayla,16649115.940.000.000.00115.94
Ward, Stephanie, A,27429782.990.000.00782.990.00
Robinson, Zachary, L,137092332.280.000.000.002332.28
Bell, Julia,216522646.060.000.002646.060.00
Miller, Andrew, C,271104.990.000.000.004.99
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Johnson, Andrew, F,262942443.350.000.002443.350.00
Coleman, Dylan,27403132.970.000.000.00132.97
Winston, Ethan, R,216222612.060.000.002049.10562.96
Mehta, Carmen, C,2743694.480.000.000.0094.48
Moore, Fernando,265821000.440.000.001000.440.00
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Patterson, Grace, M,27560782.990.000.00782.990.00
Robinson, Madison, W,183772394.970.000.000.002394.97
Thomas, Thomas,216292624.080.000.002049.10574.98
Perez, Barry, M,2728269.990.000.000.0069.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Yuan, Brendan, S,247444.990.000.000.004.99
King, Jordan, C,110202316.970.000.002316.970.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
Chavez, Kara, P,13285214.350.000.0012.94201.41
Peterson, Xavier, R,2645639.980.000.000.0039.98
Diaz, Thomas, O,16020595.960.000.000.00595.96
Li, Eugene, A,15283865.950.000.000.00865.95
Sanchez, Martin, E,216317.280.000.000.007.28
Ross, Seth, M,184332329.980.000.000.002329.98
Lewis, Brandon, A,2903769.990.000.000.0069.99
Rogers, Olivia,12020804.470.000.000.00804.47
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Ward, Cole,214907.280.000.000.007.28
Griffin, Jack, L,1768632.280.000.000.0032.28
Collins, Amanda,2078339.980.000.000.0039.98
Bailey, Lauren,15864103.550.000.000.00103.55
White, Emma, N,16090604.960.000.000.00604.96
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Srini, Evelyn,16855150.950.000.000.00150.95
Wilson, Daniel, K,142814746.300.000.000.004746.30
James, Julia,2497567.930.000.000.0067.93
Liu, Arturo,13222150.410.000.000.00150.41
Coleman, Samuel, N,17450123.980.000.000.00123.98
Shan, Logan,1867760.960.000.0029.9930.97
Rivera, Sara,187852350.960.000.000.002350.96
Alexander, Ryan, J,14078839.480.000.00839.480.00
Gonzales, Jordan,2368113.980.000.000.0013.98
Allen, Jack, M,291372419.060.000.002419.060.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Martinez, Dominique,287888.990.000.008.990.00
Foster, Isabelle,2637739.980.000.000.0039.98
Thomas, Seth,14567161.280.000.0096.0765.21
Foster, Abigail,1982346.470.000.000.0046.47
Price, Lauren, J,14079184.740.000.0037.29147.45
Collins, Jonathan,16849119.980.000.000.00119.98
Diaz, Jason,17374206.630.000.0089.46117.17
Mitchell, Evan, R,247314.990.000.000.004.99
Davis, Nicholas,1320173.160.000.000.0073.16
Li, Rafael, M,217527.280.000.000.007.28
Flores, Logan, K,14631848.470.000.000.00848.47
Martin, Kellie, R,28195574.980.000.000.00574.98
Young, Julia, J,274144.990.000.000.004.99
Thomas, Dalton,230097.280.000.000.007.28
Allen, Amanda,2235339.980.000.000.0039.98
Lal, Jack, R,185251735.980.000.000.001735.98
Thompson, Tyler,2750269.990.000.0069.990.00
Ward, Destiny,16128539.990.000.000.00539.99
Nelson, Jordan, H,201304.990.000.004.990.00
Perez, Jonathan, R,2345512.940.000.000.0012.94
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Ward, Eduardo, I,139162354.980.000.000.002354.98
Powell, Jack, J,1841156.960.000.000.0056.96
Jones, Alexander, I,2002180.960.000.000.0080.96
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Kelly, Bailey, R,28284563.770.000.000.00563.77
Cook, Bryce,2864069.990.000.000.0069.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Long, Rachel,2828339.980.000.000.0039.98
Clark, Emily, R,120862294.990.000.000.002294.99
Ramirez, Emma,29072128.970.000.000.00128.97
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Campbell, Timothy,2584513.980.000.000.0013.98
Evans, Maria,22544127.280.000.00127.280.00
Russell, Katherine,2877169.990.000.000.0069.99
Moore, Anthony, M,2473039.980.000.000.0039.98
Campbell, Natalie, L,115122319.990.000.000.002319.99
Russell, Megan,16220562.960.000.000.00562.96
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Martin, Jill, C,11824181.030.000.000.00181.03
Alexander, Jordan,2141259.980.000.0059.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Foster, Jessica,2606951.460.000.000.0051.46
Alexander, Jason,2932849.990.000.000.0049.99
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
Peterson, Mason, A,185701174.480.000.000.001174.48
Wilson, Madison, H,1982821.980.000.000.0021.98
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Morgan, Juan, C,1882191.970.000.000.0091.97
Stewart, Allison, R,18826166.430.000.000.00166.43
Moore, Chloe, L,2626913.980.000.000.0013.98
Lewis, Jeremiah,1437187.260.000.000.0087.26
Gray, Mariah,222787.280.000.000.007.28
Hayes, Gavin, A,194001179.470.000.000.001179.47
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Griffin, Isabelle,249864.990.000.000.004.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Hughes, Anna,197052341.970.000.000.002341.97
Robinson, Julia,28121119.980.000.000.00119.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Nelson, Luis,234884.990.000.000.004.99
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hughes, Destiny, P,28027119.980.000.000.00119.98
Anderson, Isabella,137432349.980.000.000.002349.98
Baker, Mason, A,132702394.950.000.000.002394.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Chen, Jonathan, G,13096200.690.000.000.00200.69
Perry, Brandon,22095141.980.000.000.00141.98
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Richardson, Brian,2860878.980.000.000.0078.98
Davis, Jonathan,2925913.980.000.000.0013.98
Campbell, Lucas,2932953.990.000.000.0053.99
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Young, Jenna, W,163652490.180.000.000.002490.18
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Perez, Katherine, J,2207924.270.000.000.0024.27
Gray, Marcus, T,183892401.450.000.000.002401.45
Rowe, Todd,14586233.940.000.000.00233.94
Martinez, Carol, D,17656578.460.000.000.00578.46
Coleman, Ian,2127639.980.000.000.0039.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Jones, Samantha,1831721.980.000.000.0021.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Alexander, Sarah,1941129.990.000.000.0029.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Morgan, Isabella, L,28602144.470.000.000.00144.47
Hayes, Dalton, C,188822322.280.000.000.002322.28
Robinson, Ian, D,138522294.990.000.000.002294.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Reed, Megan, A,181181750.980.000.000.001750.98
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Stewart, Gabriella,2803469.990.000.000.0069.99
Hall, Wyatt,2382713.980.000.000.0013.98
Bell, Chase,180911750.980.000.000.001750.98
Garcia, Kayla, L,2130881.460.000.000.0081.46
Brown, Christian,227554.990.000.000.004.99
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Butler, Jackson, J,183241735.980.000.000.001735.98
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Griffin, James,28189567.760.000.000.00567.76
Gonzales, Gavin,2448813.980.000.000.0013.98
Williams, Joshua,260514.990.000.000.004.99
Alexander, Paige, W,1860459.250.000.000.0059.25
Brooks, Lucas, S,16089342.030.000.000.00342.03
Collins, Nathan, F,197041143.460.000.000.001143.46
Coleman, Jose, S,253494.990.000.000.004.99
Adams, Jennifer,153624745.020.000.000.004745.02
Wright, Katelyn, A,14502122.260.000.000.00122.26
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Rivera, Allison, M,13751224.910.000.000.00224.91
Smith, Chloe,17619163.920.000.000.00163.92
Foster, Jose, C,2878534.990.000.000.0034.99
Washington, Robert, J,14906143.950.000.000.00143.95
Jones, Charles,22882101.450.000.000.00101.45
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Robinson, Lauren,2719668.490.000.000.0068.49
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Powell, Katherine, C,14574177.600.000.000.00177.60
Kennedy, Bridget,2202639.980.000.000.0039.98
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Cox, Sara, P,2775869.990.000.000.0069.99
Van, Bobby,27757132.970.000.000.00132.97
Barnes, Kayla,2425639.980.000.000.0039.98
Smith, Noah,13175166.920.000.000.00166.92
Foster, Caleb,27112114.460.000.000.00114.46
Blue, Paige,2170313.980.000.000.0013.98
Evans, Alexandra,2432268.490.000.000.0068.49
Long, Gavin,13762186.030.000.000.00186.03
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Foster, Paige,2742894.480.000.000.0094.48
Brown, Julia,18065155.470.000.000.00155.47
Roberts, Rebecca,2800094.480.000.000.0094.48
Thomas, Zachary, D,28045119.980.000.000.00119.98
Sharma, Thomas, A,18637121.940.000.000.00121.94
Jones, Kayla, C,1854194.260.000.000.0094.26
Reed, Gabriella, A,2743778.980.000.000.0078.98
Sanders, Lucas, W,268024.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Brooks, Steven, C,14877889.470.000.000.00889.47
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Sanders, Sean,14341175.150.000.000.00175.15
Roberts, Amanda,171752334.980.000.000.002334.98
Moreno, Renee, C,12936265.220.000.000.00265.22
Taylor, Marcus, A,18944146.940.000.000.00146.94
Bradley, Rachel,158504813.040.000.000.004813.04
Miller, Jill,129142329.980.000.000.002329.98
Rodriguez, Taylor,1607166.960.000.000.0066.96
Sanchez, Stephanie,1786756.970.000.000.0056.97
Brooks, Evan,2340139.980.000.000.0039.98
Long, Sarah,173721729.970.000.000.001729.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Rogers, Jared, J,12166162.220.000.000.00162.22
Williams, Ian, M,175581750.470.000.000.001750.47
Foster, Aaron,155664912.470.000.000.004912.47
Chandra, Allen,2932753.990.000.000.0053.99
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Hall, Grace, A,201894.990.000.000.004.99
Richardson, Lauren, C,14867839.480.000.000.00839.48
Lopez, Isaiah,18968151.430.000.000.00151.43
Morris, Alyssa,28072548.980.000.000.00548.98
Harris, Destiny, M,137102341.460.000.000.002341.46
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alexander, Julian,132172351.960.000.000.002351.96
Lee, Kayla, M,2078115.230.000.000.0015.23
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Sanders, Isaiah,2587339.980.000.000.0039.98
Simmons, Brittany,2923139.980.000.000.0039.98
Jai, Logan, H,12031769.490.000.000.00769.49
Bailey, Maria, C,1915034.980.000.000.0034.98
Baker, Gabriella,174041709.980.000.000.001709.98
Carter, Jose, H,12532235.720.000.000.00235.72
Martin, Tyler, L,2772469.990.000.000.0069.99
Edwards, Madeline,2077146.470.000.000.0046.47
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Russell, Nicole, M,182372318.960.000.000.002318.96
Stewart, Olivia, B,1874923.780.000.000.0023.78
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Stewart, Alexandria,174761700.990.000.000.001700.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Brown, Morgan,2919778.980.000.000.0078.98
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Alexander, Caroline,176541759.970.000.000.001759.97
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
James, Adrian, C,253404.990.000.000.004.99
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Griffin, Miguel,2146476.970.000.000.0076.97
Thompson, Lucas, O,212774.990.000.000.004.99
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Gonzales, Emily, P,21777180.980.000.000.00180.98
Davis, Justin,2807412.940.000.000.0012.94
Adams, Julia, N,2607359.980.000.000.0059.98
Edwards, Hailey,242584.990.000.000.004.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Diaz, Trevor, B,2051954.960.000.000.0054.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Howard, Erin, L,183621725.210.000.000.001725.21
Moore, Ian, L,2463939.980.000.000.0039.98
Ma, Tiffany,2157739.980.000.000.0039.98
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Rodriguez, Natalie,2077330.970.000.000.0030.97
Jones, Alexandra, B,2020245.950.000.000.0045.95
Sara, Ivan, L,2509067.930.000.000.0067.93
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Thomas, Jeremiah,183721760.470.000.000.001760.47
Walker, Jacob, N,29027574.980.000.000.00574.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Blanco, Armando, F,139182397.950.000.000.002397.95
Alexander, Gavin, K,2932249.990.000.000.0049.99
Hughes, Austin, P,183681754.980.000.000.001754.98
Morris, Haley, A,2354848.970.000.000.0048.97
Li, Brandon,2933973.960.000.000.0073.96
Collins, Charles, B,29041628.450.000.000.00628.45
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Katherine, M,235184.990.000.000.004.99
_SUM1806517.5025543.71493581.21255086.351032306.23

Generated 2025-12-22 05:51:28.707 UTC