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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Davis, Emily,27267782.990.000.00782.990.00
Turner, Eduardo,158764789.020.000.000.004789.02
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Barnes, Ian, M,16106133.540.000.000.00133.54
Patterson, Alexis,213484392.020.000.002049.102342.92
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Rodriguez, Taylor,1607166.960.000.000.0066.96
Foster, Abigail,1982346.470.000.000.0046.47
Ross, Alexia, S,13231247.900.000.000.00247.90
Watson, Victoria,16125588.960.000.000.00588.96
Foster, Trevor, J,2896469.990.000.000.0069.99
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Nathan, C,2463713.980.000.000.0013.98
Flores, Eduardo, S,2896962.980.000.000.0062.98
Jones, Zachary, J,27285782.990.000.00782.990.00
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Price, Mariah, C,2074549.480.000.000.0049.48
Kelly, Bryan,213492989.380.000.002989.380.00
Wilson, Fernando,16643126.960.000.000.00126.96
Baker, Ian, V,262002756.540.000.002181.56574.98
Butler, Trevor,2741569.990.000.0069.990.00
Collins, Hailey,11709325.890.000.0021.49304.40
Yang, Jordan, K,14458133.950.000.000.00133.95
Bradley, Alexandria,176911779.470.000.000.001779.47
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Coleman, Vanessa,215892589.090.000.002049.10539.99
Parker, Katherine,13268289.700.000.0068.97220.73
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Coleman, Miguel, D,2740069.990.000.0069.990.00
Stewart, Olivia, B,1874923.780.000.000.0023.78
Watson, Devin, A,18875114.950.000.000.00114.95
Ramirez, Sydney,267007.280.000.000.007.28
Diaz, Katherine, P,115262376.960.000.002376.960.00
Cooper, Grace, C,1601294.260.000.000.0094.26
Rogers, Shelby,11712127.800.000.0042.5985.21
Kelly, Trinity,2609515.230.000.000.0015.23
Wright, Jennifer,2650559.980.000.0059.980.00
Evans, Gabriel,2348789.970.000.000.0089.97
James, Zoe, R,14611304.550.000.000.00304.55
Hall, Amber,20106131.950.000.000.00131.95
White, Edward, J,15847205.460.000.000.00205.46
Cooper, Andrea,2932378.980.000.000.0078.98
Harris, Matthew,14330806.760.000.000.00806.76
Moore, Seth,138512331.950.000.000.002331.95
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Jai, Hunter, M,28272111.950.000.000.00111.95
Powell, Elijah, E,231135997.330.003578.270.002419.06
Clark, Joseph, D,153954780.020.000.000.004780.02
Hall, Wyatt,2382713.980.000.000.0013.98
Garcia, Anna, B,15572104.550.000.000.00104.55
Nath, Carl, H,29001624.970.000.000.00624.97
Price, Marissa,15826160.740.000.00120.4840.26
Li, Rafael, M,217527.280.000.000.007.28
Gonzales, Miranda,11660324.720.000.000.00324.72
Williams, Ethan,243094793.120.003578.270.001214.85
Rivera, Rachel, S,2899678.980.000.000.0078.98
Bell, Chase,180911750.980.000.000.001750.98
Hayes, Hannah, J,2165656.970.000.000.0056.97
Thomas, Dalton,230097.280.000.000.007.28
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Bailey, Jessica, L,12945218.440.000.000.00218.44
Brown, Anthony, J,19399151.430.000.000.00151.43
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Campbell, Gabriella,188411145.480.000.000.001145.48
Martin, John, A,144364776.010.000.000.004776.01
Lee, Ethan, J,223597.280.000.000.007.28
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Martinez, Jonathan,1330366.250.000.000.0066.25
Campbell, Adam, A,214002688.890.000.002071.42617.47
Flores, Kevin,15878225.920.000.0069.97155.95
Kelly, Angel, E,15418232.230.000.000.00232.23
Mehta, Carmen, C,2743694.480.000.000.0094.48
Nath, Kenneth, W,170372334.970.000.000.002334.97
Johnson, James,234984.990.000.000.004.99
Murphy, Richard, M,222994145.540.003578.270.00567.27
Brown, Isabella, L,266921266.860.00699.100.00567.76
Lee, Emma,16948176.430.000.000.00176.43
Bell, Gabrielle,223735976.320.003578.270.002398.05
Phillips, Adam, R,227484188.240.003578.270.00609.97
King, Morgan,196811179.970.000.000.001179.97
Thomas, Thomas,216292624.080.000.002049.10574.98
Turner, Courtney, A,229753578.270.003578.270.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Hughes, Samantha,2721564.470.000.000.0064.47
Reed, Erin, I,14353128.840.000.0074.9853.86
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Russell, Jacqueline,18391100.960.000.0078.9821.98
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Harris, Emily, P,1986298.480.000.000.0098.48
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Mitchell, Savannah,261153052.800.000.002443.35609.45
Washington, Vanessa,238194802.110.003578.270.001223.84
Rogers, Amanda, A,13920266.970.000.000.00266.97
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Anderson, Megan, A,238594153.250.003578.27574.980.00
Martin, Brianna, M,235834829.390.003578.270.001251.12
Thomas, Dylan,198737.280.000.000.007.28
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Hughes, Edward,200234530.470.003374.990.001155.48
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Allen, Aaron, A,200753399.990.003399.990.000.00
Richardson, Melissa, E,111322371.940.000.000.002371.94
Parker, Morgan, S,1677236.960.000.0014.9821.98
Miller, Alexis, A,12196124.930.000.000.00124.93
Walker, John, M,2858969.990.000.000.0069.99
Cooper, Ariana,17348205.420.000.000.00205.42
Watson, Emma,17481126.940.000.000.00126.94
Morris, Richard,2007039.980.000.000.0039.98
Powell, Jack, J,1841156.960.000.000.0056.96
Brown, Benjamin, D,151874725.320.000.000.004725.32
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Edwards, Connor,16950211.010.000.000.00211.01
Washington, Miranda,152014793.020.000.000.004793.02
Peterson, Alex, M,13423132.900.000.000.00132.90
Bradley, Melanie, G,133434720.270.000.000.004720.27
Cooper, Paige,14119148.940.000.000.00148.94
Wright, Jackson,11698225.950.000.000.00225.95
Powell, Lauren, E,1966275.970.000.000.0075.97
Wright, Kyle,2371626.970.000.000.0026.97
Isla, Julian, A,13732108.960.000.004.99103.97
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Evans, Luke,2917615.230.000.000.0015.23
Harris, Destiny, M,137102341.460.000.000.002341.46
Powell, Blake, J,2237139.980.000.000.0039.98
Sanders, Megan, A,15376136.240.000.000.00136.24
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Phillips, Miguel,2049812.940.000.000.0012.94
Washington, Thomas, C,2745137.430.000.000.0037.43
King, Caleb, J,2898678.980.000.000.0078.98
Carter, Madeline, A,2752269.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Bell, Alex, M,167543118.600.000.00756.332362.27
Green, Samuel, D,14096174.730.000.000.00174.73
Lewis, Morgan,17410168.740.000.000.00168.74
Anand, Brendan, L,1984721.980.000.000.0021.98
Patterson, Abigail, H,144784795.010.000.000.004795.01
Butler, Benjamin, C,189722369.970.000.000.002369.97
Flores, Julian,158464943.320.000.000.004943.32
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Hughes, Eduardo,15564188.520.000.000.00188.52
Sanders, Isaiah,2587339.980.000.000.0039.98
Parker, Amanda,1808151.970.000.000.0051.97
Peterson, Julia, P,16497132.710.000.000.00132.71
Sandberg, Chase,2190475.970.000.000.0075.97
Lee, Ian,19646197.040.000.000.00197.04
Watson, Cole, A,217684118.263578.270.000.00539.99
Moore, Wyatt, F,189712351.960.000.000.002351.96
Gonzales, Brittany,217104187.233578.270.000.00608.96
Walker, Isabella,243864143.740.003578.27565.470.00
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Hall, Lauren, A,19648100.840.000.000.00100.84
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Murphy, Juan, T,246463578.270.003578.270.000.00
James, Sara,198023374.993374.990.000.000.00
Bell, Danielle,140414765.020.000.000.004765.02
Alexander, Aidan,17387148.190.000.0056.9791.22
She, Alisha, G,247574343.590.003578.270.00765.32
Edwards, Eric,2462768.490.000.000.0068.49
Price, Riley, R,139094764.020.000.000.004764.02
Moreno, Meredith, D,2228589.970.000.000.0089.97
Washington, Ian, M,246644368.580.003578.270.00790.31
Hall, Morgan,2172641.950.000.000.0041.95
Hall, Noah, A,1525175.250.000.000.0075.25
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Long, Caleb, P,250462181.560.002181.560.000.00
Long, Natalie,14363192.340.000.000.00192.34
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Ye, Alisha, J,220084141.233578.270.000.00562.96
Garcia, Carmen, J,247812181.560.002181.560.000.00
Martin, Lucas, L,221144183.233578.270.000.00604.96
Rowe, Todd,14586233.940.000.000.00233.94
Long, Gabrielle,198305765.923374.990.000.002390.93
Wood, Alexandria, M,248242181.560.002181.560.000.00
Flores, Zachary, H,233765314.250.003578.270.001735.98
Price, Oscar, G,11833240.010.000.000.00240.01
Bailey, Richard, N,220504160.533578.270.000.00582.26
Adams, Haley, M,247862443.350.002443.350.000.00
Murphy, Emma,198445807.930.003374.990.002432.94
Peterson, Xavier, R,2645639.980.000.000.0039.98
Moreno, Renee, C,12936265.220.000.000.00265.22
Richardson, Victoria, C,248172181.560.002181.560.000.00
Williams, Ryan, R,222475978.610.003578.270.002400.34
Martinez, Carol, D,17656578.460.000.000.00578.46
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Jai, Adam,250952443.350.002443.350.000.00
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Bell, Julia,216522646.060.000.002646.060.00
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Huang, Kristen,251002443.350.002443.350.000.00
Sanchez, Alex, K,131014736.030.000.000.004736.03
Rogers, Jade, I,14332102.250.000.000.00102.25
Parker, Jennifer, D,221184158.240.003578.270.00579.97
White, Jennifer, S,27027782.990.00782.990.000.00
Morris, Abigail, C,287762.290.000.000.002.29
Winston, Ethan, R,216222612.060.000.002049.10562.96
Watson, Shelby, J,14911867.970.000.000.00867.97
Gray, Alexandria, E,253632443.350.002443.350.000.00
Smith, John,198555709.960.003399.990.002309.97
Brooks, Victoria, H,16479158.510.000.000.00158.51
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Lazecky, Petr,258642443.350.002443.350.000.00
Campbell, Hunter,17422174.920.000.000.00174.92
Powell, David, W,266151000.440.000.001000.440.00
Perry, Melissa,221284142.230.003578.270.00563.96
Price, Stephanie,258922443.350.002443.350.000.00
Turner, Sean,227324133.240.003578.270.00554.97
Parker, Jordan,216212616.860.000.002049.10567.76
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Carter, Luis, E,258832443.350.002443.350.000.00
Davis, Nicholas,1320173.160.000.000.0073.16
Patterson, Grace, M,27560782.990.000.00782.990.00
Rogers, Sara,198744544.450.003374.990.001169.46
Cook, Steven, J,27053782.990.00782.990.000.00
Wilson, Nathan, L,13936218.930.000.000.00218.93
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Carter, Marcus, l,2147131.970.000.000.0031.97
Coleman, Lucas, A,27060782.990.000.00782.990.00
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Wilson, Victoria, R,27536782.990.000.00782.990.00
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Sanders, Alexandra,259112181.560.000.002181.560.00
She, Martha, E,222515971.330.003578.270.002393.06
Blue, Marcus, L,27550782.990.000.00782.990.00
Miller, Joseph, A,227134148.190.003578.270.00569.92
Russell, Fernando,27084782.990.000.00782.990.00
Washington, Christian, R,2668639.980.000.000.0039.98
Gray, Isabella,168203217.790.000.000.003217.79
Moore, Taylor, A,199874564.450.003374.990.001189.46
Walker, Brandon, J,159164793.270.000.000.004793.27
Lewis, Seth,26782699.100.00699.100.000.00
Alexander, Sarah,1941129.990.000.000.0029.99
Ross, Antonio,18322148.890.000.000.00148.89
Bryant, Gabriel,2765669.990.000.000.0069.99
Collins, Luis, J,227655978.610.003578.270.002400.34
Griffin, Marcus,2075634.560.000.000.0034.56
Howard, Morgan, T,229713578.270.003578.270.000.00
Bryant, Brittany,2254548.970.000.000.0048.97
Nelson, Adam, B,27402128.970.000.000.00128.97
Perry, Justin, E,167583062.340.000.000.003062.34
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Cooper, Alexandra,19541131.240.000.000.00131.24
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Blue, Melanie, L,178611749.960.000.000.001749.96

Generated 2024-11-10 05:21:35.408 UTC