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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Adams, Katherine, M,235184.990.000.000.004.99
Stewart, Garrett, O,15762564.480.000.000.00564.48
Murphy, Chase, J,2472958.980.000.000.0058.98
Williams, Ian, M,175581750.470.000.000.001750.47
Bailey, Lauren,15864103.550.000.000.00103.55
Hall, Kyle, J,1749169.970.000.000.0069.97
Li, Rafael, M,217527.280.000.000.007.28
Washington, Riley, L,185441155.480.000.001155.480.00
Shan, Logan,1867760.960.000.0029.9930.97
Jackson, Charles, P,112771305.660.000.00237.821067.84
Evans, Dalton, E,127104774.040.000.002354.982419.06
Shan, Christian, L,2308439.980.000.000.0039.98
Winston, Ethan, R,216222612.060.000.002049.10562.96
Long, Rachel,2828339.980.000.000.0039.98
James, Bryce,13466133.450.000.000.00133.45
Hill, Haley, J,161033142.320.000.00792.342349.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Wright, Jennifer,2650559.980.000.0059.980.00
Evans, Kaylee,19642133.540.000.000.00133.54
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Watson, Richard,15943365.410.000.00154.98210.43
Kumar, Elijah,15197156.920.000.000.00156.92
Gomez, Krista,12760273.180.000.0036.27236.91
Gonzales, Miranda,11660324.720.000.000.00324.72
Bennett, Seth,244933578.270.003578.270.000.00
Stewart, Hailey,229036054.220.003578.270.002475.95
Sanders, Paige,252872983.340.002443.350.00539.99
Young, Kaylee, S,13756298.490.000.0058.47240.02
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Walker, Richard, T,19640224.550.000.000.00224.55
Henderson, Ashley,111851381.370.000.00232.801148.57
Cooper, Paige,14119148.940.000.000.00148.94
Morris, Abigail, C,287762.290.000.000.002.29
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Yuan, Leonard, F,167911729.970.000.000.001729.97
Turner, Adam, K,16109548.980.000.000.00548.98
Rivera, Rachel, S,2899678.980.000.000.0078.98
Ma, Tiffany,2157739.980.000.000.0039.98
Prasad, Erick, E,28786127.950.000.000.00127.95
Russell, Nicole, M,182372318.960.000.000.002318.96
Smith, Nathan,217647.280.000.007.280.00
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Rivera, Allison, M,13751224.910.000.000.00224.91
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Campbell, Evan, W,243424828.110.003578.270.001249.84
Campbell, Gabriella,188411145.480.000.000.001145.48
Jones, Alexandra, B,2020245.950.000.000.0045.95
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Carter, Elijah,216182611.070.000.002611.070.00
Simmons, James,198844588.450.003399.990.001188.46
Yuan, Brendan, S,247444.990.000.000.004.99
Davis, Dylan,15556588.960.000.00588.960.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Martin, Kellie, R,28195574.980.000.000.00574.98
Campbell, Lucas,2932953.990.000.000.0053.99
Miller, Victoria,15816188.020.000.00118.0569.97
Morgan, Angela,24665109.970.000.000.00109.97
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Bradley, Rachel,158504813.040.000.000.004813.04
Phillips, Luis, G,207347.280.000.000.007.28
Alexander, Jason,2932849.990.000.000.0049.99
Torres, Xavier,16840176.950.000.000.00176.95
Phillips, Kyle,12158202.200.000.000.00202.20
Murphy, Brianna, K,2834269.990.000.000.0069.99
Parker, Jordan,216212616.860.000.002049.10567.76
Malhotra, Brenda,133912405.470.000.000.002405.47
Coleman, Ashley,27297782.990.000.00782.990.00
Butler, Jonathan,261804.990.000.000.004.99
Price, Jeremy,259892744.520.000.002181.56562.96
Thomas, Logan, A,14091251.200.000.0053.99197.21
Wilson, Victoria, R,27536782.990.000.00782.990.00
Yuan, Carly,19839194.960.000.000.00194.96
Ross, Anna, D,15494275.440.000.0029.99245.45
Yang, Jordan, K,14458133.950.000.000.00133.95
Bailey, Hailey, R,262704.990.000.000.004.99
Collins, Connor, J,27270782.990.000.00782.990.00
Patterson, Maria, G,1333094.950.000.000.0094.95
Gray, Sara,292472447.050.000.002447.050.00
Foster, Emma,15468436.350.000.00159.99276.36
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Peterson, Melissa, S,249954.990.000.004.990.00
Ross, David, M,171431763.970.000.000.001763.97
Long, Caleb, P,250462181.560.002181.560.000.00
She, Kenneth,16096212.010.000.0080.96131.05
Brooks, Ian, W,2829064.470.000.000.0064.47
Diaz, Elijah,200004495.480.003374.990.001120.49
Williams, Ryan, R,222475978.610.003578.270.002400.34
Williams, Joshua,260514.990.000.000.004.99
Turner, Eduardo,158764789.020.000.000.004789.02
Nath, Carl, H,29001624.970.000.000.00624.97
Howard, Alexandra,207363194.580.000.002049.101145.48
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
She, Martha, E,222515971.330.003578.270.002393.06
Jackson, Victoria,270194.990.000.000.004.99
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Washington, Christian, R,2668639.980.000.000.0039.98
Perry, James,192051249.840.000.000.001249.84
Anand, Brendan, L,1984721.980.000.000.0021.98
Hill, Katherine, L,2670139.980.000.000.0039.98
Lal, Jack, R,185251735.980.000.000.001735.98
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Parker, Kaylee, M,2773878.980.000.000.0078.98
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Hughes, Antonio, P,15913712.270.000.00712.270.00
Robinson, Julia,28121119.980.000.000.00119.98
Stewart, Makayla,16649115.940.000.000.00115.94
Martinez, Dominique,287888.990.000.008.990.00
Reed, Bryan,18884133.930.000.000.00133.93
Walker, Destiny, M,169961754.980.000.000.001754.98
Powell, Lauren, E,1966275.970.000.000.0075.97
Long, Sydney,279217.280.000.000.007.28
Gonzales, Paige,2170291.940.000.0039.9851.96
Rivera, Ariana,261734.990.000.000.004.99
Turner, Morgan,11823178.470.000.000.00178.47
Nelson, Kevin,1476584.970.000.000.0084.97
Sandberg, Chase,2190475.970.000.000.0075.97
Carter, Bailey,213322616.860.000.002616.860.00
White, Edward, J,15847205.460.000.000.00205.46
Foster, Isabel, M,2174571.950.000.000.0071.95
Walker, Hunter,271007.280.000.000.007.28
Hughes, Jasmine,276284.990.000.000.004.99
Turner, Mary,220154.990.000.000.004.99
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Cook, Seth,2301064.470.000.000.0064.47
Barnes, Haley, J,2133939.980.000.0039.980.00
Cooper, Amanda, P,146064716.020.000.000.004716.02
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Powell, Spencer,14904468.120.000.000.00468.12
Powell, Jack, J,1841156.960.000.000.0056.96
Long, Brandon, M,16110650.470.000.000.00650.47
Zhang, Nathan, L,2910478.980.000.000.0078.98
James, Jeremiah, S,11661287.700.000.000.00287.70
Hall, Lauren, A,19648100.840.000.000.00100.84
Anderson, Daniel,20694146.970.000.00146.970.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Chen, Ethan,2054756.970.000.000.0056.97
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Dominguez, Meghan,14370122.560.000.000.00122.56
Washington, Caroline, D,231145996.320.003578.270.002418.05
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Washington, Emma,191231170.480.000.000.001170.48
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Cook, Megan, J,2029956.970.000.000.0056.97
Griffin, Cassidy,264961000.440.000.001000.440.00
Simmons, David, E,120172339.970.000.002339.970.00
Thames, Bernard,2380368.490.000.000.0068.49
Washington, Alexia,27613782.990.000.00782.990.00
Rivera, Sara,187852350.960.000.000.002350.96
Johnson, Andrew, F,262942443.350.000.002443.350.00
Bell, Chase,180911750.980.000.000.001750.98
Murphy, Maria,160113657.260.000.000.003657.26
Walker, Jacob, N,29027574.980.000.000.00574.98
Perry, Lauren,248164.990.000.000.004.99
James, Maria,1624391.970.000.0069.9921.98
Coleman, Spencer,15993597.260.000.000.00597.26
Isla, Julian, A,13732108.960.000.004.99103.97
Lee, Kayla, M,2078115.230.000.000.0015.23
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Torres, Christina, M,20746119.950.000.0064.9754.98
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Hernandez, Sierra,27393123.980.000.00123.980.00
Brooks, Allison,146054750.010.000.000.004750.01
Ward, Juan, H,215952649.560.000.002049.10600.46
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Brooks, Lucas, S,16089342.030.000.000.00342.03
Collins, Isaac,260777.280.000.000.007.28
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Nelson, Sierra,161322459.620.000.002459.620.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Powell, Vanessa,26630699.100.00699.100.000.00
Ward, Ian,12056213.920.000.000.00213.92
Cox, Arianna, D,1892789.250.000.000.0089.25
Rodriguez, Destiny, J,227397.280.000.007.280.00
Foster, Antonio,12795108.540.000.0066.2642.28
Campbell, Alex,119844730.320.000.002329.982400.34
Simmons, Nicole, S,2617729.480.000.000.0029.48
Griffin, Seth, R,17585164.460.000.0078.9885.48
Powell, Jordyn, K,153914828.010.000.000.004828.01
Flores, Miguel,1975077.250.000.000.0077.25
Hayes, Dalton, C,188822322.280.000.000.002322.28
Ross, Kaitlyn,16121614.470.000.000.00614.47
Martin, Madison, C,2049271.970.000.0071.970.00
Ortega, Javier, P,127852294.990.000.000.002294.99
Hayes, Jason,261764.990.000.000.004.99
Martin, Joshua, A,276077.280.000.007.280.00
Henderson, Austin,2764354.980.000.000.0054.98
Griffin, Marcus,2075634.560.000.000.0034.56
Foster, Alyssa, I,14875839.480.000.000.00839.48
Patterson, Natalie,16123629.970.000.000.00629.97
Evans, Jordan,2920939.980.000.0039.980.00
Campbell, Adam, A,214002688.890.000.002071.42617.47
Li, Brandon,2933973.960.000.000.0073.96
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Ethan, J,223597.280.000.000.007.28
Moore, Ian, L,2463939.980.000.000.0039.98
Shan, Gabriel, T,2773169.990.000.000.0069.99
Price, Riley, R,139094764.020.000.000.004764.02
Robinson, Dylan, L,1472481.530.000.000.0081.53
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Powell, Blake, J,2237139.980.000.000.0039.98
Hughes, Eduardo,15564188.520.000.000.00188.52
Mitchell, Savannah,261153052.800.000.002443.35609.45
Foster, Eric,229765971.330.003578.270.002393.06
She, Alisha, G,247574343.590.003578.270.00765.32
Wood, Alexandria, M,248242181.560.002181.560.000.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Roberts, Hunter,282607.280.000.000.007.28
Ross, Natalie, J,12916261.220.000.000.00261.22
Henderson, Abigail,2044139.980.000.000.0039.98
Zhang, Heather,166543056.320.000.00751.342304.98
Lopez, Jack, I,2904751.460.000.000.0051.46
Harris, Isabella,17119214.900.000.0077.96136.94
Ross, Miranda,145984839.000.000.000.004839.00
Young, Adam,12984200.200.000.00107.2692.94
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Russell, Jessica,265721000.440.000.001000.440.00
Patterson, Abigail, H,144784795.010.000.000.004795.01
Phillips, Jack, R,259952443.350.000.002443.350.00
Green, Mackenzie, C,280737.280.000.000.007.28
Gomez, Briana, A,2878443.980.000.000.0043.98
Suarez, Juan, R,167631700.990.000.000.001700.99
White, Emily, M,159174679.060.000.000.004679.06
Rogers, Sara,198744544.450.003374.990.001169.46
Collins, Luis, J,227655978.610.003578.270.002400.34
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Reed, Paige,221126047.323578.270.002469.050.00
Hall, Jan, M,11740334.120.000.00235.1598.97
Alvarez, Melody,2507068.490.000.000.0068.49
Simmons, Brittany,2923139.980.000.000.0039.98
Cooper, Brooke,195361120.490.000.000.001120.49
Brown, Anna,1624795.820.000.000.0095.82
Perez, Barry, M,2728269.990.000.000.0069.99
Luo, Jodi,2921368.490.000.000.0068.49
Perry, Marcus, L,206563245.900.000.002071.421174.48
Foster, Deb,215012661.400.000.002661.400.00
Nath, Alison, J,171161764.960.000.000.001764.96
Hernandez, José, M,11253696.610.000.00187.94508.67
Baker, Sean, T,247782858.490.002181.56676.930.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Scott, Adam,15863243.010.000.000.00243.01

Generated 2025-11-01 00:07:38.641 UTC