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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Torres, Mackenzie,28153570.470.000.000.00570.47
Gonzales, Cameron, L,2900569.990.000.000.0069.99
Turner, Amanda, L,203183241.900.002071.420.001170.48
Anderson, Isabella,137432349.980.000.000.002349.98
Thompson, Kayla, D,12363273.900.000.000.00273.90
Collins, Lucas, T,219214142.750.003578.270.00564.48
Lewis, Isabella,2624267.930.000.000.0067.93
Griffin, Jordan,13095328.890.000.000.00328.89
Robinson, Joseph,2814194.480.000.000.0094.48
Clark, Joseph, D,153954780.020.000.000.004780.02
Gonzales, Kayla,214947.280.000.000.007.28
Ward, Devin, J,15378170.910.000.000.00170.91
Rivera, Allison, M,13751224.910.000.000.00224.91
Peterson, Alex, M,13423132.900.000.000.00132.90
Lee, Samantha, B,2737878.980.000.000.0078.98
Hughes, Eduardo,15564188.520.000.000.00188.52
Simmons, Dylan,16133107.850.000.000.00107.85
Russell, Jacqueline,18391100.960.000.000.00100.96
Brown, Anthony, J,19399151.430.000.000.00151.43
Thompson, Lucas, O,212774.990.000.000.004.99
Watson, Shelby, J,14911867.970.000.000.00867.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Sanders, Isaiah,2587339.980.000.000.0039.98
Gray, Mariah,222787.280.000.000.007.28
Chen, Luis, G,2125294.450.000.000.0094.45
Washington, Aaron, L,246494.990.000.000.004.99
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Perry, Jonathan, T,27026699.100.00699.100.000.00
Diaz, Faith, M,2236356.970.000.000.0056.97
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Martin, James, M,1987077.250.000.000.0077.25
Perry, Olivia,203754438.380.000.002071.422366.96
Roberts, Jordan, M,1680039.250.000.000.0039.25
Thomas, Victoria, A,15536249.530.000.000.00249.53
Wright, Robert, C,158894848.030.000.000.004848.03
Hughes, Stephanie,263161000.440.000.001000.440.00
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Torres, Dalton,235037.280.000.000.007.28
Edwards, Hunter,2422067.930.000.000.0067.93
Griffin, Thomas, J,19015125.430.000.000.00125.43
Rodriguez, Natalie,2077330.970.000.000.0030.97
Peterson, Mason, A,185701174.480.000.000.001174.48
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Richardson, Devin, G,2131836.960.000.000.0036.96
Evans, Maria,22544127.280.000.00127.280.00
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Moreno, Marie,2773969.990.000.000.0069.99
Campbell, Lucas,2932953.990.000.000.0053.99
Nelson, Henry,193941155.480.000.000.001155.48
Price, Jocelyn, D,258752443.350.000.002443.350.00
Zhang, Nathan, L,2910478.980.000.000.0078.98
Collins, Nathan, F,197041143.460.000.000.001143.46
Bradley, Evan,18506101.940.000.000.00101.94
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Davis, James,11922275.500.000.000.00275.50
Allen, Madeline,2924068.970.000.000.0068.97
Johnson, Christopher,119794813.760.000.000.004813.76
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Rogers, Jared, J,12166162.220.000.000.00162.22
Kelly, Trinity,2609515.230.000.000.0015.23
Russell, Samantha,11211723.560.000.0064.47659.09
Hill, Eric, G,2525667.930.000.000.0067.93
Peterson, Steven, L,234497.280.000.000.007.28
Hall, Morgan,2172641.950.000.000.0041.95
Yang, Jordan, K,14458133.950.000.000.00133.95
Hughes, Luis,130841798.960.000.000.001798.96
Perry, Marcus, L,206563245.900.000.002071.421174.48
Cook, Seth,2301064.470.000.000.0064.47
Jenkins, Megan, R,12074261.380.000.000.00261.38
Baker, Eduardo,180921789.450.000.000.001789.45
Hernandez, Marcus,185952329.990.000.000.002329.99
Ross, Haley, T,253612443.350.002443.350.000.00
Hughes, Antonio, P,15913712.270.000.000.00712.27
Washington, Elijah, L,250164.990.000.000.004.99
Jai, Adam,250952443.350.002443.350.000.00
Williams, Ryan, R,222475978.610.003578.270.002400.34
Carter, Jose, H,12532235.720.000.000.00235.72
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Harris, Megan,232814828.110.003578.270.001249.84
Walker, Jasmine,134604693.040.000.000.004693.04
Washington, Ryan,2833294.480.000.000.0094.48
Powell, Miranda, J,153044843.000.000.000.004843.00
Yang, Aaron, C,2519654.980.000.000.0054.98
Anderson, Tyler, E,131481137.430.000.000.001137.43
Li, Eugene, A,15283865.950.000.000.00865.95
Cox, Julia, A,206703228.570.000.002049.101179.47
Russell, Megan,16220562.960.000.000.00562.96
Williams, Ian, M,175581750.470.000.000.001750.47
Evans, Gabriel,2348789.970.000.000.0089.97
_SUM1806517.5025543.71493581.21255086.351032306.23
Diaz, Luke,12054402.530.000.00124.99277.54
Bryant, Nathan,2145059.980.000.000.0059.98
Taylor, Brianna,17027230.900.000.0051.96178.94
White, Greg, C,174032322.280.000.000.002322.28
Johnson, Andrew, F,262942443.350.000.002443.350.00
Bradley, Jocelyn,230227.280.000.000.007.28
Parker, Katherine,13268289.700.000.000.00289.70
Powell, Katherine, C,14574177.600.000.000.00177.60
Suarez, Juan, R,167631700.990.000.000.001700.99
Flores, Cassidy, L,233684.990.000.000.004.99
Evans, Connor, J,15402131.550.000.000.00131.55
Perry, Ryan,132494795.340.000.000.004795.34
Patterson, Hailey, I,112231155.900.000.0064.981090.92
Bailey, Jessica, L,12945218.440.000.000.00218.44
Baker, Sean, T,247782858.490.002181.560.00676.93
Winston, Ethan, R,216222612.060.000.002049.10562.96
James, Maria,1624391.970.000.000.0091.97
Harris, Isabella,17119214.900.000.000.00214.90
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Garcia, Victoria, V,245013578.270.003578.270.000.00
Miller, Destiny,251577.280.000.000.007.28
Jai, Luis, A,18320185.920.000.000.00185.92
Garcia, Xavier, M,2030071.970.000.000.0071.97
Sanchez, Rachel, C,267304.990.000.000.004.99
Edwards, Alexandra,133582386.940.000.000.002386.94
Martin, Alfredo, P,2148039.980.000.000.0039.98
Walker, Isabella,243864143.740.003578.27565.470.00
Bell, Christina,2609939.980.000.000.0039.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Howard, Morgan, T,229713578.270.003578.270.000.00
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Robinson, Abigail, R,183792362.270.000.000.002362.27
Cooper, Angela,195261179.470.000.000.001179.47
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Gonzales, Jordan,2368113.980.000.000.0013.98
Phillips, Mackenzie,12444228.430.000.000.00228.43
Phillips, Aaron, R,2494739.980.000.000.0039.98
Wright, Kyle,2371626.970.000.000.0026.97
Long, Chloe,167841735.980.000.000.001735.98
Patterson, Alexis,213484392.020.000.002049.102342.92
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Morgan, Isaiah,18978118.730.000.000.00118.73
Ross, Antonio,18322148.890.000.000.00148.89
Young, Julia, J,274144.990.000.000.004.99
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Lee, William,13185149.840.000.000.00149.84
Gray, Sara,292472447.050.000.000.002447.05
Wood, Brittany,2877753.990.000.000.0053.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Alexander, Taylor,17482146.940.000.000.00146.94
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Patricia,11651226.430.000.000.00226.43
Jai, Logan, H,12031769.490.000.000.00769.49
Long, Rachel,2828339.980.000.000.0039.98
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Morris, Paige, W,220414167.233578.270.000.00588.96
Richardson, Melissa, E,111322371.940.000.000.002371.94
Carter, Jonathan,14578848.470.000.000.00848.47
Reed, Erin, I,14353128.840.000.000.00128.84
Alexander, Ryan, J,14078839.480.000.00839.480.00
Washington, Kayla, E,14655174.960.000.000.00174.96
Reed, Sean, L,145974803.310.000.000.004803.31
Howard, Isaiah,259813018.330.000.002443.35574.98
White, Miguel, S,13988195.520.000.000.00195.52
Prasad, Erick, E,28786127.950.000.000.00127.95
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Hayes, Gavin, A,194001179.470.000.000.001179.47
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Martin, Nicholas,233627.280.000.000.007.28
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Alexander, Edward, E,18524195.950.000.000.00195.95
Barnes, Fernando,113001390.550.000.0073.871316.68
White, Cameron,238304802.110.003578.270.001223.84
Lewis, Christopher,1875586.960.000.000.0086.96
Green, Isabella,26620699.10699.100.000.000.00
Flores, Julia, E,172631700.990.000.000.001700.99
Watson, Erin, B,227724.990.000.000.004.99
James, Richard, D,15760109.230.000.000.00109.23
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Davis, Marcus, T,17337123.910.000.000.00123.91
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Bell, Danielle,140414765.020.000.000.004765.02
Butler, Benjamin, C,189722369.970.000.000.002369.97
Blanco, Armando, F,139182397.950.000.000.002397.95
Moore, Matthew, W,13267109.950.000.000.00109.95
Brown, Fernando,1900191.950.000.000.0091.95
Hayes, Dalton, C,188822322.280.000.000.002322.28
Hernandez, Sierra,27393123.980.000.000.00123.98
Alexander, Sarah,1941129.990.000.000.0029.99
Johnson, James,234984.990.000.000.004.99
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Long, Jordyn,1733847.250.000.000.0047.25
Zukowski, Jake,220584118.260.003578.270.00539.99
Robinson, Julia,28121119.980.000.000.00119.98
Long, Kaitlyn,233964891.610.003578.270.001313.34
Phillips, Andrea,1857383.740.000.000.0083.74
Lee, Don,188392384.970.000.000.002384.97
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Washington, Alexis,1978146.260.000.007.2838.98
Martin, Joshua, A,276077.280.000.000.007.28
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Ramos, Derrick,18449100.940.000.000.00100.94
Thomas, Jessica,1684894.480.000.0094.480.00
Green, Blake, P,11719287.200.000.000.00287.20
Anand, Brendan, L,1984721.980.000.000.0021.98
She, Shawn, J,16902141.980.000.000.00141.98
Russell, Katherine,2877169.990.000.000.0069.99
Turner, Andrea, A,202093268.550.002049.100.001219.45
Ward, Lucas, N,183631700.990.000.000.001700.99
Martin, Noah, A,1765775.970.000.000.0075.97
Lewis, Brianna, H,14282166.240.000.000.00166.24
Garcia, Rachel, L,129864823.010.000.000.004823.01
Griffin, Seth, R,17585164.460.000.000.00164.46
Watson, Olivia, S,1386093.850.000.0014.9878.87
Wu, Randy, J,116472365.940.000.000.002365.94
Hall, Charles,234764.990.000.000.004.99
Stewart, Julia, L,129022329.980.000.000.002329.98
Adams, Jennifer,153624745.020.000.000.004745.02
Powell, Jonathan,238584712.740.003578.270.001134.47
Serrano, Albert, E,133284708.020.000.000.004708.02
Foster, Kayla,1969371.950.000.000.0071.95
King, Aaron, L,117394758.030.000.002359.982398.05
Butler, Trevor,2741569.990.000.0069.990.00
Wang, Austin, A,1463284.970.000.000.0084.97
Scott, Adam,15863243.010.000.000.00243.01
Roberts, Hunter,282607.280.000.000.007.28
Brown, Jonathan,11875265.420.000.000.00265.42
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Morgan, Marcus, W,289682.290.000.000.002.29
Roberts, Amber, W,215822638.060.000.002049.10588.96
Green, Gabrielle, M,2181564.470.000.000.0064.47
Russell, Gail, L,212634.990.000.000.004.99
Flores, Caleb, S,12165280.640.000.00159.47121.17
Wilson, Fernando,16643126.960.000.000.00126.96
Hughes, Zachary,12203157.910.000.000.00157.91
Martin, Kellie, R,28195574.980.000.000.00574.98
Scott, Gabrielle,270614.990.000.000.004.99
Thomas, Ian,191181120.490.000.000.001120.49
Phillips, Luis, G,207347.280.000.000.007.28
Gonzales, Luis,15856116.250.000.0037.2778.98
Edwards, Eric,2462768.490.000.000.0068.49
Long, Xavier,112512318.960.000.000.002318.96
Powell, Elijah, E,231135997.330.003578.270.002419.06
Moore, Jessica, J,2008576.760.000.000.0076.76
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Edwards, Madeline,2077146.470.000.000.0046.47
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Wang, Zachary,2214489.970.000.000.0089.97
Jai, Edwin,169211754.980.000.000.001754.98
Allen, Allison, A,1975737.270.000.000.0037.27
Barnes, Haley, J,2133939.980.000.0039.980.00
Ashe, Alexis, S,194141145.480.000.000.001145.48
Murphy, Richard, M,222994145.540.003578.270.00567.27
Parker, Jordan,216212616.860.000.002049.10567.76

Generated 2025-12-22 04:14:46.467 UTC