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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Yang, Jordan, K,14458133.950.000.000.00133.95
Young, Julia, J,274144.990.000.000.004.99
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Davis, James,11922275.500.000.0034.98240.52
Hill, Fernando,247634.990.000.000.004.99
Anderson, Emma, A,185801170.480.000.000.001170.48
Smith, Andrew,1472387.570.000.0014.9872.59
Kelly, Haley,15511128.560.000.000.00128.56
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Thomas, Richard,27557782.990.000.00782.990.00
Thomas, William, A,216142589.090.000.002049.10539.99
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Lewis, Isabella,2624267.930.000.000.0067.93
Smith, Lucas, P,1809064.910.000.000.0064.91
Foster, Trevor, J,2896469.990.000.000.0069.99
Henderson, Caroline,2008256.970.000.000.0056.97
Cook, Bryce,2864069.990.000.000.0069.99
Nelson, Sierra,161322459.620.000.002459.620.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Adams, Hailey, M,121544798.530.000.002379.472419.06
Powell, Lauren, E,1966275.970.000.000.0075.97
Green, Gabriella, C,2803569.990.000.000.0069.99
Cooper, Brianna,2592513.980.000.000.0013.98
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
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Washington, Alexis,1978146.260.000.007.2838.98
Taylor, Brianna,17027230.900.000.0051.96178.94
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Diaz, Katherine, P,115262376.960.000.002376.960.00
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Torres, Taylor,16666205.440.000.00123.9881.46
Smith, Tyler, J,2034156.970.000.000.0056.97
Martinez, Jonathan,1330366.250.000.000.0066.25
Alexander, Jordan,2141259.980.000.0059.980.00
Moore, Andrew, A,13944150.130.000.0036.27113.86
Ross, Jose,2744178.980.000.0078.980.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Chen, Luis, G,2125294.450.000.0094.450.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Xu, Louis,2010466.530.000.0066.530.00
Peterson, Steven, L,234497.280.000.007.280.00
Wu, Randy, J,116472365.940.000.002365.940.00
Hall, Charles,234764.990.000.000.004.99
Thompson, Isabella,18756128.410.000.000.00128.41
Brown, Samantha, G,2514739.980.000.000.0039.98
Robinson, William,20103103.480.000.000.00103.48
Cox, Devin, C,134184768.050.000.000.004768.05
Lewis, Ryan, A,203124.990.000.000.004.99
Martin, Noah, A,1765775.970.000.0075.970.00
Ramos, Derrick,18449100.940.000.0030.9769.97
Taylor, Tyler, A,12032614.960.000.00614.960.00
Miller, Victoria,15816188.020.000.0081.46106.56
Johnson, Xavier, R,2325539.980.000.0039.980.00
Russell, Arianna,22728149.930.000.00149.930.00
Perry, Benjamin,291652407.040.000.002407.040.00
Martin, Samuel,15874225.440.000.0069.99155.45
Hill, Eric, G,2525667.930.000.0067.930.00
Bryant, Rachel,220197.280.000.007.280.00
Zhang, Heather,166543056.320.000.00751.342304.98
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Bell, Alex, M,167543118.600.000.00756.332362.27
Hughes, Eduardo,15564188.520.000.000.00188.52
Diaz, Alyssa,139084715.330.000.000.004715.33
Barnes, Jeremy,2144654.980.000.000.0054.98
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Davis, Dylan,15556588.960.000.00588.960.00
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Hughes, Caroline, C,2830278.980.000.0078.980.00
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Williams, Destiny, S,15881564.990.000.00564.990.00
Bryant, Brittany,2254548.970.000.000.0048.97
Miller, Sydney, A,134404818.530.000.000.004818.53
Nelson, James, L,245257.280.000.007.280.00
Moore, Jonathan,2047896.460.000.000.0096.46
Hernandez, Sierra,27393123.980.000.00123.980.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Price, Mariah, C,2074549.480.000.000.0049.48
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Peterson, Christina,2897694.480.000.000.0094.48
Washington, Victoria,235577.280.000.000.007.28
Hall, Fernando,2210090.950.000.000.0090.95
Martinez, Kristina, S,2134529.930.000.000.0029.93
Gray, Mariah,222787.280.000.007.280.00
Scott, Sean, F,2475539.980.000.000.0039.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Wright, Carol, C,12928247.410.000.0033.98213.43
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, David, E,120172339.970.000.002339.970.00
Gomez, Krista,12760273.180.000.0036.27236.91
Phillips, Devin,18759112.060.000.000.00112.06
Watson, Erin, B,227724.990.000.004.990.00
Smith, Nathan,217647.280.000.007.280.00
Van, Bobby,27757132.970.000.00132.970.00
Flores, Brittany,169062359.980.000.000.002359.98
Green, Chloe, J,1465892.820.000.000.0092.82
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Russell, Oscar, A,12140118.170.000.000.00118.17
Henderson, Justin, P,235917.280.000.000.007.28
Clark, Destiny, L,28600119.980.000.000.00119.98
Brooks, Lucas, S,16089342.030.000.000.00342.03
She, Shawn, J,16902141.980.000.000.00141.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
King, Gabrielle,263504.990.000.000.004.99
Williams, Austin,2035432.220.000.000.0032.22
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Watson, Shelby, J,14911867.970.000.000.00867.97
Phillips, Luis, G,207347.280.000.000.007.28
Chow, Candice,1923260.960.000.000.0060.96
Thompson, Brianna, X,1864269.970.000.000.0069.97
Martin, Thomas, A,169521735.980.000.000.001735.98
Ruiz, Philip,1807781.460.000.000.0081.46
Reed, Sean, L,145974803.310.000.000.004803.31
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Wilson, Grace,17539205.920.000.000.00205.92
Moore, Chloe, L,2626913.980.000.000.0013.98
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Alexander, Logan, E,191161183.470.000.000.001183.47
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
Henderson, Abigail,2044139.980.000.000.0039.98
Bailey, Olivia,238924.990.000.000.004.99
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
Washington, Ryan,2833294.480.000.000.0094.48
Kennedy, Bridget,2202639.980.000.000.0039.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Hall, Kyle, J,1749169.970.000.000.0069.97
Cook, Seth,2301064.470.000.000.0064.47
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Nelson, Henry,193941155.480.000.000.001155.48
Gray, Cody, C,144594775.010.000.000.004775.01
Hayes, Gavin, A,194001179.470.000.000.001179.47
Powell, Ian,2608564.470.000.000.0064.47
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28
Ward, Natalie, J,132412325.960.000.000.002325.96
Stewart, Melissa,2517336.960.000.000.0036.96
Blue, Makayla,1900029.990.000.000.0029.99
Nelson, Luis,234884.990.000.000.004.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Flores, Hannah,1952540.230.000.000.0040.23
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
James, Morgan, E,2324539.980.000.000.0039.98
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Alexander, Angelica,2271471.950.000.000.0071.95
Diaz, Faith, M,2236356.970.000.000.0056.97
Rodriguez, Taylor,1607166.960.000.000.0066.96
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Adams, Gabriel, S,195271219.450.000.000.001219.45
Adams, Carlos,1982236.960.000.000.0036.96
Long, Sarah,173721729.970.000.000.001729.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
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
Edwards, Logan,250024.990.000.000.004.99
Hall, Grace, A,201894.990.000.000.004.99
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Wang, Karen, P,1955331.970.000.000.0031.97
Morgan, Juan, C,1882191.970.000.000.0091.97
Bennett, Brittany, J,2233239.980.000.000.0039.98
Andersen, Latoya, J,290578.990.000.000.008.99
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
Chen, Ethan,2054756.970.000.000.0056.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Raje, Mindy, A,16083561.970.000.000.00561.97
Edwards, Amber, B,2051776.970.000.000.0076.97
Hughes, Anna,197052341.970.000.000.002341.97
Robinson, Julia,28121119.980.000.000.00119.98
Jai, Logan, H,12031769.490.000.000.00769.49
Brooks, Steven, C,14877889.470.000.000.00889.47
Gutierrez, Neil, L,214897.280.000.000.007.28
Roberts, Amanda,171752334.980.000.000.002334.98
Jai, Luis, A,18320185.920.000.000.00185.92
Walker, Richard, T,19640224.550.000.000.00224.55
Sanchez, Shelby,16021539.990.000.000.00539.99
Martin, Nicholas,233627.280.000.000.007.28
Foster, Paige,2742894.480.000.000.0094.48
Sanchez, Stephanie,1786756.970.000.000.0056.97
Brooks, Evan,2340139.980.000.000.0039.98
Jackson, Victoria,270194.990.000.000.004.99
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
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
Baker, Allison,2649558.980.000.000.0058.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
King, Sara,2235439.980.000.000.0039.98
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
Chandra, Allen,2932753.990.000.000.0053.99
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Bell, Brooke, H,2325339.980.000.000.0039.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Moore, Wyatt, F,189712351.960.000.000.002351.96
Harris, Anthony,2144721.980.000.000.0021.98
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Edwards, Hunter,2422067.930.000.000.0067.93
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
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
Martin, Katherine, J,2027339.980.000.000.0039.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
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
Moore, Ian, L,2463939.980.000.000.0039.98
Nath, Carl, H,29001624.970.000.000.00624.97
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
Sara, Ivan, L,2509067.930.000.000.0067.93
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Ward, Destiny,16128539.990.000.000.00539.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Johnson, Madison, L,15530846.460.000.000.00846.46
Hughes, Austin, P,183681754.980.000.000.001754.98
Griffin, James,28189567.760.000.000.00567.76
Gonzales, Gavin,2448813.980.000.000.0013.98
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Katherine, M,235184.990.000.000.004.99
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 11:45:57.898 UTC