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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Smith, Eduardo,2069139.980.000.0039.980.00
Bryant, Zachary,216552648.070.000.002648.070.00
Powell, Sydney, M,14886539.990.000.00539.990.00
Lewis, Christopher,1875586.960.000.0086.960.00
Jai, Jose,12944164.210.000.0039.99124.22
Gonzales, Paige,2170291.940.000.0039.9851.96
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Stewart, Cody, A,212843223.580.000.002049.101174.48
Miller, Joseph, A,227134148.190.003578.270.00569.92
Russell, Katherine,2877169.990.000.000.0069.99
Anderson, Ashley,206803219.580.000.002049.101170.48
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Gray, Jared, A,264494.990.000.004.990.00
Srini, Ruben,18078200.940.000.0071.97128.97
Hughes, Antonio, P,15913712.270.000.00712.270.00
Alexander, Aidan,17387148.190.000.0094.2453.95
Cooper, Brooke,195361120.490.000.000.001120.49
Cooper, Amanda, P,146064716.020.000.000.004716.02
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Edwards, Amber, B,2051776.970.000.000.0076.97
Allen, Angel, G,15571101.850.000.0034.8966.96
Townsend, Bryan,14077180.730.000.000.00180.73
Flores, Emma, P,15543180.940.000.000.00180.94
Thompson, Xavier, R,15761192.410.000.000.00192.41
Russell, Xavier,12964119.950.000.000.00119.95
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Brooks, Victoria, H,16479158.510.000.000.00158.51
Adams, Miguel,11659213.520.000.000.00213.52
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Reed, Erin, I,14353128.840.000.0074.9853.86
Sanchez, Grace,120802354.990.000.000.002354.99
Hill, Katherine, L,2670139.980.000.000.0039.98
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Young, Kaylee, S,13756298.490.000.0058.47240.02
Allen, Sean, L,12097159.220.000.000.00159.22
Patterson, Eduardo,11142866.810.000.0072.26794.55
Bailey, Lauren,15864103.550.000.000.00103.55
Zeng, Jake,18054106.930.000.000.00106.93
Russell, Samuel, V,11652310.930.000.000.00310.93
Rogers, Amanda, A,13920266.970.000.000.00266.97
Jenkins, Austin, D,15748296.910.000.000.00296.91
Griffin, Xavier,228775962.340.003578.270.002384.07
Flores, Xavier,238664828.110.003578.270.001249.84
Brown, Julia,18065155.470.000.000.00155.47
Ross, Seth, M,184332329.980.000.000.002329.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Garcia, Patricia,11651226.430.000.0099.97126.46
Reed, Sean, L,145974803.310.000.000.004803.31
Adams, Gabriel, S,195271219.450.000.000.001219.45
Foster, Paige,2742894.480.000.000.0094.48
She, Alisha, G,247574343.590.003578.270.00765.32
Henderson, Luke,19200109.240.000.000.00109.24
Garcia, Anna, B,15572104.550.000.000.00104.55
Collins, Hailey,11709325.890.000.0021.49304.40
Johnson, Ian, E,2173283.470.000.000.0083.47
Flores, Morgan,19817118.940.000.0039.9878.96
Washington, Emma,191231170.480.000.000.001170.48
Butler, Victoria,132844767.530.000.000.004767.53
Hughes, Zachary,12203157.910.000.000.00157.91
Davis, Austin, E,133664749.040.000.000.004749.04
Jackson, Charles, P,112771305.660.000.00237.821067.84
Ramos, Derrick,18449100.940.000.0030.9769.97
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Thompson, Jose,237314828.110.003578.270.001249.84
Turner, Timothy, C,14641119.860.000.000.00119.86
Srini, Evelyn,16855150.950.000.000.00150.95
Morgan, Isabella, L,28602144.470.000.000.00144.47
King, Sara,2235439.980.000.000.0039.98
Russell, Isabella, A,11507645.780.000.0028.48617.30
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Price, Isabelle,201825749.970.003374.990.002374.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Moore, Andrew, A,13944150.130.000.0036.27113.86
Fernandez, Cesar,200355694.980.003374.990.002319.99
Garcia, Victoria, V,245013578.270.003578.270.000.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Serrano, Albert, E,133284708.020.000.000.004708.02
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Griffin, Madison, A,250932181.560.002181.560.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Cooper, Ariana,17348205.420.000.000.00205.42
Barnes, Fernando,113001390.550.000.00248.381142.17
Reed, Judith, D,2534759.980.000.000.0059.98
Parker, Blake,15008170.530.000.0074.9895.55
Hughes, Julia,250612443.350.002443.350.000.00
Carter, Jason,11724210.090.000.00113.8696.23
Sharma, Thomas, A,18637121.940.000.0091.9529.99
White, Abigail, T,15866145.820.000.0038.88106.94
Turner, Amanda, L,203183241.900.002071.420.001170.48
Chavez, Kara, P,13285214.350.000.0012.94201.41
Zhao, Karen, L,254082735.530.002181.560.00553.97
Jenkins, Megan, R,12074261.380.000.000.00261.38
Gomez, Renee, L,253712181.560.002181.560.000.00
Morris, Richard,2007039.980.000.000.0039.98
Clark, Anthony,27071782.990.00782.990.000.00
Howard, Isaiah,259813018.330.002443.350.00574.98
Chen, Jackson, S,270751371.950.00782.990.00588.96
Cook, Steven, J,27053782.990.00782.990.000.00
Coleman, Lucas, A,27060782.990.00782.990.000.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Taylor, Zachary, M,27082782.990.000.00782.990.00
Wright, Kyle,2371626.970.000.000.0026.97
Lopez, Isaiah,18968151.430.000.000.00151.43
Jones, Joshua,184012294.990.000.000.002294.99
Ross, Rachel, C,206693169.590.000.002049.101120.49
Diaz, Angela, K,27259782.990.000.00782.990.00
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Russell, Megan,16220562.960.000.000.00562.96
Evans, Luke,2917615.230.000.000.0015.23
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Washington, Taylor,212664525.070.000.002049.102475.97
Ward, Nicole, L,212724435.380.000.002071.422363.96
Davis, Emily,27267782.990.000.00782.990.00
Bailey, Hailey, R,262704.990.000.000.004.99
Brooks, Bryce,12061140.170.000.00112.2527.92
Patterson, Alexis,213484392.020.000.002049.102342.92
Price, Nicole, N,15815141.830.000.000.00141.83
Young, Adam,12984200.200.000.00107.2692.94
Parker, Katherine,13268289.700.000.0068.97220.73
Adams, Connor,214232888.560.000.002049.10839.46
Carter, Sydney,12959203.920.000.000.00203.92
Ward, Juan, H,215952649.560.000.002049.10600.46
Bryant, Nathan,2145059.980.000.000.0059.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Lewis, Isabella,2624267.930.000.000.0067.93
Hall, Kyle, J,1749169.970.000.000.0069.97
Lopez, Katelyn,11820232.710.000.0060.47172.24
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Garcia, Jonathan,1888386.960.000.0029.9956.97
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Gonzales, Brittany,217104187.233578.270.000.00608.96
Sharma, Jackson,16876151.840.000.000.00151.84
Russell, Samantha,11211723.560.000.00118.46605.10
Coleman, Jose, S,253494.990.000.000.004.99
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Foster, Trevor, J,2896469.990.000.000.0069.99
Garcia, Henry, B,112871009.240.000.00234.49774.75
Sanders, Megan, A,15376136.240.000.000.00136.24
Jenkins, Samantha,113311290.330.000.00410.31880.02
Griffin, Isabelle,249864.990.000.000.004.99
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Collins, Xavier, C,16646250.910.000.000.00250.91
Bell, Julia,216522646.060.000.002646.060.00
Turner, Mary,220154.990.000.000.004.99
Powell, Jordyn, K,153914828.010.000.000.004828.01
Russell, Jessica,265721000.440.000.001000.440.00
Chandra, Allen,2932753.990.000.000.0053.99
Phillips, Miguel,2049812.940.000.000.0012.94
Powell, David, W,266151000.440.000.001000.440.00
Nelson, Katherine,2802178.980.000.000.0078.98
Martin, Samuel,15874225.440.000.0069.99155.45
Parker, Jordan,216212616.860.000.002049.10567.76
Diaz, Jason,17374206.630.000.0089.46117.17
Taylor, Christian,2076456.760.000.000.0056.76
Moore, Fernando,265821000.440.000.001000.440.00
Lewis, Morgan,17410168.740.000.000.00168.74
Smith, Justin, P,1982721.980.000.000.0021.98
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Russell, Richard,2763322.260.000.000.0022.26
Ward, Jade, D,14661195.020.000.000.00195.02
James, Timothy,213312670.890.000.002670.890.00
Taylor, Taylor,159054899.020.000.000.004899.02
Smith, Samuel, D,2308349.900.000.000.0049.90
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Walker, Brandon, J,159164793.270.000.000.004793.27
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Torres, Pedro, E,16958168.020.000.00153.0414.98
Walker, Jasmine,134604693.040.000.000.004693.04
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Walker, Hunter,271007.280.000.000.007.28
Morgan, Juan, C,1882191.970.000.000.0091.97
Peterson, Jared,11502829.370.000.00171.95657.42
Anderson, Lucas,2926639.980.000.000.0039.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Green, Chloe, J,1465892.820.000.000.0092.82
Long, Xavier,112512318.960.000.000.002318.96
Jai, Logan, H,12031769.490.000.000.00769.49
Gonzales, Kayla,214947.280.000.000.007.28
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Alexander, Lauren,189502351.960.000.000.002351.96
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Price, Miranda,26629699.10699.100.000.000.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Ross, Alexia, S,13231247.900.000.000.00247.90
Long, Gabrielle,198305765.923374.990.000.002390.93
Hill, Carlos,12919257.880.000.00158.9398.95
Cooper, Andrea,2932378.980.000.000.0078.98
Long, Natalie,14363192.340.000.000.00192.34
Martin, Brandon, S,2169139.980.000.000.0039.98
Cox, Devin, C,134184768.050.000.000.004768.05
Sanchez, Martin, E,216317.280.000.000.007.28
Coleman, Joan, W,2669964.470.000.000.0064.47
Davis, Ethan,136604750.010.000.000.004750.01
Martin, Lucas, L,221144183.233578.270.000.00604.96
Foster, Edward, R,18355150.950.000.000.00150.95
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Powell, Vanessa,26630699.100.00699.100.000.00
Scott, Sean, F,2475539.980.000.000.0039.98
Long, Jordan,199884555.470.003399.990.001155.48
Watson, Shelby, J,14911867.970.000.000.00867.97
Foster, Isabel, M,2174571.950.000.000.0071.95
Price, Marissa,15826160.740.000.00120.4840.26
Campbell, Hunter,17422174.920.000.000.00174.92
Anderson, Isabella,137432349.980.000.000.002349.98
Garcia, Christian, J,164913106.330.000.00751.342354.99
Reed, Bryan,18884133.930.000.000.00133.93
Phillips, Kyle,12158202.200.000.000.00202.20
Robinson, Zachary, L,137092332.280.000.000.002332.28
Turner, Sean,227324133.240.003578.270.00554.97
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Simmons, Jennifer,112621010.560.000.00207.93802.63
Smith, Katherine, J,13197105.190.000.000.00105.19
Bradley, Alexandria,176911779.470.000.000.001779.47
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Brooks, Makayla,222526047.320.003578.270.002469.05
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Brown, Morgan,2919778.980.000.000.0078.98
Ross, Natalie, J,12916261.220.000.000.00261.22
Chen, Jonathan, G,13096200.690.000.000.00200.69
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Perry, Oscar,227856029.570.003578.272451.300.00
Lee, Don,188392384.970.000.000.002384.97
Allen, Luke,113162349.980.000.002349.980.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Miller, Eduardo,14561158.840.000.0049.97108.87
King, Aaron, L,117394758.030.000.002359.982398.05
Collins, Luis, J,227655978.610.003578.270.002400.34
Evans, Gabriel,2348789.970.000.000.0089.97
Alexander, Luke,290432447.050.000.002447.050.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Nelson, Sierra,161322459.620.000.002459.620.00
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Allen, Jack, M,291372419.060.000.002419.060.00
Long, Julia, R,228895971.330.003578.270.002393.06
Powell, Caleb, G,216132610.580.000.002049.10561.48
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Stewart, Hailey,229036054.220.003578.270.002475.95
Brooks, Mariah,216202620.400.000.002071.42548.98
Gonzales, Luis,15856116.250.000.0037.2778.98
Gill, Beth,199975814.980.003374.990.002439.99
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52

Generated 2025-10-31 21:08:11.295 UTC