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

259 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
White, Emma, N,16090604.960.000.000.00604.96
Ramirez, Richard, C,282397.280.000.007.280.00
Torres, Christina, M,20746119.950.000.000.00119.95
Anderson, Daniel,20694146.970.000.00146.970.00
Chandra, Allen,2932753.990.000.000.0053.99
Hayes, Gavin, A,194001179.470.000.000.001179.47
Nelson, Katherine,2802178.980.000.000.0078.98
Powell, Ian,2608564.470.000.000.0064.47
Kelly, Erin, D,2351364.470.000.000.0064.47
Andersen, Latoya, J,290578.990.000.000.008.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
Foster, Jessica,2606951.460.000.0051.460.00
James, Julia,2497567.930.000.000.0067.93
Butler, Jackson, J,183241735.980.000.000.001735.98
Reed, Gabriella, A,2743778.980.000.000.0078.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Foster, Abigail,1982346.470.000.000.0046.47
Watson, Victoria,16125588.960.000.000.00588.96
Yang, Jordan, K,14458133.950.000.000.00133.95
Parker, Katherine,13268289.700.000.0068.97220.73
Watson, Devin, A,18875114.950.000.000.00114.95
Gonzales, Brittany,217104187.233578.270.000.00608.96
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Alexander, Aidan,17387148.190.000.0056.9791.22
Moreno, Meredith, D,2228589.970.000.000.0089.97
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Ye, Alisha, J,220084141.233578.270.000.00562.96
Long, Gabrielle,198305765.923374.990.000.002390.93
Bailey, Richard, N,220504160.533578.270.000.00582.26
Moreno, Renee, C,12936265.220.000.000.00265.22
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Watson, Shelby, J,14911867.970.000.000.00867.97
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Perry, Melissa,221284142.230.003578.270.00563.96
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Rogers, Sara,198744544.450.003374.990.001169.46
Carter, Marcus, l,2147131.970.000.000.0031.97
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Miller, Joseph, A,227134148.190.003578.270.00569.92
Moore, Taylor, A,199874564.450.003374.990.001189.46
Ross, Antonio,18322148.890.000.000.00148.89
Howard, Morgan, T,229713578.270.003578.270.000.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Griffin, Xavier,228775962.340.003578.270.002384.07
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Anderson, Lucas,2926639.980.000.000.0039.98
Reed, Sean, L,145974803.310.000.000.004803.31
Morris, Chase, F,26789699.100.00699.100.000.00
Washington, Caroline, D,231145996.320.003578.270.002418.05
Powell, Elijah, E,231135997.330.003578.270.002419.06
Bryant, Kyle,231644807.100.003578.271228.830.00
Flores, Logan, K,14631848.470.000.000.00848.47
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Torres, Haley, W,232834828.110.003578.270.001249.84
Harris, Megan,232814828.110.003578.270.001249.84
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Powell, Jonathan,238584712.740.003578.271134.470.00
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Griffin, Jordan,13095328.890.000.0069.97258.92
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Ward, Devin, J,15378170.910.000.0076.9593.96
Chander, Wayne, S,243444329.610.003578.27751.340.00
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
Price, Isabelle,201825749.970.003374.990.002374.98
Yang, Thomas, A,14108839.480.000.000.00839.48
Allen, Amanda,2235339.980.000.000.0039.98
Rogers, Sean, G,18685124.460.000.000.00124.46
Henderson, Caroline,2008256.970.000.000.0056.97
Lu, Alejandro,2562039.980.000.000.0039.98
Hughes, Justin, M,181222439.990.000.000.002439.99
Umeda, Masaki,16717233.810.000.000.00233.81
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
Turner, Blake,12136131.740.000.000.00131.74
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Parker, Natalie, A,251043018.330.002443.350.00574.98
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
Turner, Amanda, L,203183241.900.002071.420.001170.48
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
Collins, Nathan, F,197041143.460.000.000.001143.46
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Smith, Tyler, J,2034156.970.000.000.0056.97
White, Miguel, S,13988195.520.000.000.00195.52
Hall, Luke, E,14745902.460.000.000.00902.46
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Morris, Alyssa,28072548.980.000.000.00548.98
Hall, Kyle, J,1749169.970.000.000.0069.97
Chow, Candice,1923260.960.000.000.0060.96
Davis, Marcus, T,17337123.910.000.0086.9536.96
Ortega, Javier, P,127852294.990.000.000.002294.99
Clark, Lauren,170341750.980.000.000.001750.98
Brown, Samantha, G,2514739.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Sharma, Yolanda, K,250483046.840.002443.350.00603.49
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
Sanders, Paige,252872983.340.002443.350.00539.99
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Harris, Edward,27062782.990.000.00782.990.00
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
Alexander, Thomas,207607.280.000.000.007.28
Dominguez, Erika, C,21251191.270.000.000.00191.27
Alexander, Taylor,17482146.940.000.0076.9769.97
Smith, Justin, P,1982721.980.000.000.0021.98
Hughes, Eduardo,15564188.520.000.000.00188.52
Rivera, Makayla, A,2878334.990.000.000.0034.99
Green, Gabriella, C,2803569.990.000.000.0069.99
Smith, Alexandra,2829261.960.000.000.0061.96
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
Hughes, Jasmine,276284.990.000.000.004.99
Walker, Jasmine,134604693.040.000.000.004693.04
Garcia, Isabella,18382204.940.000.000.00204.94
Martin, Nicholas,233627.280.000.000.007.28
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Morgan, Isaiah,18978118.730.000.000.00118.73
James, Zoe, R,14611304.550.000.000.00304.55
Turner, James, E,16841126.960.000.0069.9956.97
Hall, Jose, J,17601225.420.000.00155.4569.97
Nath, Kenneth, W,170372334.970.000.000.002334.97
Patterson, Abigail, H,144784795.010.000.000.004795.01
Sandberg, Chase,2190475.970.000.000.0075.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
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
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
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Moreno, Lance, A,2922939.980.000.000.0039.98
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Gutierrez, Neil, L,214897.280.000.000.007.28
Flores, Miguel,1975077.250.000.000.0077.25
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Lewis, Ethan,27998144.470.000.000.00144.47
Edwards, Elijah, D,281577.280.000.000.007.28
Rodriguez, Natalie,2077330.970.000.000.0030.97
Morgan, Evan, G,14725318.830.000.0069.97248.86
Cooper, Angela,195261179.470.000.000.001179.47
Bailey, Olivia,238924.990.000.000.004.99
Thames, Bernard,2380368.490.000.000.0068.49
Taylor, Lucas, V,115232376.960.000.002376.960.00
Walker, Richard, T,19640224.550.000.000.00224.55
Johnson, Cameron, R,137201155.480.000.000.001155.48
Stewart, Amanda, M,1531094.440.000.000.0094.44
Harris, Joshua, L,2028095.940.000.0030.9764.97
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Morris, Jessica,289678.990.000.008.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
Lee, James, J,2881769.990.000.0069.990.00
Walker, Ian,16771104.550.000.0054.5849.97
Sanders, Angel,16219553.970.000.000.00553.97
Coleman, Stephanie,2226489.970.000.000.0089.97
Gonzales, Jose,2201439.980.000.000.0039.98
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Gray, Cindy, A,13198114.950.000.0099.9714.98
Diaz, Brandon,236764.990.000.004.990.00
Foster, Alyssa, I,14875839.480.000.000.00839.48
Cooper, Brian, L,13760128.840.000.000.00128.84
Lee, Kayla, M,2078115.230.000.000.0015.23
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Hill, Eric, G,2525667.930.000.0067.930.00
Wang, Austin, A,1463284.970.000.009.9974.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Blanco, Armando, F,139182397.950.000.000.002397.95
Srini, Evelyn,16855150.950.000.000.00150.95
Edwards, Hunter,2422067.930.000.000.0067.93
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
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
Taylor, Marcus, A,18944146.940.000.000.00146.94
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
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
Richardson, Erin, R,1633188.850.000.0038.8849.97
Washington, Adam, G,2543713.980.000.000.0013.98
Baker, Mason, A,132702394.950.000.000.002394.95
Bradley, Evan,18506101.940.000.000.00101.94
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Gonzales, Paige,2170291.940.000.0039.9851.96
Hernandez, Sierra,27393123.980.000.00123.980.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Collins, Charles, B,29041628.450.000.000.00628.45
Kapoor, Preston,2143156.970.000.000.0056.97
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
Bradley, Nathaniel,169551760.470.000.000.001760.47
Ross, Aaron, N,118882376.960.000.002376.960.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Yuan, Brendan, S,247444.990.000.000.004.99
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
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
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
Johnson, Ian, E,2173283.470.000.000.0083.47
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
Turner, Mary,220154.990.000.000.004.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Adams, Katherine, M,235184.990.000.000.004.99
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
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
_SUM1806517.5061618.95486836.72314943.78943118.05

Generated 2024-11-10 22:02:51.669 UTC