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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Austin, P,183681754.980.000.000.001754.98
James, Bryce,13466133.450.000.000.00133.45
Hughes, Samantha,2721564.470.000.000.0064.47
Anderson, Ashley,206803219.580.000.002049.101170.48
Harris, Anthony,2144721.980.000.000.0021.98
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Morgan, Isabella, L,28602144.470.000.000.00144.47
Martinez, Grace, M,17385208.690.000.0069.97138.72
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Phillips, Kyle,12158202.200.000.000.00202.20
Powell, Jonathan,238584712.740.003578.271134.470.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Reed, Paige,221126047.320.003578.272469.050.00
Flores, Xavier,238664828.110.003578.270.001249.84
Cooper, Paige,14119148.940.000.000.00148.94
Morris, Richard,2007039.980.000.000.0039.98
Umeda, Masaki,16717233.810.000.000.00233.81
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Griffin, Jordan,13095328.890.000.0069.97258.92
Foster, Aaron,155664912.470.000.000.004912.47
Diaz, Luis, D,11203801.770.000.00124.99676.78
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Simmons, Anna, K,124512367.920.000.000.002367.92
Ward, Natalie, J,132412325.960.000.000.002325.96
Martinez, Carol, D,17656578.460.000.000.00578.46
Sharma, Thomas, A,18637121.940.000.000.00121.94
Hall, Lauren, A,19648100.840.000.000.00100.84
Ross, Kaitlyn,16121614.470.000.000.00614.47
Zhao, Karen, L,254082735.530.002181.560.00553.97
Robinson, Abigail, R,183792362.270.000.000.002362.27
Patterson, Grace, M,27560782.990.000.00782.990.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Lewis, Morgan,17410168.740.000.000.00168.74
Rogers, Sean, G,18685124.460.000.000.00124.46
Rogers, Shelby,11712127.800.000.0042.5985.21
Watson, Devin, A,18875114.950.000.000.00114.95
Adams, Haley, M,247862443.350.002443.350.000.00
Wright, Carol, C,12928247.410.000.0033.98213.43
Ward, Lucas, N,183631700.990.000.000.001700.99
Jai, Connor, D,27253782.990.000.00782.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Parker, James,11808610.190.000.000.00610.19
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Wang, Austin, A,1463284.970.000.009.9974.98
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Campbell, Chloe,11212760.930.000.00231.72529.21
Diaz, Jason,17374206.630.000.0089.46117.17
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Yuan, Leonard, F,167911729.970.000.000.001729.97
Smith, Nathan,217647.280.000.007.280.00
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Lee, Ethan, J,223597.280.000.000.007.28
Baker, Allison,2649558.980.000.000.0058.98
Ross, Aaron, N,118882376.960.000.002376.960.00
Yang, Jordan, K,14458133.950.000.000.00133.95
Anderson, Isabella,137432349.980.000.000.002349.98
Morgan, Angela,24665109.970.000.000.00109.97
Reed, Mariah,263731565.910.000.001000.44565.47
Smith, Eduardo,2069139.980.000.0039.980.00
Flores, Julian,158464943.320.000.000.004943.32
Alexander, Aidan,17387148.190.000.0056.9791.22
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Hughes, Miranda,266784.990.000.000.004.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Simmons, Brittany,2923139.980.000.000.0039.98
Cooper, Stephanie,249762181.560.002181.560.000.00
Perez, Jordan, A,292674.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Walker, Isabella,243864143.740.003578.27565.470.00
Bennett, Maria, G,229837.280.000.000.007.28
Turner, Timothy, C,14641119.860.000.000.00119.86
Li, Jordan,17026261.390.000.00261.390.00
Brooks, Allison,146054750.010.000.000.004750.01
Wright, Jennifer,2650559.980.000.0059.980.00
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Richardson, Evan, J,15488165.300.000.000.00165.30
Hill, Sydney,264821000.440.000.001000.440.00
Phillips, Miguel,2049812.940.000.000.0012.94
Phillips, James, G,16846180.950.000.00123.9856.97
Perez, Timothy, L,227304.990.000.000.004.99
Peterson, Steven, L,234497.280.000.007.280.00
Campbell, Gabriella,188411145.480.000.000.001145.48
Chander, Wayne, S,243444329.610.003578.27751.340.00
Price, Marissa,15826160.740.000.00120.4840.26
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Isabelle,233974828.110.003578.270.001249.84
Adams, Carlos,1982236.960.000.000.0036.96
Torres, Abigail,253674.990.000.000.004.99
Zhang, Heather,166543056.320.000.00751.342304.98
Clark, Miguel, D,169872414.990.000.000.002414.99
Flores, Madison,14416769.490.000.000.00769.49
Washington, Hailey, S,2588559.980.000.000.0059.98
Ramirez, Richard, C,282397.280.000.007.280.00
Jai, Logan, H,12031769.490.000.000.00769.49
Harris, Samuel, M,2477159.980.000.0059.980.00
Lee, John,19801193.010.000.000.00193.01
Cooper, Brianna,2592513.980.000.000.0013.98
Smith, John,198555709.960.003399.990.002309.97
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Scott, Adam,15863243.010.000.000.00243.01
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Rogers, Carlos,19645134.440.000.000.00134.44
Wang, Benjamin, R,274547.280.000.000.007.28
Clark, Zachary, J,2389358.980.000.000.0058.98
Stewart, Allison, R,18826166.430.000.0069.9996.44
Jackson, Hannah, G,131432404.970.000.000.002404.97
Powell, Elijah, E,231135997.330.003578.270.002419.06
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Lee, Emma,16948176.430.000.000.00176.43
Roberts, Amber, W,215822638.060.000.002049.10588.96
Bailey, Hailey, R,262704.990.000.000.004.99
Gray, Sara,292472447.050.000.002447.050.00
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Scott, Mason,2355139.980.000.000.0039.98
Mitchell, Maria, D,27404782.990.000.00782.990.00
Alexander, Julia, J,15291889.470.000.000.00889.47
Price, Jocelyn, D,258752443.350.002443.350.000.00
Ross, Miranda,145984839.000.000.000.004839.00
Chen, Luis, G,2125294.450.000.0094.450.00
Lewis, Isabella,2624267.930.000.000.0067.93
Lopez, Carlos,186171147.770.000.000.001147.77
Gray, Marcus, T,183892401.450.000.000.002401.45
Evans, James, C,206654408.560.000.002049.102359.46
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Hill, Timothy,14871848.470.000.000.00848.47
Rogers, Bryce,174022304.980.000.000.002304.98
Anderson, Daniel,20694146.970.000.00146.970.00
Prasad, Summer, M,2214339.980.000.0039.980.00
Sanders, Mason, G,2345939.980.000.000.0039.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Rivera, Makayla, A,2878334.990.000.000.0034.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Hughes, Antonio, P,15913712.270.000.000.00712.27
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Rivera, Allison, M,13751224.910.000.000.00224.91
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Winston, Ethan, R,216222612.060.000.002049.10562.96
Carter, Isaac,137191129.480.000.000.001129.48
Taylor, Marcus, A,18944146.940.000.000.00146.94
Liu, Arturo,13222150.410.000.0013.98136.43
Evans, Connor, J,15402131.550.000.000.00131.55
Kelly, Angel, E,15418232.230.000.000.00232.23
Peterson, Alex, M,13423132.900.000.000.00132.90
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Davis, Dylan,15556588.960.000.00588.960.00
Bell, Garrett, J,14265161.230.000.000.00161.23
Perez, Savannah, J,17036176.950.000.0056.97119.98
Gonzales, Kayla,214947.280.000.000.007.28
Brown, Anthony, J,19399151.430.000.000.00151.43
Howard, Morgan, T,229713578.270.003578.270.000.00
Lal, Kyle,17360122.180.000.000.00122.18
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Sanz, Lori, L,238654891.610.003578.270.001313.34
Smith, Andrew,1472387.570.000.0014.9872.59
Allen, Madeline,2924068.970.000.000.0068.97
Taylor, Ryan,170251709.980.000.000.001709.98
Dominguez, Erika, C,21251191.270.000.000.00191.27
Nath, Yolanda, A,2462513.980.000.000.0013.98
James, Richard, D,15760109.230.000.003.99105.24
Mitchell, Savannah,261153052.800.000.002443.35609.45
Diaz, Alyssa,139084715.330.000.000.004715.33
Harrison, Trevor, A,18055143.910.000.0036.96106.95
White, James,253317.280.000.000.007.28
Patterson, Nicole,1972937.270.000.000.0037.27
Gonzales, Miranda,11660324.720.000.000.00324.72
Stewart, Destiny,13144281.470.000.00134.98146.49
White, Nicole,16731155.910.000.0084.9670.95
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Thomas, Edward, E,19147133.710.000.000.00133.71
Kelly, Bryan,213492989.380.000.002989.380.00
Scott, Gabrielle,270614.990.000.000.004.99
Flores, Devin, A,15559172.040.000.0086.5685.48
Shan, Logan,1867760.960.000.0029.9930.97
Thomas, Thomas,216292624.080.000.002049.10574.98
Thomas, Dalton,230097.280.000.000.007.28
Turner, Morgan,11823178.470.000.000.00178.47
Griffin, Melissa, L,287807.950.000.000.007.95
Reed, Catherine, M,203807.280.000.000.007.28
Harris, Destiny, M,137102341.460.000.000.002341.46
Hall, Eduardo,16847189.940.000.000.00189.94
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Henderson, Olivia,188591155.480.000.000.001155.48
Gill, Robyn, J,127651750.980.000.001750.980.00
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Thomas, Jessica,1684894.480.000.0094.480.00
Rivera, Hailey, R,2079239.980.000.000.0039.98
Russell, Samuel, V,11652310.930.000.000.00310.93
Gray, Mariah,222787.280.000.007.280.00
Thompson, Devin,207084406.400.000.002071.422334.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Kelly, Erin, D,2351364.470.000.000.0064.47
Griffin, Madison, A,250932181.560.002181.560.000.00
Richardson, Lauren, C,14867839.480.000.000.00839.48
Evans, Jesse,2191639.980.000.000.0039.98
Ma, Tiffany,2157739.980.000.000.0039.98
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Patterson, Eduardo,11142866.810.000.0072.26794.55
Miller, Katherine, B,27102782.990.000.00782.990.00
Barnes, Ian, M,16106133.540.000.000.00133.54
Carter, Madeline, A,2752269.990.000.000.0069.99
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Campbell, Angel, D,195461174.480.000.000.001174.48
Ward, Destiny,16128539.990.000.000.00539.99
Griffin, Cassidy,264961000.440.000.001000.440.00
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Patterson, Eric, A,2738478.980.000.000.0078.98
Long, Rachel,2828339.980.000.000.0039.98
Moreno, Meredith, D,2228589.970.000.000.0089.97
Washington, Robert, J,14906143.950.000.000.00143.95
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Cooper, Ariana,17348205.420.000.000.00205.42
Washington, Alexia,27613782.990.000.00782.990.00
Price, Isabelle,201825749.970.003374.990.002374.98
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Miller, Alexis, A,12196124.930.000.000.00124.93
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Simmons, Mariah,266831270.820.00699.100.00571.72
Russell, Richard,2763322.260.000.000.0022.26
James, Christina,17409219.920.000.000.00219.92
Flores, Eduardo, S,2896962.980.000.000.0062.98
Lal, Robert, L,14084138.680.000.000.00138.68
Phillips, Luis, G,207347.280.000.000.007.28
Wilson, Madison, H,1982821.980.000.000.0021.98
Gomez, Krista,12760273.180.000.0036.27236.91
Ward, Kaylee, A,244154.990.000.004.990.00
Johnson, Madison, L,15530846.460.000.000.00846.46
Miller, Sydney, A,134404818.530.000.000.004818.53
Harris, Edward,27062782.990.000.00782.990.00
Martinez, Dominique,287888.990.000.008.990.00
Suri, Carolyn, S,12972175.710.000.000.00175.71
Alexander, Elijah,11738331.680.000.00141.73189.95
Bell, Christina,2609939.980.000.000.0039.98
Serrano, Albert, E,133284708.020.000.000.004708.02
Collins, Amanda,2078339.980.000.000.0039.98
Clark, Joseph, D,153954780.020.000.000.004780.02
Wilson, Daniel, K,142814746.300.000.000.004746.30
Howard, Brianna, D,246304.990.000.000.004.99
Peterson, Mason, A,185701174.480.000.001174.480.00
Edwards, Madeline,2077146.470.000.000.0046.47
Coleman, Stephanie,2226489.970.000.000.0089.97
Barnes, Haley, J,2133939.980.000.0039.980.00
Green, Eric,2738069.990.000.000.0069.99
Roberts, Rebecca,2800094.480.000.000.0094.48
Henderson, Hailey, C,171481775.470.000.000.001775.47
Reed, Melanie, A,28160574.980.000.000.00574.98
Miller, Eduardo,14561158.840.000.0049.97108.87
Perry, Jonathan, T,27026699.100.00699.100.000.00
Henderson, Justin, P,235917.280.000.000.007.28
Adams, Connor,214232888.560.000.002049.10839.46
Robinson, Madison, W,183772394.970.000.000.002394.97
Nelson, Sean,11841307.970.000.000.00307.97
Smith, Zachary, W,2378358.980.000.0058.980.00
James, Adrian, C,253404.990.000.000.004.99

Generated 2025-11-06 06:31:45.568 UTC