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

321 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Mitchell, Caleb, K,268064.990.000.000.004.99
Alexander, Jason,2932849.990.000.000.0049.99
Diaz, Richard, A,2668264.470.000.000.0064.47
Hayes, Hannah, J,2165656.970.000.000.0056.97
Thomas, David,168363193.790.000.000.003193.79
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Patterson, Natalie,16123629.970.000.000.00629.97
Wilson, Grace,17539205.920.000.000.00205.92
Hernandez, Haley, L,11769478.950.000.000.00478.95
Morris, Mason, J,22349124.990.000.000.00124.99
Long, Sydney,279217.280.000.000.007.28
Stewart, Sara,17347119.720.000.000.00119.72
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Ortega, Byron,233064828.110.003578.270.001249.84
Robinson, Zachary, L,137092332.280.000.000.002332.28
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Brown, Morgan,2919778.980.000.000.0078.98
Madan, Carmen, V,155674720.270.000.000.004720.27
Jai, Hunter, M,28272111.950.000.000.00111.95
Cook, Megan, J,2029956.970.000.000.0056.97
Gray, Isabella,168203217.790.000.000.003217.79
Serrano, Albert, E,133284708.020.000.000.004708.02
Hill, Timothy,14871848.470.000.000.00848.47
Anderson, Emma, A,185801170.480.000.000.001170.48
Alexander, Julia, J,15291889.470.000.000.00889.47
Bradley, Melanie, G,133434720.270.000.000.004720.27
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Torres, Mariah,16380195.950.000.000.00195.95
Alexander, Caroline,176541759.970.000.000.001759.97
Wright, Kyle,2371626.970.000.000.0026.97
Nelson, Kevin,1476584.970.000.000.0084.97
Bailey, Mariah, L,2724354.980.000.000.0054.98
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Lopez, Jack, I,2904751.460.000.000.0051.46
Rowe, Todd,14586233.940.000.000.00233.94
Hayes, Oscar,2652729.260.000.000.0029.26
Barnes, Dalton, C,178581700.990.000.000.001700.99
Stewart, Destiny,13144281.470.000.000.00281.47
Murphy, Maria,160113657.260.000.000.003657.26
Smith, Tyler, J,2034156.970.000.000.0056.97
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Gutierrez, Jerome,127832420.460.000.000.002420.46
Cooper, Brianna,2592513.980.000.000.0013.98
Phillips, Miguel,2049812.940.000.000.0012.94
Cox, Katelyn, B,2174230.970.000.000.0030.97
King, Caleb, J,2898678.980.000.000.0078.98
Hall, Amber,20106131.950.000.000.00131.95
Williams, Ian, M,175581750.470.000.000.001750.47
Coleman, Joan, W,2669964.470.000.000.0064.47
Hughes, Miranda,266784.990.000.000.004.99
Thompson, Madison, L,187882351.960.000.000.002351.96
Jackson, Hannah, G,131432404.970.000.000.002404.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Hughes, Justin, M,181222439.990.000.000.002439.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Sharma, Thomas, A,18637121.940.000.000.00121.94
Russell, Caleb,23552103.480.000.000.00103.48
Chen, Jackson, S,270751371.950.000.00782.99588.96
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Hayes, Carson, A,124472331.950.000.000.002331.95
Long, Jordan,199884555.470.003399.990.001155.48
Bell, Danielle,140414765.020.000.000.004765.02
Morris, Chase, F,26789699.100.00699.100.000.00
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Gill, Beth,199975814.980.003374.990.002439.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Bryant, Isabelle,233974828.110.003578.270.001249.84
Barnes, Blake, A,178651789.970.000.000.001789.97
White, Cameron,238304802.110.003578.270.001223.84
Shan, Logan,1867760.960.000.000.0060.96
Foster, Olivia,238063578.270.003578.270.000.00
Diaz, Trevor, B,2051954.960.000.000.0054.96
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Sanders, Hailey,19647282.040.000.000.00282.04
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Stewart, Alex, M,2008463.150.000.000.0063.15
Bryant, Samantha,18345115.470.000.000.00115.47
Reed, Megan, A,181181750.980.000.000.001750.98
Johnson, Edward, H,23279124.990.000.000.00124.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Cooper, Paige,14119148.940.000.000.00148.94
Foster, Isabelle,2637739.980.000.000.0039.98
Walker, Brandon, J,159164793.270.000.000.004793.27
Ma, Tiffany,2157739.980.000.000.0039.98
Bryant, Gabriel,2765669.990.000.000.0069.99
Foster, Abigail,1982346.470.000.000.0046.47
Bryant, Brittany,2254548.970.000.000.0048.97
Watson, Victoria,16125588.960.000.000.00588.96
Hughes, Jasmine,276284.990.000.000.004.99
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Hall, Fernando,2210090.950.000.000.0090.95
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Martinez, Kristina, S,2134529.930.000.000.0029.93
Hall, Wyatt,2382713.980.000.000.0013.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Flores, Luke, L,247337.280.000.000.007.28
Cook, Seth,2301064.470.000.000.0064.47
Nath, Carl, H,29001624.970.000.000.00624.97
Harris, Destiny, M,137102341.460.000.000.002341.46
Bell, Chase,180911750.980.000.000.001750.98
Sanders, Megan, A,15376136.240.000.000.00136.24
Wilson, Emily,174002331.950.000.000.002331.95
Gray, Brianna,249603008.820.002443.350.00565.47
Johnson, Cameron, R,137201155.480.000.000.001155.48
Jai, Adam,250952443.350.000.002443.350.00
Chen, Jack, E,17579151.430.000.000.00151.43
Huang, Kristen,251002443.350.000.002443.350.00
Luo, Jodi,2921368.490.000.000.0068.49
Russell, Fernando,27084782.990.000.00782.990.00
Young, Courtney,176222374.980.000.000.002374.98
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Gonzalez, Molly,1637021.980.000.000.0021.98
Cooper, Andrea,2932378.980.000.000.0078.98
Hughes, Riley,2928449.990.000.000.0049.99
Robinson, Sarah, A,2702859.980.000.000.0059.98
Patterson, Alexis,213484392.020.000.002049.102342.92
Martin, Samuel,15874225.440.000.000.00225.44
Alexander, Julian,132172351.960.000.000.002351.96
Torres, Mackenzie,28153570.470.000.000.00570.47
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Alexander, Thomas,207607.280.000.000.007.28
Edwards, Hunter,2422067.930.000.000.0067.93
Cox, Devin, C,134184768.050.000.000.004768.05
Evans, James, C,206654408.560.000.002049.102359.46
Parker, Caleb, A,2631813.980.000.000.0013.98
Ward, Destiny,16128539.990.000.000.00539.99
Zhang, Nathan, L,2910478.980.000.000.0078.98
Ward, Eduardo, I,139162354.980.000.000.002354.98
Simmons, Brittany,2923139.980.000.000.0039.98
Taylor, Zachary, M,27082782.990.000.00782.990.00
Nelson, Luis,234884.990.000.000.004.99
Hill, Sydney,264821000.440.000.001000.440.00
Liu, Arturo,13222150.410.000.000.00150.41
Diaz, Hunter, S,27242782.990.000.00782.990.00
Ward, Emma, W,2179659.980.000.000.0059.98
Howard, Alexandra,207363194.580.000.002049.101145.48
Alexander, Edward, E,18524195.950.000.000.00195.95
James, Timothy,213312670.890.000.002670.890.00
Martin, Nicholas,233627.280.000.000.007.28
Anderson, Isabella,137432349.980.000.000.002349.98
Stewart, Olivia, B,1874923.780.000.000.0023.78
Perry, Brandon,22095141.980.000.000.00141.98
Adams, Kaitlyn, A,11869239.600.000.000.00239.60
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Mitchell, Alexandra,14455218.930.000.000.00218.93
Campbell, Lucas,2932953.990.000.000.0053.99
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Moore, Wyatt, F,189712351.960.000.000.002351.96
Henderson, Abigail,2044139.980.000.000.0039.98
Price, Oscar, G,11833240.010.000.000.00240.01
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Carter, Jesse, E,22141166.280.000.000.00166.28
James, Adrian, C,253404.990.000.000.004.99
Richardson, Olivia,204683169.590.000.002049.101120.49
Peterson, Xavier, R,2645639.980.000.000.0039.98
Kennedy, Bridget,2202639.980.000.000.0039.98
White, Greg, C,174032322.280.000.000.002322.28
Butler, Isabel,16241126.960.000.000.00126.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
He, Micah,2740169.990.000.000.0069.99
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Ward, Cole,214907.280.000.000.007.28
Collins, Amanda,2078339.980.000.000.0039.98
Sánchez, Angela, C,176551750.980.000.000.001750.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
Jai, Luis, A,18320185.920.000.000.00185.92
Powell, Katherine, C,14574177.600.000.000.00177.60
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Nelson, Jose,19217185.020.000.000.00185.02
Sanchez, Faith,270494.990.000.000.004.99
Lewis, Ryan, A,203124.990.000.000.004.99
Campbell, Alex,119844730.320.000.000.004730.32
Lewis, Brandon, A,2903769.990.000.000.0069.99
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Carter, Savannah, M,120902350.960.000.000.002350.96
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Chen, Ethan,2054756.970.000.000.0056.97
Sandberg, Chase,2190475.970.000.000.0075.97
Lewis, Morgan,17410168.740.000.000.00168.74
Collins, Allison,28581119.980.000.000.00119.98
Moreno, Lance, A,2922939.980.000.000.0039.98
Lewis, Ethan,27998144.470.000.000.00144.47
Collins, Jonathan,16849119.980.000.000.00119.98
Mitchell, Evan, R,247314.990.000.000.004.99
Phillips, Kaylee,211384371.380.000.002049.102322.28
Ross, Rachel, C,206693169.590.000.002049.101120.49
Long, Sarah,173721729.970.000.000.001729.97
Baker, Allison,2649558.980.000.000.0058.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
Thompson, Devin,207084406.400.000.002071.422334.98
Foster, Aaron,155664912.470.000.000.004912.47
Foster, Alyssa, I,14875839.480.000.000.00839.48
Srini, Ruben,18078200.940.000.000.00200.94
Zhang, Connor, R,138532329.980.000.000.002329.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Walker, Jacob, N,29027574.980.000.000.00574.98
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
Thompson, Joshua, F,259992181.560.000.002181.560.00
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Campbell, Adam, A,214002688.890.000.002071.42617.47
Stewart, Marcus, R,2063221.980.000.000.0021.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Richardson, Devin, G,2131836.960.000.000.0036.96
Russell, Nicole, M,182372318.960.000.000.002318.96
Luo, Franklin, J,2202759.980.000.000.0059.98
Moore, Jonathan,2047896.460.000.000.0096.46
Alexander, Gavin, K,2932249.990.000.000.0049.99
Jones, Alexander, I,2002180.960.000.000.0080.96
Stewart, Makayla,16649115.940.000.000.00115.94
Peterson, Christina,2897694.480.000.000.0094.48
Watson, Marcus,2271585.480.000.000.0085.48
Collins, Eduardo,139872329.990.000.000.002329.99
Lal, Caleb, R,1586874.460.000.000.0074.46
Flores, Madison,14416769.490.000.000.00769.49
Washington, Alexis,1978146.260.000.000.0046.26
Russell, Katherine,2877169.990.000.000.0069.99
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Robinson, Madison, W,183772394.970.000.000.002394.97
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Yuan, Brendan, S,247444.990.000.000.004.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Gray, Marcus, T,183892401.450.000.000.002401.45
Davis, Thomas,167641760.470.000.000.001760.47
Yuan, Leonard, F,167911729.970.000.000.001729.97
Green, Mackenzie, C,280737.280.000.000.007.28
Li, Thomas,181162376.960.000.000.002376.96
Davis, Justin,2807412.940.000.000.0012.94
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Bradley, Jocelyn,230227.280.000.000.007.28
Kelly, Erin, D,2351364.470.000.000.0064.47
Phillips, Luis, G,207347.280.000.000.007.28
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Ruiz, Philip,1807781.460.000.000.0081.46
Johnson, Andrew, F,262942443.350.000.002443.350.00
Carter, Elijah,216182611.070.000.002049.10561.97
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Allen, Luke,113162349.980.000.002349.980.00
Martinez, Dominique,287888.990.000.000.008.99
McDonald, Aaron, J,27734119.980.000.000.00119.98
Nelson, Jordan, H,201304.990.000.000.004.99
Butler, Trevor,2741569.990.000.000.0069.99
Wright, Jennifer,2650559.980.000.000.0059.98
Evans, Maria,22544127.280.000.000.00127.28
Patterson, Eric, A,2738478.980.000.000.0078.98
Roberts, Carlos,2319639.980.000.000.0039.98
Hughes, Luis,130841798.960.000.000.001798.96
Coleman, Stephanie,2226489.970.000.000.0089.97
Brown, Dylan, J,124492351.960.000.000.002351.96
Ward, Mariah, J,2158044.910.000.000.0044.91
White, Christopher, R,260492181.560.000.002181.560.00
Butler, Ana,260403018.330.000.002443.35574.98
Harris, Jacob, G,2367939.980.000.000.0039.98
Moore, Logan,2634889.970.000.000.0089.97
Turner, Samuel,2742069.990.000.000.0069.99
Coleman, Destiny, W,121224814.040.000.000.004814.04
Jackson, Brianna,1537797.910.000.000.0097.91
Jones, Michael, A,2210771.970.000.000.0071.97
Griffin, Melissa, L,287807.950.000.000.007.95
Green, Xavier,2356739.980.000.000.0039.98
Lobao, Alexandre,1892691.950.000.000.0091.95
Lopez, Bailey, R,185571179.470.000.000.001179.47
Diaz, Ryan, J,16910141.960.000.000.00141.96
Campbell, Angel, D,195461174.480.000.000.001174.48
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Powell, Ian,2608564.470.000.000.0064.47
Prasad, Summer, M,2214339.980.000.000.0039.98
Wu, Randy, J,116472365.940.000.000.002365.94
Ramos, Derrick,18449100.940.000.000.00100.94
Collins, Sierra,185491169.460.000.000.001169.46
James, Emma,127812329.980.000.000.002329.98
Cooper, Brooke,195361120.490.000.000.001120.49
Lee, James, J,2881769.990.000.000.0069.99
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Patterson, Aaron, W,191131184.460.000.000.001184.46
Diaz, Brandon,236764.990.000.000.004.99
Foster, Caleb,27112114.460.000.000.00114.46
Hill, Eric, G,2525667.930.000.000.0067.93
Anderson, Daniel,20694146.970.000.000.00146.97
Richardson, Charles, I,121144719.020.000.000.004719.02
Adams, Gabriel, S,195271219.450.000.000.001219.45
Smith, Zachary, W,2378358.980.000.000.0058.98
Perez, Charles,266937.280.000.000.007.28
Davis, Dylan,15556588.960.000.000.00588.96
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Foster, Jessica,2606951.460.000.000.0051.46
Washington, Emma,191231170.480.000.000.001170.48
Roberts, Wyatt,15900699.970.000.000.00699.97
Miller, Destiny,251577.280.000.000.007.28
Cook, Joan,235544.990.000.000.004.99
Murphy, Brianna, K,2834269.990.000.000.0069.99
Simmons, Caleb, M,121934833.030.000.000.004833.03
Turner, Mary,220154.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Harris, Anthony,2144721.980.000.000.0021.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Gill, Robyn, J,127651750.980.000.000.001750.98
Smith, Hannah, J,2526554.980.000.000.0054.98
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Watson, Erin, B,227724.990.000.000.004.99
Smith, Eduardo,2069139.980.000.000.0039.98
Cox, Sara, P,2775869.990.000.000.0069.99
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Sanchez, Grace,120802354.990.000.000.002354.99
_SUM1806517.5014313.08487820.91251094.681053288.83

Generated 2026-01-04 05:39:21.326 UTC