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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Foster, Paige,2742894.480.000.000.0094.48
Hayes, Jason,261764.990.000.000.004.99
Gray, Sara,292472447.050.000.002447.050.00
Peterson, Steven, L,234497.280.000.007.280.00
Richardson, Devin, G,2131836.960.000.000.0036.96
Lewis, Ethan,27998144.470.000.000.00144.47
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Smith, Eduardo,2069139.980.000.0039.980.00
Gill, Beth,199975814.980.003374.990.002439.99
Patterson, Nicole,1972937.270.000.000.0037.27
Patterson, Eric, A,2738478.980.000.000.0078.98
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Clark, Anthony,27071782.990.00782.990.000.00
Simmons, Adam,253274.990.000.000.004.99
Ross, Miranda,145984839.000.000.000.004839.00
Torres, Pedro, E,16958168.020.000.00153.0414.98
Green, Samuel, D,14096174.730.000.000.00174.73
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Campbell, Hailey,15507267.840.000.00228.9638.88
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Morris, Alyssa,28072548.980.000.000.00548.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Henderson, Justin, P,235917.280.000.007.280.00
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Campbell, Adam, A,214002688.890.000.002071.42617.47
Diaz, Richard, A,2668264.470.000.000.0064.47
Simmons, David, E,120172339.970.000.002339.970.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Russell, Richard,2763322.260.000.000.0022.26
Smith, John,198555709.960.003399.990.002309.97
Rogers, Carlos,19645134.440.000.000.00134.44
Hayes, Austin,202083219.580.002049.100.001170.48
Martin, Brandon, S,2169139.980.000.000.0039.98
Coleman, Vanessa,215892589.090.000.002049.10539.99
Moore, Logan,2634889.970.000.0089.970.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Kennedy, Bridget,2202639.980.000.000.0039.98
Harris, Matthew,14330806.760.000.000.00806.76
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Ross, Jose,2744178.980.000.0078.980.00
Garcia, Cameron,186411120.490.000.000.001120.49
Winston, Ethan, R,216222612.060.000.002049.10562.96
Hill, Sydney,264821000.440.000.001000.440.00
Martin, Madison, C,2049271.970.000.0071.970.00
Alexander, Jason,2932849.990.000.000.0049.99
Wilson, Fernando,16643126.960.000.000.00126.96
Harris, Isabella,17119214.900.000.0077.96136.94
Diaz, Alyssa,139084715.330.000.000.004715.33
Shan, Chad, M,2462112.940.000.000.0012.94
Ross, Antonio,18322148.890.000.000.00148.89
Perry, Marcus, L,206563245.900.000.002071.421174.48
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Perez, Amber, D,13318214.260.000.00116.9197.35
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Wilson, Tyler, L,15879196.930.000.000.00196.93
Green, Kaylee, C,2618567.970.000.000.0067.97
Stewart, Julia, L,129022329.980.000.000.002329.98
Carter, Jonathan,14578848.470.000.000.00848.47
Prasad, Summer, M,2214339.980.000.0039.980.00
Watson, Victoria,16125588.960.000.000.00588.96
Simmons, Dylan,16133107.850.000.0038.8868.97
Price, Jeremy,259892744.520.000.002181.56562.96
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Lal, Robert, L,14084138.680.000.000.00138.68
Foster, Caleb,27112114.460.000.000.00114.46
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Hill, Fernando,247634.990.000.000.004.99
Moore, Jonathan,2047896.460.000.000.0096.46
Bailey, Jessica, L,12945218.440.000.000.00218.44
Walker, Hunter,271007.280.000.000.007.28
Brooks, Victoria, H,16479158.510.000.000.00158.51
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Bailey, Mariah, L,2724354.980.000.000.0054.98
She, Shawn, J,16902141.980.000.000.00141.98
Long, Kaitlyn,233964891.610.003578.270.001313.34
Morris, Paige, W,220414167.233578.270.000.00588.96
Martin, Samuel,15874225.440.000.0069.99155.45
Gill, Robyn, J,127651750.980.000.001750.980.00
Roberts, Robert, R,1898656.970.000.0056.970.00
Sharma, Samuel,27725119.980.000.000.00119.98
Patterson, Taylor,12147271.450.000.000.00271.45
Martin, Morgan,248322181.560.002181.560.000.00
Smith, Nathan,217647.280.000.007.280.00
Anderson, Isabella,137432349.980.000.000.002349.98
Price, Mariah, C,2074549.480.000.000.0049.48
Brown, Christian,227554.990.000.000.004.99
Jenkins, Samantha,113311290.330.000.00410.31880.02
Russell, Gail, L,212634.990.000.000.004.99
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Simmons, James,198844588.450.003399.990.001188.46
Ruiz, Philip,1807781.460.000.000.0081.46
Cannata, Gabrielle, C,217254.990.000.000.004.99
Sanchez, Jared, J,2585064.470.000.000.0064.47
Morris, Jessica,289678.990.000.008.990.00
Wilson, Nathan, L,13936218.930.000.000.00218.93
Williams, Ethan,243094793.120.003578.270.001214.85
White, Jennifer, S,27027782.990.00782.990.000.00
Kelly, Julia,2379867.930.000.0067.930.00
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
White, Emily, M,159174679.060.000.000.004679.06
Hall, Lauren, A,19648100.840.000.000.00100.84
Gonzales, Luis,15856116.250.000.0037.2778.98
Chapman, Nancy, E,11276840.150.000.0066.26773.89
He, Micah,2740169.990.000.000.0069.99
Wilson, Christian,27085782.990.000.00782.990.00
Hall, Fernando,2210090.950.000.000.0090.95
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Simmons, Mariah,266831270.820.00699.100.00571.72
Anderson, Ryan, W,132712319.990.000.000.002319.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Coleman, Jose, S,253494.990.000.000.004.99
Hall, Charles,234764.990.000.000.004.99
Blue, Paige,2170313.980.000.000.0013.98
Anderson, Megan, A,238594153.250.003578.27574.980.00
Jai, Kevin,1983678.960.000.0038.9839.98
Blanco, Randall,263211554.410.000.001000.44553.97
Torres, Xavier,16840176.950.000.000.00176.95
Garcia, Xavier, M,2030071.970.000.000.0071.97
Campbell, Evan, W,243424828.110.003578.270.001249.84
McDonald, Aaron, J,27734119.980.000.000.00119.98
Moore, Chloe, L,2626913.980.000.000.0013.98
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Martinez, Joseph, E,2921459.980.000.0059.980.00
Stewart, Jessica,16097103.550.000.0046.5856.97
Hill, Timothy,14871848.470.000.000.00848.47
Turner, Eduardo,158764789.020.000.000.004789.02
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Robinson, Emily,12183228.420.000.0054.96173.46
Miller, Alexis, A,12196124.930.000.000.00124.93
Collins, Nathan, F,197041143.460.000.000.001143.46
Watson, Olivia, S,1386093.850.000.0014.9878.87
Gonzales, Miranda,11660324.720.000.000.00324.72
Washington, Emma,191231170.480.000.000.001170.48
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Sanchez, Faith,270494.990.000.000.004.99
Bryant, Brittany,2254548.970.000.000.0048.97
Watson, Richard,15943365.410.000.00154.98210.43
Martin, Thomas, A,169521735.980.000.000.001735.98
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Murphy, Shelby,244894.990.000.000.004.99
Stewart, Alex, M,2008463.150.000.000.0063.15
Thomas, David,168363193.790.000.000.003193.79
Scott, Adam,15863243.010.000.000.00243.01
Hall, Amber,20106131.950.000.000.00131.95
Jones, Dalton, T,189512334.970.000.000.002334.97
Martin, Jill, C,11824181.030.000.0069.97111.06
Reed, Kaylee, R,17371151.920.000.000.00151.92
Jones, Samantha,1831721.980.000.000.0021.98
Stewart, Grace, H,247737.280.000.000.007.28
Diaz, Luke,12054402.530.000.00139.97262.56
Hall, Jan, M,11740334.120.000.00235.1598.97
Ortega, Byron,233064828.110.003578.270.001249.84
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Sanders, Megan, A,15376136.240.000.000.00136.24
Roberts, Seth, H,11510258.150.000.0039.47218.68
Martin, Kellie, R,28195574.980.000.000.00574.98
Green, Chloe, J,1465892.820.000.000.0092.82
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Turner, Mary,220154.990.000.000.004.99
Allen, Allison, A,1975737.270.000.000.0037.27
Brooks, Lucas, S,16089342.030.000.000.00342.03
Howard, Danielle,28357133.490.000.000.00133.49
Washington, Vanessa,238194802.110.003578.270.001223.84
Isla, Julian, A,13732108.960.000.004.99103.97
Flores, Jordyn,252882721.550.002181.560.00539.99
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Flores, Morgan,19817118.940.000.0039.9878.96
Harris, Emily, P,1986298.480.000.000.0098.48
Diaz, Luis, D,11203801.770.000.00183.97617.80
Watson, Michelle, H,262352181.560.000.002181.560.00
Bennett, Brittany, J,2233239.980.000.000.0039.98
Walker, John, M,2858969.990.000.000.0069.99
Sandberg, Isaac,1335053.970.000.000.0053.97
Hayes, Gavin, A,194001179.470.000.000.001179.47
Wilson, Daniel, K,142814746.300.000.000.004746.30
Lobao, Alexandre,1892691.950.000.0091.950.00
Perry, Christian,246714354.600.003578.270.00776.33
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
Thompson, Jose,237314828.110.003578.270.001249.84
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Perry, Olivia,203754438.380.000.002071.422366.96
Sanz, Lori, L,238654891.610.003578.270.001313.34
Wilson, Hunter, R,2723013.980.000.000.0013.98
Gray, Jesse,14626197.040.000.000.00197.04
Perry, James,192051249.840.000.000.001249.84
Evans, Jordan,2920939.980.000.0039.980.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Powell, Vanessa,26630699.100.00699.100.000.00
Russell, Isabella, A,11507645.780.000.0028.48617.30
Reed, Erin, I,14353128.840.000.0074.9853.86
Rodriguez, Taylor,1607166.960.000.000.0066.96
Washington, Hannah, A,291307.280.000.007.280.00
Mitchell, Bailey, B,267067.280.000.007.280.00
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
King, Jordan, C,110202316.970.000.002316.970.00
Hughes, Anna,197052341.970.000.000.002341.97
Parker, Amanda,1808151.970.000.000.0051.97
Perez, Barry, M,2728269.990.000.000.0069.99
Torres, Dalton,235037.280.000.007.280.00
Barnes, Blake, A,178651789.970.000.000.001789.97
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Mr., Smith, Jeff,2928353.990.000.000.0053.99
King, Caleb, J,2898678.980.000.000.0078.98
Bradley, Melanie, G,133434720.270.000.000.004720.27
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Hall, Grace, A,201894.990.000.000.004.99
Wright, Kyle,2371626.970.000.000.0026.97
Turner, Adam, K,16109548.980.000.000.00548.98
Scott, Eric,282484.990.000.004.990.00
Gonzales, Paige,2170291.940.000.0039.9851.96
Parker, Jeremy,2866878.980.000.0078.980.00
Cooper, Brianna,2592513.980.000.000.0013.98
Smith, Chloe,17619163.920.000.000.00163.92
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Ramos, Kristi,151764703.030.000.000.004703.03
Diaz, Elijah,200004495.480.003374.990.001120.49
Russell, Ian, T,2474613.980.000.0013.980.00
Butler, Ana,260403018.330.000.002443.35574.98
Gray, Mariah,222787.280.000.007.280.00
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Ward, Juan, H,215952649.560.000.002049.10600.46
Anderson, Destiny,12895336.650.000.0037.27299.38
Ross, Natalie, J,12916261.220.000.000.00261.22
Allen, Angel, G,15571101.850.000.0034.8966.96
Long, Brandon, M,16110650.470.000.000.00650.47
Reed, Sean, L,145974803.310.000.000.004803.31
Sun, Arturo, C,11498557.540.000.00151.90405.64
Sanders, Lucas, W,268024.990.000.000.004.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Cook, Seth,2301064.470.000.000.0064.47
Price, Oscar, G,11833240.010.000.000.00240.01
Wilson, Madison, H,1982821.980.000.000.0021.98
Morgan, Brianna, D,111362380.470.000.002380.470.00
Gray, Sebastian, B,138782366.960.000.000.002366.96
Lee, Don,188392384.970.000.000.002384.97
Bradley, Rachel,158504813.040.000.000.004813.04
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Hernandez, José, M,11253696.610.000.00187.94508.67
Johnson, James,234984.990.000.000.004.99
Jai, Adam,250952443.350.002443.350.000.00
Reed, Bryan,18884133.930.000.000.00133.93
Rubio, Javier, E,1972664.240.000.0064.240.00
Gray, Seth, M,2008785.480.000.000.0085.48

Generated 2025-11-01 08:52:32.451 UTC