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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Sanders, Allison, B,18852268.250.000.000.00268.25
Hall, Fernando,2210090.950.000.000.0090.95
Henderson, Ashley,111851381.370.000.00262.781118.59
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Foster, Isabel, M,2174571.950.000.000.0071.95
Morgan, Jada, A,11520702.990.000.00300.89402.10
Robinson, William,20103103.480.000.00103.480.00
Lal, Robert, L,14084138.680.000.0035.00103.68
Miller, Alexis, A,12196124.930.000.0054.9669.97
Cox, Devin, C,134184768.050.000.002329.992438.06
Price, Riley, R,139094764.020.000.002344.962419.06
Hall, Noah, A,1525175.250.000.0068.976.28
Lewis, Ryan, A,203124.990.000.004.990.00
Diaz, Thomas, O,16020595.960.000.00595.960.00
Bradley, Melanie, G,133434720.270.000.002319.262401.01
Robinson, Zachary, L,137092332.280.000.000.002332.28
Gonzales, Melissa, W,204704408.690.002071.420.002337.27
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Clark, Joseph, D,153954780.020.000.000.004780.02
Phillips, Kyle,12158202.200.000.000.00202.20
Lee, Alexander, S,18356149.910.000.000.00149.91
Jenkins, Megan, R,12074261.380.000.000.00261.38
Ross, Alexia, S,13231247.900.000.00104.97142.93
Sun, Arturo, C,11498557.540.000.00173.39384.15
Fernandez, Ruth,205463246.550.002049.100.001197.45
Williams, Zachary, B,27099782.990.000.00782.990.00
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Perry, Marcus, L,206563245.900.000.002071.421174.48
Jai, Connor, D,27253782.990.000.00782.990.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Carter, Bailey,213322616.860.000.002616.860.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Perez, Angel, S,213362628.350.000.002628.350.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Hall, Elizabeth, L,13474339.480.000.0068.97270.51
Patterson, Hailey, I,112231155.900.000.00465.56690.34
Gonzales, Miranda,11660324.720.000.0037.27287.45
Ramirez, Makayla, L,1750998.720.000.0037.2761.45
Lee, William,13185149.840.000.0074.9674.88
Johnson, Christopher,119794813.760.000.004813.760.00
Sanders, Hailey,19647282.040.000.0039.98242.06
Davis, Ethan,136604750.010.000.000.004750.01
Griffin, Jason, L,112001267.110.000.00610.74656.37
Wilson, Tyler, L,15879196.930.000.0069.99126.94
Alexander, Jason,2932849.990.000.000.0049.99
Reed, Bryan,18884133.930.000.000.00133.93
Thomas, David,168363193.790.000.000.003193.79
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Alexander, Julia, J,15291889.470.000.000.00889.47
Flores, Kevin,15878225.920.000.0069.97155.95
Anand, Brendan, L,1984721.980.000.000.0021.98
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Gonzalez, James, M,188421155.480.000.001155.480.00
Luo, Franklin, J,2202759.980.000.000.0059.98
Hall, Jan, M,11740334.120.000.00235.1598.97
Thomas, Logan, A,14091251.200.000.0053.99197.21
Roberts, Seth, H,11510258.150.000.0039.47218.68
Brooks, Ian, W,2829064.470.000.000.0064.47
Miller, Sydney, A,134404818.530.000.000.004818.53
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Hayes, Luis,12880200.730.000.000.00200.73
Phillips, Devin,18759112.060.000.000.00112.06
Morgan, Marcus, W,289682.290.000.000.002.29
Simmons, Sarah, V,11500651.980.000.00155.22496.76
Powell, Spencer,14904468.120.000.000.00468.12
Carter, Katherine,11861286.300.000.000.00286.30
Clark, Emily, R,120862294.990.000.000.002294.99
Rodriguez, Richard,12969180.790.000.000.00180.79
Jenkins, Samantha,113311290.330.000.00542.74747.59
Jai, Jose,12944164.210.000.0039.99124.22
Watson, Marcus,2271585.480.000.000.0085.48
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Russell, Isabella, A,11507645.780.000.00181.91463.87
Taylor, Christian,2076456.760.000.000.0056.76
Price, Oscar, G,11833240.010.000.000.00240.01
Walker, Thomas,1307193.980.000.000.0093.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Chen, Jonathan, G,13096200.690.000.000.00200.69
Griffin, Haley, L,1892582.180.000.000.0082.18
Taylor, Natalie, M,14338828.740.000.000.00828.74
Martin, John, A,144364776.010.000.000.004776.01
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Ward, Cole,214907.280.000.000.007.28
Griffin, Marcus,2075634.560.000.000.0034.56
Murphy, Chase, J,2472958.980.000.000.0058.98
Kelly, Angel, E,15418232.230.000.0042.28189.95
Moore, Hunter,14897196.270.000.0071.58124.69
Robinson, Dylan, L,1472481.530.000.000.0081.53
Long, Kaitlyn,233964891.610.003578.270.001313.34
White, Cameron,238304802.110.003578.270.001223.84
Lopez, Katelyn,11820232.710.000.0092.74139.97
Diaz, Elijah,200004495.480.003374.990.001120.49
Washington, Hailey, S,2588559.980.000.000.0059.98
Davis, Thomas,167641760.470.000.000.001760.47
Young, Adam,12984200.200.000.00107.2692.94
Wilson, Nathan, L,13936218.930.000.000.00218.93
Jai, Samuel, L,1635887.950.000.0073.9713.98
Green, Mackenzie, C,280737.280.000.000.007.28
Reed, Isaac, D,260747.280.000.000.007.28
Watson, Richard,15943365.410.000.00154.98210.43
Jones, Charles,22882101.450.000.000.00101.45
James, Maria,1624391.970.000.0069.9921.98
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Henderson, Hailey, C,171481775.470.000.000.001775.47
Lopez, Isaiah,18968151.430.000.000.00151.43
Hayes, Dalton, C,188822322.280.000.000.002322.28
Johnson, Jacob, I,28069553.970.000.000.00553.97
Flores, Devin, A,15559172.040.000.0086.5685.48
Price, Devin, M,18758158.510.000.0073.5584.96
Hu, Gilbert, L,2876769.990.000.000.0069.99
Carter, Isaac,137191129.480.000.000.001129.48
Lal, Kyle,17360122.180.000.000.00122.18
Reed, Megan, A,181181750.980.000.000.001750.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Smith, Austin,13707149.050.000.000.00149.05
Walker, Charles,11677298.210.000.0021.49276.72
Roberts, Jordan, M,1680039.250.000.000.0039.25
Taylor, Madison, A,11802215.290.000.00155.7359.56
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Watson, Victoria,16125588.960.000.000.00588.96
Phillips, Luis, G,207347.280.000.000.007.28
Martinez, Andrew, C,11530523.810.000.00194.86328.95
Hughes, Eduardo,15564188.520.000.000.00188.52
Yang, Justin, S,153634719.040.000.000.004719.04
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Watson, Shelby, J,14911867.970.000.000.00867.97
Young, Sierra, J,11619634.840.000.00187.43447.41
Washington, Christian, R,2668639.980.000.000.0039.98
Reed, Sean, L,145974803.310.000.000.004803.31
Flores, Arianna,217274132.243578.270.000.00553.97
Thompson, Ryan, M,113301111.360.000.00198.94912.42
James, Sara,198023374.993374.990.000.000.00
Green, Isabella,26620699.10699.100.000.000.00
Alexander, Aidan,17387148.190.000.00148.190.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Martin, Lucas, L,221144183.233578.270.000.00604.96
Murphy, Emma,198445807.933374.990.000.002432.94
Davis, James,11922275.500.000.0094.96180.54
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Morris, Abigail, C,287762.290.000.000.002.29
Martin, Xavier,222335997.330.003578.270.002419.06
Diaz, Luis, D,11203801.770.000.00317.50484.27
Sandberg, Isaac,1335053.970.000.0039.9913.98
Henderson, Gabrielle, B,186031205.470.000.001205.470.00
Lewis, Seth,26782699.100.00699.100.000.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Chapman, Nancy, E,11276840.150.000.00156.71683.44
King, Morgan,196811179.970.000.000.001179.97
Collins, Luis, J,227655978.610.003578.270.002400.34
Moore, Taylor, A,199874564.450.003374.990.001189.46
Turner, Courtney, A,229753578.270.003578.270.000.00
Long, Brandon, M,16110650.470.000.000.00650.47
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Green, Gabrielle, M,2181564.470.000.0064.470.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
She, Kenneth,16096212.010.000.0080.96131.05
Russell, Jacqueline,18391100.960.000.00100.960.00
Ramirez, Abigail, S,1585974.140.000.0024.2749.87
Moore, Andrew, A,13944150.130.000.00107.8542.28
Parker, Morgan, S,1677236.960.000.0014.9821.98
James, Jeremiah, S,11661287.700.000.00104.97182.73
Lal, Luke, L,11019698.230.000.00156.20542.03
Murphy, Catherine, L,1650692.050.000.0030.9761.08
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Davis, Daniel,11711999.220.000.00100.46898.76
Harris, Isabella,17119214.900.000.00214.900.00
Parker, Blake,15008170.530.000.0074.9895.55
Young, Julia, J,274144.990.000.000.004.99
White, Abigail, T,15866145.820.000.0038.88106.94
Smith, Katherine, J,13197105.190.000.0049.9755.22
Perry, Ana,112151155.520.000.00496.36659.16
Thomas, Emily,2180339.980.000.000.0039.98
Wright, Robert, C,158894848.030.000.000.004848.03
Turner, Timothy, C,14641119.860.000.0049.9769.89
Patterson, Maria, G,1333094.950.000.0079.9714.98
Allen, Amanda,2235339.980.000.000.0039.98
Bryant, Samantha,18345115.470.000.000.00115.47
Richardson, Melissa, E,111322371.940.000.002371.940.00
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Walker, John, M,2858969.990.000.0069.990.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Cooper, Ariana,17348205.420.000.000.00205.42
Garcia, Patricia,11651226.430.000.00134.9591.48
Morgan, Timothy,14633242.500.000.0095.55146.95
Moore, Matthew, W,13267109.950.000.0074.9834.97
Cook, Bryce,2864069.990.000.000.0069.99
Carter, Sydney,12959203.920.000.000.00203.92
Prasad, Molly,243924329.610.003578.27751.340.00
Lopez, Carlos,186171147.770.000.001147.770.00
Edwards, Connor,16950211.010.000.0023.97187.04
Morris, Alyssa,28072548.980.000.000.00548.98
Cook, Megan, J,2029956.970.000.0056.970.00
Deng, Damien, A,16873578.460.000.000.00578.46
Peterson, Jessica, M,11868247.010.000.0076.95170.06
Anderson, Emma, A,185801170.480.000.001170.480.00
Russell, Megan,16220562.960.000.000.00562.96
Sanchez, Adrian, L,13179190.170.000.0077.92112.25
Thomas, Victoria, A,15536249.530.000.000.00249.53
Bailey, Hailey, R,262704.990.000.000.004.99
Davis, Marcus, T,17337123.910.000.0086.9536.96
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Parker, Katherine,13268289.700.000.0068.97220.73
Torres, Mariah,16380195.950.000.000.00195.95
Gonzales, Luis,15856116.250.000.00116.250.00
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Lopez, Jack, I,2904751.460.000.000.0051.46
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
Washington, Caroline, D,231145996.320.003578.270.002418.05
Wright, Kyle,2371626.970.000.0026.970.00
Bryant, Kyle,231644807.100.003578.271228.830.00
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Ward, Ian,12056213.920.000.000.00213.92
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Harris, Megan,232814828.110.003578.271249.840.00
Ware, Dennis, L,237254828.110.003578.270.001249.84
Coleman, Isabel, S,12530337.900.000.00193.95143.95
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Bryant, Connor,238424828.110.003578.270.001249.84
Washington, Vanessa,238194802.110.003578.270.001223.84
Thompson, Jose,237314828.110.003578.270.001249.84
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Thompson, Isabella,18756128.410.000.000.00128.41
Brown, Samantha, G,2514739.980.000.000.0039.98
Martinez, Jill,242354829.390.003578.270.001251.12
Phillips, James, G,16846180.950.000.00180.950.00
Flores, Xavier,238664828.110.003578.270.001249.84
James, Christina,17409219.920.000.000.00219.92
Bennett, Seth,244933578.270.003578.270.000.00
Watson, Janet, S,2320859.980.000.000.0059.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Henderson, Luke,19200109.240.000.000.00109.24
Garcia, Victoria, V,245013578.270.003578.270.000.00
Campbell, Jordan,13290111.890.000.0074.9836.91
Li, Connor,201863191.910.002071.420.001120.49
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Gomez, Rebekah,13486225.440.000.0039.98185.46
Turner, Andrea, A,202093268.550.002049.100.001219.45
Carter, Madeline, A,2752269.990.000.000.0069.99
Martin, Morgan,248322181.560.002181.560.000.00

Generated 2024-09-19 23:53:25.805 UTC