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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Cannata, Gabrielle, C,217254.990.000.000.004.99
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Brown, Christian,227554.990.000.000.004.99
Patterson, Austin, O,270247.280.000.000.007.28
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Hall, Jason, A,29351119.980.000.000.00119.98
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Ross, Seth, M,184332329.980.000.000.002329.98
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
Allen, Madeline,2924068.970.000.000.0068.97
Long, Rachel,2828339.980.000.000.0039.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
James, Julia,2497567.930.000.000.0067.93
Ramirez, Emma,29072128.970.000.000.00128.97
Williams, Joshua,260514.990.000.000.004.99
Torres, Abigail,253674.990.000.000.004.99
Roberts, Seth, H,11510258.150.000.000.00258.15
Simmons, Dylan,16133107.850.000.0038.8868.97
Collins, Xavier, C,16646250.910.000.000.00250.91
Price, Nicole, N,15815141.830.000.000.00141.83
Russell, Katherine,2877169.990.000.000.0069.99
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
Thomas, Victoria, A,15536249.530.000.000.00249.53
Torres, Pedro, E,16958168.020.000.000.00168.02
Flores, Zachary, H,233765314.250.003578.270.001735.98
Long, Natalie,14363192.340.000.000.00192.34
Mitchell, Lucas, C,198294533.450.003374.990.001158.46
Martin, Lucas, L,221144183.230.003578.270.00604.96
Jones, Nicole,14504112.270.000.000.00112.27
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Smith, John,198555709.960.003399.990.002309.97
Walker, Hunter,271007.280.000.000.007.28
Anderson, Lucas,2926639.980.000.000.0039.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Howard, Morgan, T,229713578.270.003578.270.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Flores, Logan, K,14631848.470.000.000.00848.47
Miller, Chloe, V,228936056.510.003578.270.002478.24
Harris, Emily, P,1986298.480.000.000.0098.48
Thomas, Alexandra, C,231724809.390.003578.270.001231.12
Ward, Angela, M,2775669.990.000.000.0069.99
Washington, Lauren, R,229985329.250.003578.271750.980.00
Young, Julia, J,274144.990.000.000.004.99
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Torres, Haley, W,232834828.110.003578.270.001249.84
Smith, Katherine, J,13197105.190.000.000.00105.19
Ware, Dennis, L,237254828.110.003578.270.001249.84
White, Cameron,238304802.110.003578.270.001223.84
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Martin, Brianna, M,235834829.390.003578.270.001251.12
Patterson, Maria, G,1333094.950.000.000.0094.95
Sharma, Samuel,27725119.980.000.000.00119.98
Richardson, Melissa, E,111322371.940.000.000.002371.94
Henderson, Caroline,2008256.970.000.000.0056.97
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Turner, Wyatt,200345769.960.003399.990.002369.97
Long, Morgan, H,213522625.390.000.002071.42553.97
Bennett, Seth,244933578.270.003578.270.000.00
Allen, Aaron, A,200753399.990.003399.990.000.00
Brooks, Lucas, S,16089342.030.000.000.00342.03
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Sanchez, Mariah, R,1922066.650.000.000.0066.65
Prasad, Molly,243924329.610.003578.270.00751.34
Murphy, Juan, T,246463578.270.003578.270.000.00
Moore, Andrew, A,13944150.130.000.0036.27113.86
Hughes, Justin, M,181222439.990.000.000.002439.99
Green, Sophia, E,249772181.560.002181.560.000.00
Gray, Brianna,249603008.820.002443.350.00565.47
Hughes, Julia,250612443.350.002443.350.000.00
Chavez, Kara, P,13285214.350.000.0012.94201.41
Chen, James, D,11641303.200.000.0021.49281.71
Thomas, Emily,2180339.980.000.000.0039.98
Price, Stephanie,258922443.350.000.002443.350.00
Cook, Bryce,2864069.990.000.000.0069.99
Gomez, Renee, L,253712181.560.000.002181.560.00
Price, Jocelyn, D,258752443.350.000.002443.350.00
Campbell, Isabella, C,203503226.900.000.002071.421155.48
Sanders, Alexandra,259112181.560.000.002181.560.00
Hayes, Arianna,259912845.520.000.002181.56663.96
Cook, Megan, J,2029956.970.000.000.0056.97
Deng, Damien, A,16873578.460.000.000.00578.46
Russell, Megan,16220562.960.000.000.00562.96
Washington, Miranda,152014793.020.000.000.004793.02
Rogers, Shelby,11712127.800.000.0032.6095.20
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Washington, Robert, J,14906143.950.000.000.00143.95
King, Aaron, L,117394758.030.000.002359.982398.05
Isla, Julian, A,13732108.960.000.004.99103.97
Thomas, Samantha,2169093.970.000.000.0093.97
Phillips, James, G,16846180.950.000.000.00180.95
Sandberg, Nicole, M,12077144.690.000.0089.4755.22
Carter, Madeline, A,2752269.990.000.000.0069.99
Hughes, Eduardo,15564188.520.000.000.00188.52
Butler, Morgan, E,2050068.490.000.000.0068.49
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
Walker, Jasmine,134604693.040.000.000.004693.04
Butler, Isabel,16241126.960.000.000.00126.96
Smith, Alexandra,2829261.960.000.000.0061.96
Cox, Katelyn, B,2174230.970.000.000.0030.97
Hall, Amber,20106131.950.000.000.00131.95
Johnson, Anthony, D,270224.990.000.000.004.99
Brown, Anthony, J,19399151.430.000.000.00151.43
Long, Chloe,167841735.980.000.000.001735.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Sanchez, Faith,270494.990.000.000.004.99
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Cook, Seth,2301064.470.000.000.0064.47
Garcia, Jonathan,1888386.960.000.000.0086.96
Kumar, Zachary,254334.990.000.000.004.99
Simmons, Jose,2464739.980.000.000.0039.98
Harrison, Trevor, A,18055143.910.000.000.00143.91
Hill, Sydney,264821000.440.000.001000.440.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Perry, Marcus, L,206563245.900.000.002071.421174.48
Stewart, Andrea, M,27252782.990.000.00782.990.00
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Carter, Bailey,213322616.860.000.002049.10567.76
Campbell, Adam, A,214002688.890.000.002071.42617.47
Ward, Juan, H,215952649.560.000.002049.10600.46
Bell, Danielle,140414765.020.000.000.004765.02
Lewis, Brandon, A,2903769.990.000.000.0069.99
Griffin, Jack, L,1768632.280.000.000.0032.28
Shan, Logan,1867760.960.000.0029.9930.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
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
Russell, Elijah, M,118354772.300.000.002319.262453.04
Lal, Caleb, R,1586874.460.000.000.0074.46
Thomas, Richard,27557782.990.000.00782.990.00
Thomas, William, A,216142589.090.000.002049.10539.99
Washington, Alexia,27613782.990.000.00782.990.00
Davis, Richard, R,15549574.980.000.00574.980.00
Jackson, Edward,290422420.340.000.002420.340.00
Davis, Ethan,136604750.010.000.000.004750.01
Suri, Carolyn, S,12972175.710.000.000.00175.71
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
Allen, Luke,113162349.980.000.002349.980.00
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Thomas, Jessica,1684894.480.000.0094.480.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Green, Chloe, J,1465892.820.000.000.0092.82
Gonzales, Kayla,214947.280.000.000.007.28
Coleman, Miguel, D,2740069.990.000.0069.990.00
Hall, Natalie, A,230704.990.000.004.990.00
Evans, Maria,22544127.280.000.00127.280.00
Alexander, Jason,2932849.990.000.000.0049.99
Parker, Caleb, A,2631813.980.000.000.0013.98
Rubio, Ruben, D,1887186.960.000.0056.9729.99
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Hall, Jose, J,17601225.420.000.000.00225.42
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
Flores, Devin, A,15559172.040.000.000.00172.04
Peterson, Steven, L,234497.280.000.000.007.28
Prasad, Summer, M,2214339.980.000.000.0039.98
Gray, Sara,292472447.050.000.000.002447.05
Anderson, David, A,2209761.960.000.000.0061.96
Bradley, Jocelyn,230227.280.000.000.007.28
Carter, Isaac,137191129.480.000.000.001129.48
King, Gabrielle,263504.990.000.000.004.99
Martin, Noah, A,1765775.970.000.000.0075.97
Perez, Savannah, J,17036176.950.000.000.00176.95
Taylor, Tyler, A,12032614.960.000.000.00614.96
Scott, Eric,282484.990.000.000.004.99
Turner, James, E,16841126.960.000.000.00126.96
Evans, Jordan,2920939.980.000.000.0039.98
Hill, Eric, G,2525667.930.000.000.0067.93
Diaz, Kaitlyn, B,292304.990.000.000.004.99
Adams, Kyle, E,1881269.990.000.000.0069.99
Harris, Samuel, M,2477159.980.000.000.0059.98
Foster, Jessica,2606951.460.000.000.0051.46
Roberts, Wyatt,15900699.970.000.000.00699.97
Peterson, Mason, A,185701174.480.000.000.001174.48
Thompson, Blake,18390141.960.000.000.00141.96
Griffin, Isabelle,249864.990.000.000.004.99
Morris, Seth,189592341.460.000.000.002341.46
Alexander, Thomas,207607.280.000.000.007.28
Gray, Mariah,222787.280.000.000.007.28
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
Torres, Victoria,17551160.920.000.000.00160.92
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
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Simmons, David, E,120172339.970.000.000.002339.97
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Peterson, Melissa, S,249954.990.000.000.004.99
Reed, Isaac, D,260747.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
White, Greg, C,174032322.280.000.000.002322.28
Russell, Chloe, M,12763589.960.000.000.00589.96
Evans, Alexandra,2432268.490.000.000.0068.49
Griffin, Marcus,2075634.560.000.000.0034.56
Watson, Devin, A,18875114.950.000.000.00114.95
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
Reed, Gabriella, A,2743778.980.000.000.0078.98
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
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
Chen, Ethan,2054756.970.000.000.0056.97
Richardson, Brian,2860878.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Clark, Joseph, D,153954780.020.000.000.004780.02
Stewart, Lucas, J,2934198.970.000.000.0098.97
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Griffin, Melissa, L,287807.950.000.000.007.95
Gray, Seth, M,2008785.480.000.000.0085.48
Bennett, Brittany, J,2233239.980.000.000.0039.98
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Long, Sarah,173721729.970.000.000.001729.97
Young, Courtney,176222374.980.000.000.002374.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
Blue, Melanie, L,178611749.960.000.000.001749.96
_SUM1806517.5025543.71493581.21255540.501031852.08

Generated 2025-12-22 03:10:20.410 UTC