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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Price, Jocelyn, D,258752443.350.002443.350.000.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Coleman, Lucas, A,27060782.990.00782.990.000.00
Harris, Edward,27062782.990.00782.990.000.00
Cook, Bryce,2864069.990.000.000.0069.99
Sanders, Alexandra,259112181.560.002181.560.000.00
Hill, Fernando,247634.990.000.004.990.00
Deng, Damien, A,16873578.460.000.000.00578.46
Cook, Megan, J,2029956.970.000.0056.970.00
Bradley, Melanie, G,133434720.270.000.002319.262401.01
Kelly, Haley,15511128.560.000.0036.5991.97
Thomas, Victoria, A,15536249.530.000.000.00249.53
Perez, Angel, S,213362628.350.000.002628.350.00
Bailey, Hailey, R,262704.990.000.000.004.99
Powell, Lauren, E,1966275.970.000.000.0075.97
Stewart, Grace, H,247737.280.000.007.280.00
Bailey, Mariah, L,2724354.980.000.0054.980.00
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Evans, Luke,2917615.230.000.0015.230.00
Robinson, Sarah, A,2702859.980.000.0059.980.00
Cooper, Brianna,2592513.980.000.0013.980.00
Cox, Katelyn, B,2174230.970.000.0030.970.00
Coleman, Joan, W,2669964.470.000.0064.470.00
Hughes, Isabella,2304851.460.000.0051.460.00
Morgan, Isaiah,18978118.730.000.0081.4637.27
Ward, Jade, D,14661195.020.000.0074.98120.04
Lee, Ethan, J,223597.280.000.007.280.00
Harris, Destiny, M,137102341.460.000.000.002341.46
Taylor, Zachary, M,27082782.990.00782.990.000.00
Hill, Sydney,264821000.440.000.001000.440.00
Williams, Zachary, B,27099782.990.000.00782.990.00
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Diaz, Angela, K,27259782.990.000.00782.990.00
Cox, Julia, A,206703228.570.000.002049.101179.47
Diaz, Hunter, S,27242782.990.000.00782.990.00
Jai, Connor, D,27253782.990.000.00782.990.00
Taylor, Victoria,260132443.350.000.002443.350.00
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Davis, Emily,27267782.990.000.00782.990.00
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Collins, Connor, J,27270782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Lewis, Ryan, A,203124.990.000.004.990.00
Perez, Kaitlyn, A,120812366.960.000.002366.960.00
Carter, Savannah, M,120902350.960.000.002350.960.00
Barnes, Jeremy,2144654.980.000.0054.980.00
Thompson, Blake,18390141.960.000.000.00141.96
Morris, Seth,189592341.460.000.000.002341.46
Edwards, Angel, J,2912469.990.000.000.0069.99
Clark, Emily, R,120862294.990.000.000.002294.99
Moreno, Marie,2773969.990.000.000.0069.99
Cooper, Andrea,2932378.980.000.000.0078.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
Andersen, Latoya, J,290578.990.000.000.008.99
Zhao, Clarence, R,1982671.970.000.0071.970.00
Xu, Louis,2010466.530.000.0066.530.00
Perry, Natalie,1712669.990.000.000.0069.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Stewart, Melissa,2517336.960.000.000.0036.96
Moore, Jessica, J,2008576.760.000.000.0076.76
Henderson, Olivia,188591155.480.000.000.001155.48
Torres, Victoria,17551160.920.000.000.00160.92
Foster, Jose, C,2878534.990.000.000.0034.99
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Martinez, Joseph, E,2921459.980.000.0059.980.00
Prasad, Summer, M,2214339.980.000.0039.980.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Gray, Sara,292472447.050.000.002447.050.00
Barnes, Elizabeth, J,249397.280.000.000.007.28
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Lee, James, J,2881769.990.000.0069.990.00
Scott, Eric,282484.990.000.004.990.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Moore, Chloe, L,2626913.980.000.000.0013.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Alexander, Angelica,2271471.950.000.000.0071.95
Nelson, Jose,19217185.020.000.0091.9593.07
Collins, Jose,2474839.980.000.0039.980.00
Perry, Lauren,248164.990.000.000.004.99
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Griffin, Miguel,2146476.970.000.000.0076.97
Washington, Emma,191231170.480.000.000.001170.48
Sanders, Lucas, W,268024.990.000.000.004.99
Thompson, Madison, L,187882351.960.000.000.002351.96
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Coleman, Samuel, N,17450123.980.000.000.00123.98
Russell, Caleb,23552103.480.000.000.00103.48
Edwards, Hailey,242584.990.000.000.004.99
Anderson, Madison, G,2835978.980.000.000.0078.98
Chandra, Allen,2932753.990.000.000.0053.99
Gonzales, Jordan,2368113.980.000.000.0013.98
Phillips, Haley, B,2807939.980.000.000.0039.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Foster, Isabelle,2637739.980.000.000.0039.98
Ma, Tiffany,2157739.980.000.000.0039.98
Reed, Isaac, D,260747.280.000.000.007.28
Carter, Jesse, E,22141166.280.000.000.00166.28
Ramirez, Ian,166783162.310.000.00742.352419.96
Henderson, Hailey, C,171481775.470.000.000.001775.47
Anderson, Daniel,20694146.970.000.00146.970.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Deng, Wayne,2145336.960.000.0036.960.00
Garcia, Kayla, L,2130881.460.000.000.0081.46
Flores, Brittany,169062359.980.000.000.002359.98
Thomas, Megan,2907169.990.000.000.0069.99
Jenkins, Megan, R,12074261.380.000.000.00261.38
Watson, Marcus,2271585.480.000.000.0085.48
Kelly, Trinity,2609515.230.000.000.0015.23
Taylor, Christian,2076456.760.000.000.0056.76
Lal, Robert, L,14084138.680.000.0035.00103.68
Winston, Ethan, R,216222612.060.000.002049.10562.96
Martin, Xavier,222335997.330.003578.270.002419.06
Blue, Marcus, L,27550782.990.000.00782.990.00
Howard, Isaiah,259813018.330.002443.350.00574.98
Washington, Alexia,27613782.990.000.00782.990.00
Powell, Ian,2608564.470.000.000.0064.47
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Perez, Amber, D,13318214.260.000.00116.9197.35
Russell, Elijah, M,118354772.300.000.002319.262453.04
Bryant, Kyle,231644807.100.003578.271228.830.00
Davis, Richard, R,15549574.980.000.00574.980.00
Jones, Natalie, A,11845197.200.000.0082.26114.94
Taylor, Natalie, M,14338828.740.000.000.00828.74
Peterson, Brian,12892419.470.000.00156.27263.20
Martin, John, A,144364776.010.000.000.004776.01
Alexander, Jason,2932849.990.000.000.0049.99
Clark, Lauren,170341750.980.000.000.001750.98
Price, Marissa,15826160.740.000.00120.4840.26
Scott, Gabrielle,270614.990.000.000.004.99
Rivera, Rachel, S,2899678.980.000.000.0078.98
James, Christina,17409219.920.000.000.00219.92
Scott, Adam,15863243.010.000.00101.46141.55
Murphy, Chase, J,2472958.980.000.000.0058.98
Flores, Arianna,217274132.243578.270.000.00553.97
Moore, Hunter,14897196.270.000.0071.58124.69
Hall, Morgan,2172641.950.000.000.0041.95
Foster, Kayla,1969371.950.000.000.0071.95
Perez, Sydney, C,221174158.243578.270.000.00579.97
Bell, Alex, M,167543118.600.000.00756.332362.27
Jones, Nicole,14504112.270.000.000.00112.27
Coleman, Spencer,15993597.260.000.000.00597.26
Ross, Isabelle, D,18554155.450.000.00155.450.00
Green, Mackenzie, C,280737.280.000.000.007.28
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Nelson, Sierra,161322459.620.000.002459.620.00
Flores, Zachary, H,233765314.250.003578.271735.980.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Sanchez, Alex, K,131014736.030.000.002351.962384.07
Brown, Fernando,1900191.950.000.0069.9721.98
Morris, Abigail, C,287762.290.000.000.002.29
Hill, Jordan, J,16005198.730.000.00102.2796.46
Perry, Melissa,221284142.230.003578.270.00563.96
Bryant, Brittany,2254548.970.000.000.0048.97
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Cooper, Alexandra,19541131.240.000.000.00131.24
Ross, Anna, D,15494275.440.000.00149.97125.47
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Powell, Spencer,14904468.120.000.000.00468.12
Bradley, Jocelyn,230227.280.000.000.007.28
Brown, Isabella, L,266921266.860.00699.100.00567.76
Thomas, Matthew, K,13239185.700.000.000.00185.70
She, Martha, E,222515971.330.003578.270.002393.06
Green, Eric,2738069.990.000.000.0069.99
Green, Marcus, C,15974208.410.000.0091.95116.46
Williams, Austin,2035432.220.000.000.0032.22
Phillips, Adam, R,227484188.240.003578.270.00609.97
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Turner, Courtney, A,229753578.270.003578.270.000.00
Miller, Eduardo,14561158.840.000.0049.97108.87
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Butler, Trevor,2741569.990.000.0069.990.00
Hughes, Samantha,2721564.470.000.000.0064.47
Sanders, Allison, B,18852268.250.000.000.00268.25
Walker, Hunter,271007.280.000.007.280.00
Hall, Fernando,2210090.950.000.000.0090.95
Ramirez, Abigail, S,1585974.140.000.0024.2749.87
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Phillips, Luis, G,207347.280.000.000.007.28
Ortega, Byron,233064828.110.003578.271249.840.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Torres, Haley, W,232834828.110.003578.271249.840.00
Yang, Aaron, C,2519654.980.000.000.0054.98
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Simmons, Brittany,2923139.980.000.000.0039.98
Wilson, Fernando,16643126.960.000.0056.9769.99
Hughes, Destiny, P,28027119.980.000.000.00119.98
Harris, Megan,232814828.110.003578.271249.840.00
Anderson, Isabella,137432349.980.000.000.002349.98
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Rodriguez, Taylor,1607166.960.000.000.0066.96
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Bradley, Alexandria,176911779.470.000.000.001779.47
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Evans, Gabriel,2348789.970.000.000.0089.97
Harris, Isabella,17119214.900.000.00214.900.00
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Young, Julia, J,274144.990.000.000.004.99
Stewart, Cindy,14496804.480.000.000.00804.48
White, Cameron,238304802.110.003578.270.001223.84
Robinson, Zachary, L,137092332.280.000.000.002332.28
Washington, Vanessa,238194802.110.003578.270.001223.84
Brown, Morgan,2919778.980.000.000.0078.98
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Patterson, Eric, A,2738478.980.000.000.0078.98
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Roberts, Carlos,2319639.980.000.000.0039.98
Foster, Olivia,238063578.270.003578.270.000.00
Russell, Gail, L,212634.990.000.000.004.99
Thomas, Dylan,198737.280.000.007.280.00
Gonzalez, Morgan,130651700.990.000.000.001700.99
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Griffin, Julian, M,113284718.040.000.004718.040.00
Sanders, Angel,16219553.970.000.000.00553.97
Thompson, Abigail,243324816.090.003578.270.001237.82
Coleman, Stephanie,2226489.970.000.000.0089.97
Chander, Wayne, S,243444329.610.003578.27751.340.00
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Williams, Ian, M,175581750.470.000.000.001750.47
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Patterson, Maria, G,1333094.950.000.0079.9714.98
Alexander, Caroline,176541759.970.000.000.001759.97
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Stewart, Allison, R,18826166.430.000.0069.9996.44
Walker, Isabella,243864143.740.003578.27565.470.00
Moore, Wyatt, F,189712351.960.000.000.002351.96
She, Alisha, G,247574343.590.003578.270.00765.32
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Baker, Sean, T,247782858.490.002181.56676.930.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Miller, Alexis, A,12196124.930.000.0054.9669.97
Walker, John, M,2858969.990.000.0069.990.00
Hughes, Justin, M,181222439.990.000.000.002439.99
Thomas, Charles,250942443.350.002443.350.000.00
Perry, Ryan,132494795.340.000.002357.282438.06
Griffin, Madison, A,250932181.560.002181.560.000.00
Hughes, Julia,250612443.350.002443.350.000.00
Jai, Adam,250952443.350.002443.350.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Thomas, Emily,2180339.980.000.000.0039.98
Price, Stephanie,258922443.350.002443.350.000.00
Carter, Luis, E,258832443.350.002443.350.000.00

Generated 2024-09-20 05:38:10.012 UTC