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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Patterson, Abigail, H,144784795.010.000.000.004795.01
Powell, Jonathan,238584712.740.003578.271134.470.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Cooper, Paige,14119148.940.000.000.00148.94
Hall, Jason, A,29351119.980.000.000.00119.98
Simmons, Jose,2464739.980.000.000.0039.98
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Clark, Joseph, D,153954780.020.000.000.004780.02
Murphy, Shelby,244894.990.000.000.004.99
Sharma, Thomas, A,18637121.940.000.000.00121.94
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Campbell, Adam, A,214002688.890.000.002071.42617.47
Martin, John, A,144364776.010.000.000.004776.01
Bennett, Brittany, J,2233239.980.000.000.0039.98
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Sara, Ivan, L,2509067.930.000.000.0067.93
Bailey, Hailey, R,262704.990.000.000.004.99
Hall, Noah, A,1525175.250.000.000.0075.25
Richardson, Melissa, E,111322371.940.000.000.002371.94
Evans, Gabriel,2348789.970.000.000.0089.97
Bryant, Jackson, J,2533239.980.000.000.0039.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Powell, Lauren, E,1966275.970.000.000.0075.97
Umeda, Masaki,16717233.810.000.000.00233.81
Washington, Thomas, C,2745137.430.000.000.0037.43
Perry, Dalton, A,16149192.040.000.000.00192.04
Evans, Alexandra,2432268.490.000.000.0068.49
Coleman, Logan,1868691.950.000.000.0091.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Adams, Katherine, M,235184.990.000.000.004.99
Smith, Samuel, D,2308349.900.000.000.0049.90
Hernandez, Haley, L,11769478.950.000.000.00478.95
Brooks, Victoria, H,16479158.510.000.000.00158.51
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Allen, Luke,113162349.980.000.002349.980.00
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Smith, John,198555709.960.003399.990.002309.97
Howard, Danielle,28357133.490.000.000.00133.49
Phillips, Aaron, R,2494739.980.000.000.0039.98
Morgan, Brianna, D,111362380.470.000.002380.470.00
Perry, Brandon,22095141.980.000.000.00141.98
Flores, Kevin,15878225.920.000.0069.97155.95
Perry, Lauren,248164.990.000.000.004.99
Patterson, Maria, G,1333094.950.000.000.0094.95
Foster, Deb,215012661.400.000.002661.400.00
Nath, Yolanda, A,2462513.980.000.000.0013.98
Powell, Ian,2608564.470.000.000.0064.47
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Jackson, Brianna,1537797.910.000.0074.9822.93
Collins, Eduardo,139872329.990.000.000.002329.99
Thompson, Brianna, X,1864269.970.000.000.0069.97
James, Juan,232674862.090.003578.271283.820.00
Cook, Steven, J,27053782.990.00782.990.000.00
Butler, Victoria,132844767.530.000.000.004767.53
Thomas, Dalton,230097.280.000.000.007.28
Thomas, Megan,2907169.990.000.000.0069.99
Sanchez, Martin, E,216317.280.000.000.007.28
Price, Nicole, N,15815141.830.000.000.00141.83
Bell, Alex, M,167543118.600.000.00756.332362.27
Carter, Marcus, l,2147131.970.000.000.0031.97
Murphy, Maria,160113657.260.000.000.003657.26
Rodriguez, Julia, A,264884.990.000.004.990.00
Garcia, Xavier, M,2030071.970.000.000.0071.97
Lal, Robert, L,14084138.680.000.000.00138.68
Nelson, James, L,245257.280.000.007.280.00
Morris, Mason, J,22349124.990.000.000.00124.99
Lee, John,19801193.010.000.000.00193.01
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Miller, Destiny,251577.280.000.000.007.28
Price, Devin, M,18758158.510.000.0073.5584.96
Russell, Oscar, A,12140118.170.000.000.00118.17
Gray, Seth, M,2008785.480.000.000.0085.48
Harris, Matthew,14330806.760.000.000.00806.76
James, Maria,1624391.970.000.0069.9921.98
Diaz, Elijah,200004495.480.003374.990.001120.49
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Harris, Seth, M,161402528.330.000.000.002528.33
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Davis, Justin,2807412.940.000.000.0012.94
Thompson, Xavier, R,15761192.410.000.000.00192.41
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Ross, David, M,171431763.970.000.000.001763.97
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Long, Sydney,279217.280.000.000.007.28
Phillips, Isaiah,28631144.470.000.00144.470.00
Washington, Lauren, R,229985329.250.003578.271750.980.00
Perry, Eric,18314115.730.000.0056.9758.76
Flores, Jordyn,252882721.550.002181.560.00539.99
Stewart, Amanda, M,1531094.440.000.000.0094.44
Price, Jeremy,259892744.520.000.002181.56562.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Powell, Katherine, C,14574177.600.000.000.00177.60
Miller, Andrew, C,271104.990.000.000.004.99
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Price, Mariah, C,2074549.480.000.000.0049.48
Perez, Amber, D,13318214.260.000.00116.9197.35
Howard, Erin, L,183621725.210.000.000.001725.21
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Chavez, Kara, P,13285214.350.000.0012.94201.41
Morgan, Juan, C,1882191.970.000.000.0091.97
Brown, Jonathan,11875265.420.000.000.00265.42
Young, Jenna, W,163652490.180.000.000.002490.18
Perry, James,192051249.840.000.000.001249.84
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Howard, Alexandra,207363194.580.000.002049.101145.48
Edwards, Hunter,2422067.930.000.000.0067.93
Davis, Nicholas,1320173.160.000.000.0073.16
Lewis, Zachary, L,14760167.260.000.000.00167.26
Watson, Shelby, J,14911867.970.000.000.00867.97
Alexander, Julian,132172351.960.000.000.002351.96
Hill, Haley, J,161033142.320.000.00792.342349.98
Bell, Gabrielle,223735976.320.003578.270.002398.05
Bell, Eduardo,27101782.990.000.00782.990.00
Stewart, Gabriella,2803469.990.000.000.0069.99
Thompson, Ethan,199894495.480.003374.990.001120.49
Mehta, Carmen, C,2743694.480.000.000.0094.48
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Smith, Nathan,217647.280.000.007.280.00
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Sanders, Mason, G,2345939.980.000.000.0039.98
Stewart, Allison, R,18826166.430.000.0069.9996.44
King, Gabrielle,263504.990.000.000.004.99
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Garrett, O,15762564.480.000.000.00564.48
Turner, Blake,12136131.740.000.000.00131.74
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Russell, Richard,2763322.260.000.000.0022.26
Lee, Don,188392384.970.000.000.002384.97
Raje, Mindy, A,16083561.970.000.000.00561.97
Campbell, Hailey,15507267.840.000.00228.9638.88
Perry, Olivia,203754438.380.000.002071.422366.96
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Allen, Sean, L,12097159.220.000.000.00159.22
Griffin, Jason, L,112001267.110.000.00391.08876.03
Martin, Samuel,15874225.440.000.0069.99155.45
Perez, Timothy, L,227304.990.000.000.004.99
Alexander, Jordan,2141259.980.000.0059.980.00
Lewis, Ryan, A,203124.990.000.000.004.99
Sanchez, Faith,270494.990.000.000.004.99
Thomas, Emily,2180339.980.000.000.0039.98
Hughes, Miranda,266784.990.000.000.004.99
Alexander, Julia, J,15291889.470.000.000.00889.47
Harris, Noah,292562393.060.000.002393.060.00
Evans, Luke,2917615.230.000.000.0015.23
Johnson, Christopher,119794813.760.000.002352.212461.55
Rogers, Carlos,19645134.440.000.000.00134.44
Smith, Justin, P,1982721.980.000.000.0021.98
Anderson, Megan, A,238594153.250.003578.27574.980.00
Nelson, Henry,193941155.480.000.000.001155.48
Hall, Charles,234764.990.000.000.004.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Price, Lauren, J,14079184.740.000.0037.29147.45
Zhao, Clarence, R,1982671.970.000.0071.970.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Chandra, Brandy, P,11501603.530.000.000.00603.53
Nath, Alison, J,171161764.960.000.000.001764.96
Davis, Dylan,15556588.960.000.00588.960.00
Hughes, Luis,130841798.960.000.000.001798.96
Gray, Sara,292472447.050.000.002447.050.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Parker, Katherine,13268289.700.000.0068.97220.73
Wang, Zachary,2214489.970.000.000.0089.97
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Shan, Benjamin,235663578.270.003578.270.000.00
Thomas, David,168363193.790.000.000.003193.79
Diaz, Trevor, B,2051954.960.000.000.0054.96
Alexander, Luke,290432447.050.000.002447.050.00
Peterson, Jared,11502829.370.000.00171.95657.42
Simmons, Anna, K,124512367.920.000.000.002367.92
Barnes, Fernando,113001390.550.000.00248.381142.17
Williams, Ethan,243094793.120.003578.270.001214.85
Thomas, Zachary, D,28045119.980.000.000.00119.98
Peterson, Xavier, R,2645639.980.000.000.0039.98
Flores, Morgan,19817118.940.000.0039.9878.96
Smith, Austin,13707149.050.000.000.00149.05
Hayes, Oscar,2652729.260.000.000.0029.26
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Walker, Emma, M,2520998.960.000.000.0098.96
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Lee, Samantha, B,2737878.980.000.000.0078.98
Cooper, Grace, C,1601294.260.000.000.0094.26
Reed, Catherine, M,203807.280.000.000.007.28
Carter, Jason,11724210.090.000.00113.8696.23
Price, Jocelyn, D,258752443.350.002443.350.000.00
Bailey, Jessica, L,12945218.440.000.000.00218.44
Powell, Spencer,14904468.120.000.000.00468.12
Rogers, Sean, G,18685124.460.000.000.00124.46
Ward, Destiny,16128539.990.000.000.00539.99
Edwards, Logan,250024.990.000.000.004.99
Murphy, Catherine, L,1650692.050.000.000.0092.05
Moore, Jonathan,2047896.460.000.000.0096.46
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Collins, Jonathan,16849119.980.000.000.00119.98
Patterson, Grace, M,27560782.990.000.00782.990.00
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Gonzales, Gavin,2448813.980.000.000.0013.98
Roberts, Rebecca,2800094.480.000.000.0094.48
Powell, Jordyn, K,153914828.010.000.000.004828.01
Diaz, Angela, K,27259782.990.000.00782.990.00
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Stewart, Grace, H,247737.280.000.000.007.28
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Sanders, Zoe, L,248254.990.000.000.004.99
Thompson, Joshua, F,259992181.560.000.002181.560.00
Griffin, Melissa, L,287807.950.000.000.007.95
Nelson, Kevin,1476584.970.000.000.0084.97
Young, Courtney,176222374.980.000.000.002374.98
Smith, Zachary, W,2378358.980.000.0058.980.00
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Alexander, Thomas,207607.280.000.000.007.28
Rodriguez, Taylor,1607166.960.000.000.0066.96
Gill, Robyn, J,127651750.980.000.001750.980.00
Robinson, Madison, W,183772394.970.000.000.002394.97
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Foster, Alyssa, I,14875839.480.000.000.00839.48
Hughes, Luke, I,270141274.080.00699.100.00574.98
Jones, Natalie, A,11845197.200.000.0082.26114.94
Lopez, Jack, I,2904751.460.000.000.0051.46
Williams, Sydney, J,15334848.470.000.000.00848.47
Turner, Wyatt,200345769.960.003399.990.002369.97
Gutierrez, Neil, L,214897.280.000.000.007.28
Moore, Taylor, A,199874564.450.003374.990.001189.46
Stewart, Alexandria,174761700.990.000.000.001700.99
Lewis, Morgan,17410168.740.000.000.00168.74
Rogers, Olivia,12020804.470.000.000.00804.47
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Foster, Samuel, M,18523160.940.000.00128.9731.97
Brown, Benjamin, D,151874725.320.000.000.004725.32
Young, Sierra, J,11619634.840.000.0034.99599.85
Henderson, Ashley,111851381.370.000.00232.801148.57
Patterson, Hailey, I,112231155.900.000.00196.04959.86
Hughes, Isabella,2304851.460.000.000.0051.46
Cooper, Angela,195261179.470.000.000.001179.47
Gutierrez, Jerome,127832420.460.000.000.002420.46
Griffin, Maria,1840763.250.000.000.0063.25
Wilson, Andrew, R,182362414.990.000.000.002414.99
Martin, Lucas, L,221144183.233578.270.000.00604.96
Flores, Brittany,169062359.980.000.000.002359.98
Parker, Natalie, A,251043018.330.002443.350.00574.98
Hall, Taylor, J,169951735.980.000.000.001735.98
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Martinez, Joseph, E,2921459.980.000.0059.980.00
Perez, Jordan, A,292674.990.000.000.004.99
Watson, Devin, A,18875114.950.000.000.00114.95
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Gray, Jared, A,264494.990.000.000.004.99
Cook, Seth,2301064.470.000.000.0064.47
Henderson, Hailey, C,171481775.470.000.000.001775.47
Griffin, Julian, M,113284718.040.000.002319.992398.05
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Stewart, Olivia, B,1874923.780.000.000.0023.78

Generated 2025-11-06 19:05:55.741 UTC