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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Campbell, Timothy,2584513.980.000.000.0013.98
Lopez, Bailey, R,185571179.470.000.000.001179.47
Collins, Eduardo,139872329.990.000.000.002329.99
Rodriguez, Destiny, J,227397.280.000.000.007.28
Hughes, Isabella,2304851.460.000.000.0051.46
Zhang, Heather,166543056.320.000.000.003056.32
Lee, Ethan, J,223597.280.000.000.007.28
Martinez, Kristina, S,2134529.930.000.000.0029.93
Chen, David,2720839.980.000.000.0039.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Collins, Charles, B,29041628.450.000.000.00628.45
Scott, Sean, F,2475539.980.000.000.0039.98
Robinson, William,20103103.480.000.000.00103.48
Rubio, Javier, E,1972664.240.000.000.0064.24
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Johnson, Christopher,119794813.760.000.000.004813.76
Carter, Savannah, M,120902350.960.000.000.002350.96
Martinez, Joseph, E,2921459.980.000.000.0059.98
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Wu, Randy, J,116472365.940.000.000.002365.94
Harris, Noah,292562393.060.000.000.002393.06
Taylor, Lucas, V,115232376.960.000.000.002376.96
Martin, Joshua, A,276077.280.000.000.007.28
Kelly, Trinity,2609515.230.000.000.0015.23
Gomez, Krista,12760273.180.000.000.00273.18
Ramos, Derrick,18449100.940.000.000.00100.94
James, Richard, D,15760109.230.000.000.00109.23
Hughes, Nathan, B,121134737.530.000.000.004737.53
Kelly, Erin, D,2351364.470.000.000.0064.47
Morris, Jessica,289678.990.000.000.008.99
Edwards, Angel, J,2912469.990.000.000.0069.99
Collins, Sierra,185491169.460.000.000.001169.46
Bell, Christina,2609939.980.000.000.0039.98
Richardson, Arianna, C,1205534.980.000.000.0034.98
Watson, Marcus,2271585.480.000.000.0085.48
Robinson, Joseph,2814194.480.000.000.0094.48
Hughes, Antonio, P,15913712.270.000.000.00712.27
Perry, Samuel,18811100.960.000.000.00100.96
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Long, Brandon, M,16110650.470.000.000.00650.47
Simmons, Caleb, M,121934833.030.000.000.004833.03
Rivera, Rachel, S,2899678.980.000.000.0078.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Diaz, Richard, A,2668264.470.000.000.0064.47
Sanchez, Grace,120802354.990.000.000.002354.99
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Hill, Katherine, L,2670139.980.000.000.0039.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Murphy, Chase, J,2472958.980.000.000.0058.98
Diaz, Alyssa,139084715.330.000.000.004715.33
Miller, Kayla, A,236734.990.000.000.004.99
Bryant, Samantha,18345115.470.000.000.00115.47
Foster, Kayla,1969371.950.000.000.0071.95
Jones, Joshua,184012294.990.000.000.002294.99
Yuan, Leonard, F,167911729.970.000.000.001729.97
Johnson, Edward, H,23279124.990.000.000.00124.99
Green, Mackenzie, C,280737.280.000.000.007.28
Rogers, Jade, I,14332102.250.000.000.00102.25
Martin, Thomas, A,169521735.980.000.000.001735.98
Moore, Jessica, J,2008576.760.000.000.0076.76
Bryant, Jackson, J,2533239.980.000.000.0039.98
Perry, Justin, E,167583062.340.000.000.003062.34
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Hall, Kyle, J,1749169.970.000.000.0069.97
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Coleman, Stephanie,2226489.970.000.000.0089.97
Turner, Morgan,11823178.470.000.000.00178.47
Gonzales, Jose,2201439.980.000.000.0039.98
Martin, Samuel,15874225.440.000.000.00225.44
Jones, Michael, A,2210771.970.000.000.0071.97
Carter, Jesse, E,22141166.280.000.000.00166.28
Harris, Jeremiah, B,170231735.980.000.000.001735.98
James, Maria,1624391.970.000.000.0091.97
Walker, Destiny, M,169961754.980.000.000.001754.98
Hall, Kaylee, E,1975137.270.000.000.0037.27
Hayes, Gavin, A,194001179.470.000.000.001179.47
Collins, Jose,2474839.980.000.000.0039.98
Andersen, Latoya, J,290578.990.000.000.008.99
Simmons, Brittany,2923139.980.000.000.0039.98
Edwards, Amber, B,2051776.970.000.000.0076.97
Nelson, Luis,234884.990.000.000.004.99
Foster, Jose, C,2878534.990.000.000.0034.99
Jai, Logan, H,12031769.490.000.000.00769.49
Stewart, Garrett, O,15762564.480.000.000.00564.48
Thomas, Wyatt, R,12431154.540.000.000.00154.54
Foster, Caleb,27112114.460.000.000.00114.46
Blue, Paige,2170313.980.000.000.0013.98
Diaz, Faith, M,2236356.970.000.000.0056.97
Allen, Sean, L,12097159.220.000.000.00159.22
Perry, Lauren,248164.990.000.000.004.99
Hill, Fernando,247634.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Anderson, Emma, A,185801170.480.000.000.001170.48
Sanders, Lucas, W,268024.990.000.000.004.99
Kelly, Haley,15511128.560.000.000.00128.56
Long, Elizabeth, F,127822400.950.000.000.002400.95
Hughes, Destiny, P,28027119.980.000.000.00119.98
Miller, Destiny,251577.280.000.000.007.28
Martin, Nicholas,233627.280.000.000.007.28
Turner, Mary,220154.990.000.000.004.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Nelson, Katherine,2802178.980.000.000.0078.98
Sandberg, Chase,2190475.970.000.000.0075.97
Bell, Brooke, H,2325339.980.000.000.0039.98
Stewart, Destiny,13144281.470.000.000.00281.47
Stewart, Olivia, B,1874923.780.000.000.0023.78
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Evans, Gabriel,2348789.970.000.000.0089.97
Wright, Kyle,2371626.970.000.000.0026.97
Kelly, Angel, E,15418232.230.000.000.00232.23
Evans, Luke,2917615.230.000.000.0015.23
Moreno, Lance, A,2922939.980.000.000.0039.98
Roberts, Amanda,171752334.980.000.000.002334.98
Lewis, Ethan,27998144.470.000.000.00144.47
Edwards, Elijah, D,281577.280.000.000.007.28
Brown, Morgan,2919778.980.000.000.0078.98
Lee, Alexander, S,18356149.910.000.000.00149.91
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Johnson, Cameron, R,137201155.480.000.000.001155.48
Campbell, Lucas,2932953.990.000.000.0053.99
Mehta, Carmen, C,2743694.480.000.000.0094.48
Anand, Brendan, L,1984721.980.000.000.0021.98
Alexander, Caroline,176541759.970.000.000.001759.97
Young, Kaylee, S,13756298.490.000.000.00298.49
Anderson, Daniel,20694146.970.000.000.00146.97
Gray, Cody, C,144594775.010.000.000.004775.01
Baker, Allison,2649558.980.000.000.0058.98
Hall, Grace, A,201894.990.000.000.004.99
Barnes, Dalton, C,178581700.990.000.000.001700.99
Martinez, Carol, D,17656578.460.000.000.00578.46
Davis, Dylan,15556588.960.000.000.00588.96
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Hughes, Caroline, C,2830278.980.000.000.0078.98
Alvarez, Melody,2507068.490.000.000.0068.49
Scott, Mason,2355139.980.000.000.0039.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Collins, Amanda,2078339.980.000.000.0039.98
Alexander, Nathan, A,187951198.970.000.000.001198.97
Barnes, Jeremy,2144654.980.000.000.0054.98
Moore, Jonathan,2047896.460.000.000.0096.46
Jai, Edwin,169211754.980.000.000.001754.98
Kumar, Cameron, S,185711120.490.000.000.001120.49
Smith, Nathan,217647.280.000.000.007.28
Cox, Sara, P,2775869.990.000.000.0069.99
Van, Bobby,27757132.970.000.000.00132.97
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Harris, Matthew,14330806.760.000.000.00806.76
Moreno, Marie,2773969.990.000.000.0069.99
Barnes, Emily, G,15996564.990.000.000.00564.99
Gray, Jared, A,264494.990.000.000.004.99
Henderson, Justin, P,235917.280.000.000.007.28
Johnson, Jonathan,220597.280.000.000.007.28
Flores, Madison,14416769.490.000.000.00769.49
Hu, Gilbert, L,2876769.990.000.000.0069.99
Prasad, Erick, E,28786127.950.000.000.00127.95
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Green, Kaylee, C,2618567.970.000.000.0067.97
Phillips, Aaron, R,2494739.980.000.000.0039.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Cooper, Angela,195261179.470.000.000.001179.47
Stewart, Cindy,14496804.480.000.000.00804.48
McDonald, Aaron, J,27734119.980.000.000.00119.98
Bailey, Olivia,238924.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Patterson, Eric, A,2738478.980.000.000.0078.98
Russell, Gail, L,212634.990.000.000.004.99
Washington, Ryan,2833294.480.000.000.0094.48
Sanders, Angel,16219553.970.000.000.00553.97
Hall, Taylor, J,169951735.980.000.000.001735.98
Wang, Benjamin, R,274547.280.000.000.007.28
Wang, Karen, P,1955331.970.000.000.0031.97
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Simmons, Adam,253274.990.000.000.004.99
Patterson, Aaron, W,191131184.460.000.000.001184.46
Sanchez, Shelby,16021539.990.000.000.00539.99
Adams, Carlos,1982236.960.000.000.0036.96
Washington, Emma,191231170.480.000.000.001170.48
Cook, Joan,235544.990.000.000.004.99
Murphy, Brianna, K,2834269.990.000.000.0069.99
Harris, Anthony,2144721.980.000.000.0021.98
Nath, Alison, J,171161764.960.000.000.001764.96
Cannata, Gabrielle, C,217254.990.000.000.004.99
Ross, Aaron, N,118882376.960.000.000.002376.96
Srini, Evelyn,16855150.950.000.000.00150.95
Cooper, Amanda, P,146064716.020.000.000.004716.02
Davis, Justin,2807412.940.000.000.0012.94
Sanders, Hailey,19647282.040.000.000.00282.04
Taylor, Marcus, A,18944146.940.000.000.00146.94
Kelly, Bailey, R,28284563.770.000.000.00563.77
Hughes, Austin, P,183681754.980.000.000.001754.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Kumar, Elijah,15197156.920.000.000.00156.92
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kapoor, Preston,2143156.970.000.000.0056.97
Williams, Sydney, J,15334848.470.000.000.00848.47
Hayes, Carson, A,124472331.950.000.000.002331.95
Lewis, Ryan, A,203124.990.000.000.004.99
Diaz, Thomas, O,16020595.960.000.000.00595.96
Luo, Franklin, J,2202759.980.000.000.0059.98
Brooks, Ian, W,2829064.470.000.000.0064.47
Robinson, Lauren,2719668.490.000.000.0068.49
Torres, Dalton,235037.280.000.000.007.28
Parker, Jeremy,2866878.980.000.000.0078.98
Watson, Erin, B,227724.990.000.000.004.99
Harris, Seth, M,161402528.330.000.000.002528.33
Powell, Sydney, M,14886539.990.000.000.00539.99
Washington, Victoria,235577.280.000.000.007.28
Clark, Emily, R,120862294.990.000.000.002294.99
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Moore, Anthony, M,2473039.980.000.000.0039.98
Rubio, Kellie,27653128.970.000.000.00128.97
Zhang, Robert,188551155.480.000.000.001155.48
Robinson, Dylan, L,1472481.530.000.000.0081.53
Davis, Thomas,167641760.470.000.000.001760.47
Butler, Dalton, A,133454759.510.000.000.004759.51
Torres, Xavier,16840176.950.000.000.00176.95
Green, Eric,2738069.990.000.000.0069.99
Sanchez, Jared, J,2585064.470.000.000.0064.47
Peterson, Morgan, J,168341750.980.000.000.001750.98
Williams, Austin,2035432.220.000.000.0032.22
Phillips, Luis, G,207347.280.000.000.007.28
Howard, Brianna, D,246304.990.000.000.004.99
Washington, Aaron, L,246494.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
White, James,253317.280.000.000.007.28
Evans, Elijah, S,2588439.980.000.000.0039.98
Nelson, Henry,193941155.480.000.000.001155.48
Green, Xavier,2356739.980.000.000.0039.98
Campbell, Angel, D,195461174.480.000.000.001174.48
Clark, Zachary, J,2389358.980.000.000.0058.98
Powell, Ian,2608564.470.000.000.0064.47
Stewart, Melissa,2517336.960.000.000.0036.96
Shan, Christian, L,2308439.980.000.000.0039.98
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
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
Luo, Donna, E,248054.990.000.000.004.99
Roberts, Hunter,282607.280.000.000.007.28
Adams, Gabriel, S,195271219.450.000.000.001219.45

Generated 2025-12-22 00:28:51.368 UTC