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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Howard, Isaiah,259813018.330.002443.350.00574.98
Young, Savannah,259712749.320.002181.560.00567.76
Gutierrez, Jerome,127832420.460.000.000.002420.46
Scott, Gabrielle,270614.990.000.000.004.99
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Morgan, Angela,24665109.970.000.000.00109.97
James, Christina,17409219.920.000.000.00219.92
Martinez, Matthew, L,16009170.450.000.000.00170.45
Reed, Mariah,263731565.910.000.001000.44565.47
Richardson, Olivia,204683169.590.000.002049.101120.49
Fernandez, Ruth,205463246.550.000.002049.101197.45
Kumar, Austin,204834400.060.000.002049.102350.96
Thomas, Isabella, M,27265782.990.000.00782.990.00
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Anderson, Ashley,206803219.580.000.002049.101170.48
Phillips, Jack, R,259952443.350.000.002443.350.00
Butler, Ana,260403018.330.000.002443.35574.98
Jackson, Hannah, G,131432404.970.000.000.002404.97
Yang, Aaron, C,2519654.980.000.000.0054.98
James, Timothy,213312670.890.000.002670.890.00
Nelson, Luis,234884.990.000.000.004.99
Davis, Emily,27267782.990.000.00782.990.00
Roberts, Amber, W,215822638.060.000.002049.10588.96
Carter, Bailey,213322616.860.000.002616.860.00
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Hughes, Eduardo,15564188.520.000.000.00188.52
Patterson, Alexis,213484392.020.000.002049.102342.92
Simmons, Haley, T,262022749.320.000.002181.56567.76
Jones, Zachary, J,27285782.990.000.00782.990.00
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Adams, Connor,214232888.560.000.002049.10839.46
Sanchez, Faith,270494.990.000.000.004.99
Lee, Ethan, J,223597.280.000.000.007.28
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Hill, Carlos,12919257.880.000.00158.9398.95
Kelly, Bryan,213492989.380.000.002989.380.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Martinez, Jonathan,1330366.250.000.000.0066.25
Ward, Juan, H,215952649.560.000.002049.10600.46
Bradley, Alexandria,176911779.470.000.000.001779.47
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Chen, Jonathan, G,13096200.690.000.000.00200.69
Perry, Brandon,22095141.980.000.000.00141.98
Lee, Don,188392384.970.000.000.002384.97
Smith, Noah,13175166.920.000.000.00166.92
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Moore, Seth,138512331.950.000.000.002331.95
Lewis, Ryan, A,203124.990.000.000.004.99
Griffin, Jack, L,1768632.280.000.000.0032.28
Brown, Fernando,1900191.950.000.0069.9721.98
Walker, Brandon, J,159164793.270.000.000.004793.27
Thomas, Logan, A,14091251.200.000.0053.99197.21
Hughes, Jasmine,276284.990.000.000.004.99
Hill, Haley, J,161033142.320.000.00792.342349.98
Henderson, Logan, C,2236656.970.000.000.0056.97
Garcia, Isabella,18382204.940.000.000.00204.94
Bell, Julia,216522646.060.000.002646.060.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Russell, Jessica,265721000.440.000.001000.440.00
Thomas, William, A,216142589.090.000.002049.10539.99
Moore, Fernando,265821000.440.000.001000.440.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Bryant, Zachary,216552648.070.000.002648.070.00
Davis, Richard, R,15549574.980.000.00574.980.00
Jackson, Edward,290422420.340.000.002420.340.00
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Gonzales, Kayla,214947.280.000.000.007.28
Patterson, Jeremy,130272319.260.000.000.002319.26
Cooper, Andrea,2932378.980.000.000.0078.98
Alexander, Ryan, J,14078839.480.000.00839.480.00
Alexander, Jason,2932849.990.000.000.0049.99
Price, Marissa,15826160.740.000.00120.4840.26
Thomas, David,168363193.790.000.000.003193.79
Garcia, Christian, J,164913106.330.000.00751.342354.99
Flores, Caleb, S,12165280.640.000.00243.3737.27
Prasad, Donald,15413318.920.000.00123.98194.94
Martin, Madison, C,2049271.970.000.0071.970.00
Coleman, Luke, A,11723152.550.000.0069.9882.57
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Hall, Jan, M,11740334.120.000.00235.1598.97
Peterson, Christina,2897694.480.000.000.0094.48
Brown, Morgan,2919778.980.000.000.0078.98
Barnes, Emily, G,15996564.990.000.000.00564.99
Patterson, Taylor,12147271.450.000.000.00271.45
Foster, Antonio,12795108.540.000.0066.2642.28
Jai, Jose,12944164.210.000.000.00164.21
Watson, Marcus,2271585.480.000.000.0085.48
Lee, Alexander, S,18356149.910.000.000.00149.91
Phillips, Devin,18759112.060.000.000.00112.06
Cox, Arianna, D,1892789.250.000.000.0089.25
White, Emily, M,159174679.060.000.000.004679.06
Long, Sydney,279217.280.000.000.007.28
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Hall, Kaylee, E,1975137.270.000.000.0037.27
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Lal, Caleb, R,1586874.460.000.000.0074.46
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Flores, Kevin,15878225.920.000.0069.97155.95
Mehta, Carmen, C,2743694.480.000.000.0094.48
Anand, Brendan, L,1984721.980.000.000.0021.98
Robinson, Dylan, L,1472481.530.000.000.0081.53
Russell, Samuel, V,11652310.930.000.000.00310.93
Foster, Carson, L,16959135.350.000.0085.4849.87
Richardson, Evan, J,15488165.300.000.000.00165.30
Butler, Dalton, A,133454759.510.000.000.004759.51
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Wilson, Eduardo,15323804.470.000.000.00804.47
Smith, Chloe,17619163.920.000.000.00163.92
James, Maria,1624391.970.000.0069.9921.98
Bradley, Jocelyn,230227.280.000.000.007.28
Thomas, Matthew, K,13239185.700.000.000.00185.70
Green, Eric,2738069.990.000.000.0069.99
Price, Devin, M,18758158.510.000.0073.5584.96
Davis, Austin, E,133664749.040.000.000.004749.04
Lal, Kyle,17360122.180.000.000.00122.18
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Jones, Samantha,1831721.980.000.000.0021.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Collins, Amanda,2078339.980.000.000.0039.98
Blue, Melanie, L,178611749.960.000.000.001749.96
Murphy, Maria,160113657.260.000.000.003657.26
Coleman, Miguel, D,2740069.990.000.0069.990.00
Russell, Ian, T,2474613.980.000.0013.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Evans, Maria,22544127.280.000.00127.280.00
Ross, Jose,2744178.980.000.0078.980.00
Washington, Hannah, A,291307.280.000.007.280.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Ward, Natalie, J,132412325.960.000.000.002325.96
Patterson, Abigail, H,144784795.010.000.000.004795.01
Lewis, Morgan,17410168.740.000.000.00168.74
Roberts, Rebecca,2800094.480.000.000.0094.48
Hernandez, Jamie,27283119.980.000.00119.980.00
Ramirez, Brian, M,116182369.960.000.002369.960.00
Chen, Luis, G,2125294.450.000.0094.450.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Miguel,1975077.250.000.000.0077.25
Jenkins, Austin, D,15748296.910.000.000.00296.91
Howard, Brianna, D,246304.990.000.000.004.99
Turner, James, E,16841126.960.000.0069.9956.97
Bryant, Jackson, J,2533239.980.000.000.0039.98
Perez, Savannah, J,17036176.950.000.0056.97119.98
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Jackson, Victoria,270194.990.000.000.004.99
Harris, Joshua, L,2028095.940.000.0030.9764.97
Rogers, Andrea, L,14328308.660.000.00112.95195.71
James, Bryce,13466133.450.000.000.00133.45
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alvarez, Melody,2507068.490.000.000.0068.49
Rogers, Bryce,174022304.980.000.000.002304.98
Srini, Ruben,18078200.940.000.000.00200.94
Long, Gavin,13762186.030.000.000.00186.03
Edwards, Hunter,2422067.930.000.000.0067.93
Allen, Mason,176252431.950.000.000.002431.95
Coleman, Samuel, N,17450123.980.000.000.00123.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Adams, Julia, N,2607359.980.000.000.0059.98
Edwards, Hailey,242584.990.000.000.004.99
Baker, Mason, A,132702394.950.000.000.002394.95
Gray, Cindy, A,13198114.950.000.0099.9714.98
Martin, Katherine, J,2027339.980.000.000.0039.98
Rivera, Sara,187852350.960.000.000.002350.96
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
Malhotra, Brenda,133912405.470.000.000.002405.47
Miller, Victoria,15816188.020.000.0081.46106.56
Watson, Victoria,16125588.960.000.000.00588.96
Bradley, Evan,18506101.940.000.000.00101.94
Foster, Emma,15468436.350.000.00159.99276.36
Davis, Jonathan,2925913.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Martin, Noah, A,1765775.970.000.0075.970.00
Ramos, Derrick,18449100.940.000.0030.9769.97
Ross, Miranda,145984839.000.000.000.004839.00
Bailey, Olivia,238924.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
Lee, James, J,2881769.990.000.0069.990.00
Perry, Samuel,18811100.960.000.00100.960.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Yuan, Brendan, S,247444.990.000.000.004.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Russell, Gail, L,212634.990.000.000.004.99
Gonzalez, Morgan,130651700.990.000.000.001700.99
Perry, Eric,18314115.730.000.0056.9758.76
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Rodriguez, Julia, A,264884.990.000.004.990.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Evans, Jordan,2920939.980.000.0039.980.00
Rogers, Olivia,12020804.470.000.000.00804.47
Hughes, Luis,130841798.960.000.000.001798.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Hill, Eric, G,2525667.930.000.0067.930.00
Li, Jordan,17026261.390.000.00261.390.00
Peterson, Isabella,2808039.980.000.0039.980.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Gray, Seth, M,2008785.480.000.000.0085.48
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Morgan, Isabella, L,28602144.470.000.000.00144.47
Hall, Wyatt,2382713.980.000.000.0013.98
Flores, Luke, L,247337.280.000.000.007.28
Nath, Carl, H,29001624.970.000.000.00624.97
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Garcia, Kayla, L,2130881.460.000.000.0081.46
Richardson, Charles, I,121144719.020.000.002325.962393.06
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Davis, Dylan,15556588.960.000.00588.960.00
Foster, Jessica,2606951.460.000.0051.460.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
Campbell, Angel, D,195461174.480.000.000.001174.48
Hayes, Gavin, A,194001179.470.000.000.001179.47
Clark, Zachary, J,2389358.980.000.000.0058.98
Powell, Ian,2608564.470.000.000.0064.47
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
Flores, Julian,158464943.320.000.000.004943.32
Walker, Jacob, N,29027574.980.000.000.00574.98
Nelson, James, L,245257.280.000.007.280.00
Raje, Mindy, A,16083561.970.000.000.00561.97
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Howard, Danielle,28357133.490.000.000.00133.49
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Baker, Robert, A,273007.280.000.007.280.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Kumar, Cameron, S,185711120.490.000.001120.490.00
Smith, Eduardo,2069139.980.000.0039.980.00
Van, Bobby,27757132.970.000.00132.970.00
Harris, Seth, M,161402528.330.000.002528.330.00
Gray, Jared, A,264494.990.000.000.004.99
Hughes, Antonio, P,15913712.270.000.000.00712.27
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Clark, Destiny, L,28600119.980.000.000.00119.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Gabriel, S,195271219.450.000.000.001219.45
Kelly, Erin, D,2351364.470.000.000.0064.47
Adams, Katherine, M,235184.990.000.000.004.99
Torres, Abigail,253674.990.000.000.004.99
Washington, Emma,191231170.480.000.000.001170.48
Edwards, Logan,250024.990.000.000.004.99
Miller, Jill,129142329.980.000.000.002329.98
Nelson, Katherine,2802178.980.000.000.0078.98
Harris, Anthony,2144721.980.000.000.0021.98
Wang, Zachary,2214489.970.000.000.0089.97
_SUM1806517.5065197.22486223.00323791.51931305.77

Generated 2025-11-05 07:44:06.642 UTC