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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Williams, Ethan,243094793.120.003578.270.001214.85
Hughes, Luke, I,270141274.080.00699.100.00574.98
Turner, Timothy, C,14641119.860.000.000.00119.86
Lal, Jonathan,2009671.460.000.000.0071.46
Bennett, Seth,244933578.270.003578.270.000.00
Yang, Thomas, A,14108839.480.000.000.00839.48
Allen, Amanda,2235339.980.000.000.0039.98
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Rogers, Sean, G,18685124.460.000.000.00124.46
Henderson, Caroline,2008256.970.000.000.0056.97
Moore, Andrew, A,13944150.130.000.0036.27113.86
Sharma, Yolanda, K,250483046.840.002443.350.00603.49
Lu, Alejandro,2562039.980.000.000.0039.98
Hughes, Justin, M,181222439.990.000.000.002439.99
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Gray, Brianna,249603008.820.002443.350.00565.47
Turner, Andrea, A,202093268.550.002049.100.001219.45
Carter, Jason,11724210.090.000.00113.8696.23
Turner, Amanda, L,203183241.900.002071.420.001170.48
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Parker, Natalie, A,251043018.330.002443.350.00574.98
Suarez, Juan, R,167631700.990.000.000.001700.99
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Madan, Carmen, V,155674720.270.000.000.004720.27
Harris, Edward,27062782.990.000.00782.990.00
Turner, Blake,12136131.740.000.000.00131.74
Jai, Kevin,1983678.960.000.0038.9839.98
Stewart, Julia, L,129022329.980.000.000.002329.98
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Adams, Hailey, M,121544798.530.000.002379.472419.06
Hill, Fernando,247634.990.000.000.004.99
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Ross, Xavier, A,12202171.470.000.0049.97121.50
Washington, Elijah, L,250164.990.000.000.004.99
Yuan, Carly,19839194.960.000.000.00194.96
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Morris, Alyssa,28072548.980.000.000.00548.98
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Collins, Nathan, F,197041143.460.000.000.001143.46
Hall, Kyle, J,1749169.970.000.000.0069.97
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Davis, Marcus, T,17337123.910.000.0086.9536.96
Smith, Tyler, J,2034156.970.000.000.0056.97
Reed, Marcus,14582111.790.000.0014.9896.81
Hall, Luke, E,14745902.460.000.000.00902.46
Ortega, Javier, P,127852294.990.000.000.002294.99
Clark, Lauren,170341750.980.000.000.001750.98
Lewis, Isabella,2624267.930.000.000.0067.93
Thompson, Blake,18390141.960.000.000.00141.96
Griffin, Isabelle,249864.990.000.000.004.99
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Brown, Samantha, G,2514739.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Alexander, Thomas,207607.280.000.000.007.28
Dominguez, Erika, C,21251191.270.000.000.00191.27
Rivera, Makayla, A,2878334.990.000.000.0034.99
Alexander, Taylor,17482146.940.000.0076.9769.97
Smith, Justin, P,1982721.980.000.000.0021.98
Green, Gabriella, C,2803569.990.000.000.0069.99
Smith, Alexandra,2829261.960.000.000.0061.96
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Johnson, Anthony, D,270224.990.000.000.004.99
Rivera, Ariana,261734.990.000.000.004.99
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Walker, Jasmine,134604693.040.000.000.004693.04
Hughes, Jasmine,276284.990.000.000.004.99
Garcia, Isabella,18382204.940.000.000.00204.94
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Scott, Sean, F,2475539.980.000.000.0039.98
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Nelson, Jordan, H,201304.990.000.004.990.00
Walker, Ian,16771104.550.000.0054.5849.97
Edwards, Hunter,2422067.930.000.000.0067.93
Robinson, Emily,12183228.420.000.0054.96173.46
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Ashe, Alexis, S,194141145.480.000.000.001145.48
Miller, Victoria,15816188.020.000.0081.46106.56
Green, Kaylee, C,2618567.970.000.000.0067.97
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Butler, Trevor,2741569.990.000.0069.990.00
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Coleman, Miguel, D,2740069.990.000.0069.990.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Wright, Jennifer,2650559.980.000.0059.980.00
Reed, Morgan, E,2877923.970.000.000.0023.97
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Baker, Mason, A,132702394.950.000.000.002394.95
Gray, Cindy, A,13198114.950.000.0099.9714.98
Hall, Jose, J,17601225.420.000.00155.4569.97
Gonzales, Paige,2170291.940.000.0039.9851.96
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Bradley, Evan,18506101.940.000.000.00101.94
Jones, Kayla, C,1854194.260.000.000.0094.26
White, Judith, R,148851155.480.000.000.001155.48
Davis, Jonathan,2925913.980.000.000.0013.98
Taylor, Lucas, V,115232376.960.000.002376.960.00
Yuan, Brendan, S,247444.990.000.000.004.99
Morris, Jessica,289678.990.000.008.990.00
Li, Eugene, A,15283865.950.000.000.00865.95
Ross, Seth, M,184332329.980.000.000.002329.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Lee, James, J,2881769.990.000.0069.990.00
Nelson, Jose,19217185.020.000.0091.9593.07
Diaz, Brandon,236764.990.000.004.990.00
Johnson, Ian, E,2173283.470.000.000.0083.47
Hill, Eric, G,2525667.930.000.0067.930.00
Wang, Austin, A,1463284.970.000.009.9974.98
Cooper, Angela,195261179.470.000.000.001179.47
Barnes, Ian, M,16106133.540.000.000.00133.54
Bailey, Olivia,238924.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
Srini, Evelyn,16855150.950.000.000.00150.95
Ward, Cole,214907.280.000.000.007.28
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Davis, Dylan,15556588.960.000.00588.960.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Sanders, Angel,16219553.970.000.000.00553.97
Coleman, Stephanie,2226489.970.000.000.0089.97
Gonzales, Jose,2201439.980.000.000.0039.98
Richardson, Erin, R,1633188.850.000.0038.8849.97
Hayes, Dalton, C,188822322.280.000.000.002322.28
Rivera, Sara,187852350.960.000.000.002350.96
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Reed, Megan, A,181181750.980.000.000.001750.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Roberts, Jordan, M,1680039.250.000.000.0039.25
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Turner, Eduardo,158764789.020.000.000.004789.02
Foster, Abigail,1982346.470.000.000.0046.47
Watson, Victoria,16125588.960.000.000.00588.96
Morgan, Evan, G,14725318.830.000.0069.97248.86
Ross, Aaron, N,118882376.960.000.002376.960.00
Hall, Wyatt,2382713.980.000.000.0013.98
Nath, Carl, H,29001624.970.000.000.00624.97
Li, Rafael, M,217527.280.000.000.007.28
Bell, Chase,180911750.980.000.000.001750.98
Thomas, Dalton,230097.280.000.000.007.28
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Rodriguez, Natalie,2077330.970.000.000.0030.97
Smith, Nathan,217647.280.000.000.007.28
Harris, Seth, M,161402528.330.000.000.002528.33
Lewis, Christopher,1875586.960.000.000.0086.96
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Hughes, Antonio, P,15913712.270.000.000.00712.27
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Simmons, Caleb, M,121934833.030.000.000.004833.03
Sanchez, Grace,120802354.990.000.000.002354.99
Johnson, Jonathan,220597.280.000.000.007.28
Hill, Katherine, L,2670139.980.000.000.0039.98
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Blanco, Armando, F,139182397.950.000.000.002397.95
Cooper, Brooke,195361120.490.000.000.001120.49
Henderson, Olivia,188591155.480.000.000.001155.48
Shan, Christian, L,2308439.980.000.000.0039.98
Taylor, Marcus, A,18944146.940.000.000.00146.94
Washington, Adam, G,2543713.980.000.000.0013.98
Bradley, Nathaniel,169551760.470.000.000.001760.47
Collins, Charles, B,29041628.450.000.000.00628.45
Kapoor, Preston,2143156.970.000.000.0056.97
Price, Rachel, D,2532889.970.000.000.0089.97
Edwards, Logan,250024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Turner, Mary,220154.990.000.000.004.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Harris, Anthony,2144721.980.000.000.0021.98
Nath, Alison, J,171161764.960.000.000.001764.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Wang, Zachary,2214489.970.000.000.0089.97
Adams, Katherine, M,235184.990.000.000.004.99
Howard, Erin, L,183621725.210.000.000.001725.21
Ramirez, Sydney,267007.280.000.000.007.28
Morgan, Timothy,14633242.500.000.0071.58170.92
Peterson, Mason, A,185701174.480.000.001174.480.00
Taylor, Christian,2076456.760.000.000.0056.76
Sun, Arturo, C,11498557.540.000.007.95549.59
Moore, Hunter,14897196.270.000.0071.58124.69
Cooper, Grace, C,1601294.260.000.000.0094.26
Brown, Isabella, L,266921266.860.00699.100.00567.76
Griffin, Seth, R,17585164.460.000.0078.9885.48
Jackson, Hannah, G,131432404.970.000.000.002404.97
Perez, Barry, M,2728269.990.000.000.0069.99
Garcia, Jonathan,1888386.960.000.0029.9956.97
Hall, Amber,20106131.950.000.000.00131.95
Zeng, Jake,18054106.930.000.000.00106.93
Bennett, Antonio, C,11631707.500.000.00156.86550.64
Smith, Samuel, D,2308349.900.000.000.0049.90
Ramos, Derrick,18449100.940.000.0030.9769.97
Barnes, Fernando,113001390.550.000.00248.381142.17
Foster, Samuel, M,18523160.940.000.00128.9731.97
Taylor, Tyler, A,12032614.960.000.00614.960.00
Perez, Dalton,110911125.360.000.00139.38985.98
Hill, Jordan, J,16005198.730.000.0069.99128.74
Brooks, Allison,146054750.010.000.000.004750.01
Hill, Carlos,12919257.880.000.00158.9398.95
Nelson, Jennifer,171471700.990.000.000.001700.99
Wright, Jackson,11698225.950.000.000.00225.95
Foster, Isabelle,2637739.980.000.000.0039.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Coleman, Ian,2127639.980.000.000.0039.98
Anderson, Destiny,12895336.650.000.0037.27299.38
Hill, Haley, J,161033142.320.000.00792.342349.98
Thompson, Lucas, O,212774.990.000.000.004.99
Torres, Mariah,16380195.950.000.000.00195.95
Campbell, Gabriella,188411145.480.000.000.001145.48
Jackson, Andrew,2047985.480.000.000.0085.48
Baker, Eduardo,180921789.450.000.000.001789.45
Lee, Ethan, J,223597.280.000.000.007.28
Li, Thomas,181162376.960.000.000.002376.96
White, Abigail, T,15866145.820.000.0038.88106.94
Martinez, Jonathan,1330366.250.000.000.0066.25
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Zhang, Heather,166543056.320.000.00751.342304.98
Washington, Kayla, E,14655174.960.000.0069.97104.99
Brown, Fernando,1900191.950.000.0069.9721.98
Hall, Lauren, A,19648100.840.000.000.00100.84
Green, Marcus, C,15974208.410.000.0091.95116.46
Torres, Erin,1218287.250.000.0037.2949.96
Hall, Fernando,2210090.950.000.000.0090.95
Rodriguez, Julia, A,264884.990.000.004.990.00
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Bell, Danielle,140414765.020.000.000.004765.02
Russell, Arianna,22728149.930.000.00149.930.00
Henderson, Ashley,111851381.370.000.00232.801148.57
Price, Riley, R,139094764.020.000.000.004764.02
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Hall, Noah, A,1525175.250.000.000.0075.25
Taylor, Madison, A,11802215.290.000.00127.9687.33
Taylor, Edward, C,17442319.880.000.00230.9088.98
Foster, Edward, R,18355150.950.000.000.00150.95
Ross, Anna, D,15494275.440.000.0029.99245.45

Generated 2024-11-10 17:43:18.495 UTC