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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Taylor, Taylor,159054899.020.000.000.004899.02
Mitchell, Lucas, C,198294533.450.003374.990.001158.46
Price, Isabelle,201825749.970.003374.990.002374.98
Thompson, Abigail,243324816.090.003578.270.001237.82
Phillips, Adam, R,227484188.240.003578.270.00609.97
Walker, Emma, M,2520998.960.000.000.0098.96
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Griffin, Thomas, J,19015125.430.000.000.00125.43
Martin, John, A,144364776.010.000.000.004776.01
Suri, Carolyn, S,12972175.710.000.000.00175.71
Jai, Connor, D,27253782.990.000.00782.990.00
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Long, Gavin,13762186.030.000.000.00186.03
Watson, Richard,15943365.410.000.000.00365.41
Gonzalez, Morgan,130651700.990.000.000.001700.99
Davis, James,11922275.500.000.000.00275.50
Bell, Timothy, J,2810178.980.000.000.0078.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Torres, Mariah,16380195.950.000.000.00195.95
She, Kenneth,16096212.010.000.000.00212.01
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Sharma, Samuel,27725119.980.000.000.00119.98
Thompson, Xavier, R,15761192.410.000.000.00192.41
Alexander, Elijah,11738331.680.000.0049.48282.20
Phillips, Mackenzie,12444228.430.000.000.00228.43
Robinson, Ian, D,138522294.990.000.000.002294.99
Morris, Paige, W,220414167.233578.270.000.00588.96
Lewis, Ryan, A,203124.990.000.000.004.99
Howard, Isaiah,259813018.330.000.002443.35574.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Russell, Isabella, A,11507645.780.000.000.00645.78
Harris, Noah,292562393.060.000.000.002393.06
Thomas, William, A,216142589.090.000.002049.10539.99
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Jones, Madison,246614181.760.003578.27603.490.00
Robinson, Lauren,2719668.490.000.000.0068.49
Brown, Fernando,1900191.950.000.000.0091.95
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Ross, David, M,171431763.970.000.000.001763.97
Hall, Lauren, A,19648100.840.000.000.00100.84
Coleman, Samuel, N,17450123.980.000.000.00123.98
Flores, Caleb, S,12165280.640.000.00159.47121.17
King, Caleb, J,2898678.980.000.000.0078.98
Price, Miranda,26629699.100.00699.100.000.00
Moore, Andrew, A,13944150.130.000.0036.27113.86
Perez, Sydney, C,221174158.240.003578.270.00579.97
Lal, Caleb, R,1586874.460.000.000.0074.46
Harris, Natalie,2368259.980.000.000.0059.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Simmons, Sarah, V,11500651.980.000.0034.99616.99
Edwards, Logan,250024.990.000.000.004.99
Jai, Luis, A,18320185.920.000.000.00185.92
Turner, Jose,11784272.690.000.000.00272.69
Foster, Aaron,155664912.470.000.000.004912.47
Harrison, Trevor, A,18055143.910.000.000.00143.91
Alexander, Aidan,17387148.190.000.000.00148.19
Zhang, Connor, R,138532329.980.000.000.002329.98
Rogers, Shelby,11712127.800.000.0032.6095.20
Bailey, Olivia,238924.990.000.000.004.99
Hall, Eduardo,16847189.940.000.000.00189.94
Evans, Jesse,2191639.980.000.000.0039.98
Williams, Ryan, R,222475978.610.003578.270.002400.34
Alexander, Julian,132172351.960.000.000.002351.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Hayes, Luis,12880200.730.000.000.00200.73
Chen, Jonathan, G,13096200.690.000.000.00200.69
Hall, Jan, M,11740334.120.000.000.00334.12
Wu, Randy, J,116472365.940.000.000.002365.94
Thomas, David,168363193.790.000.000.003193.79
Gonzales, Nathan, M,12107222.230.000.000.00222.23
Hughes, Zachary,12203157.910.000.000.00157.91
Ashe, Alexis, S,194141145.480.000.000.001145.48
Kelly, Bailey, R,28284563.770.000.000.00563.77
Cook, Seth,2301064.470.000.000.0064.47
Chow, Candice,1923260.960.000.000.0060.96
Powell, Jasmine, A,11505846.770.000.000.00846.77
Watson, Emma,17481126.940.000.000.00126.94
Hernandez, Jamie,27283119.980.000.000.00119.98
Griffin, Miguel,2146476.970.000.000.0076.97
Young, Kaylee, S,13756298.490.000.000.00298.49
Nelson, Luis,234884.990.000.000.004.99
Lee, Ian,19646197.040.000.000.00197.04
Lazecky, Petr,258642443.350.000.002443.350.00
Adams, Mason, T,2052864.470.000.000.0064.47
Brown, Dalton, N,218134118.260.003578.270.00539.99
Garcia, Anna, B,15572104.550.000.000.00104.55
Martin, Jill, C,11824181.030.000.000.00181.03
Garcia, Christian, J,164913106.330.000.00751.342354.99
Brooks, Mariah,216202620.400.000.002071.42548.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
Hill, Sydney,264821000.440.000.001000.440.00
Harris, Matthew,14330806.760.000.000.00806.76
Parker, James,11808610.190.000.000.00610.19
Wang, Austin, A,1463284.970.000.000.0084.97
Simmons, Anna, K,124512367.920.000.000.002367.92
Patterson, Maria, G,1333094.950.000.000.0094.95
Williams, Sydney, J,15334848.470.000.000.00848.47
Griffin, Maria,1840763.250.000.000.0063.25
Henderson, Logan, C,2236656.970.000.000.0056.97
Phillips, James, G,16846180.950.000.000.00180.95
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Cooper, Ariana,17348205.420.000.000.00205.42
Fernandez, Cesar,200355694.980.003374.990.002319.99
Taylor, Zachary, M,27082782.990.000.00782.990.00
Cooper, Angela,195261179.470.000.000.001179.47
Simmons, Jennifer,112621010.560.000.000.001010.56
Lal, Kyle,17360122.180.000.000.00122.18
Edwards, Connor,16950211.010.000.000.00211.01
Suarez, Juan, R,167631700.990.000.000.001700.99
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Johnson, Edward, H,23279124.990.000.000.00124.99
Robinson, Zachary, L,137092332.280.000.000.002332.28
Rivera, Sara,187852350.960.000.000.002350.96
Lopez, Jack, I,2904751.460.000.000.0051.46
Foster, Isabel, M,2174571.950.000.000.0071.95
Evans, Elijah, S,2588439.980.000.000.0039.98
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Li, Kevin, S,2518813.980.000.000.0013.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Hill, Jordan, J,16005198.730.000.000.00198.73
Shan, Chad, M,2462112.940.000.000.0012.94
Smith, Megan, J,2671668.970.000.000.0068.97
Davis, Justin,2807412.940.000.000.0012.94
Walker, Destiny, M,169961754.980.000.000.001754.98
Turner, Amanda, L,203183241.900.002071.420.001170.48
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Hill, Blake,11748131.540.000.000.00131.54
Hughes, Austin, P,183681754.980.000.000.001754.98
Wright, Robert, C,158894848.030.000.000.004848.03
Bradley, Melanie, G,133434720.270.000.000.004720.27
Turner, Wyatt,200345769.960.003399.990.002369.97
Gray, Marcus, T,183892401.450.000.000.002401.45
Russell, Katherine,2877169.990.000.000.0069.99
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Lee, William,13185149.840.000.000.00149.84
Hayes, Gavin, A,194001179.470.000.000.001179.47
Gray, Isabella,168203217.790.000.000.003217.79
Ross, Natalie, J,12916261.220.000.000.00261.22
Roberts, Amber, W,215822638.060.000.002049.10588.96
Ramos, Kristi,151764703.030.000.000.004703.03
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Wang, Karen, P,1955331.970.000.000.0031.97
James, Maria,1624391.970.000.000.0091.97
Brown, Christian,227554.990.000.000.004.99
Lewis, Christopher,1875586.960.000.000.0086.96
Carter, Isaac,137191129.480.000.000.001129.48
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Long, Kaitlyn,233964891.610.003578.270.001313.34
Harris, Samantha, A,244874.990.000.000.004.99
Hughes, Nathan, B,121134737.530.000.000.004737.53
Andersen, Latoya, J,290578.990.000.000.008.99
James, Julia,2497567.930.000.000.0067.93
Flores, Miguel,1975077.250.000.000.0077.25
Hall, Kaylee, E,1975137.270.000.000.0037.27
Carter, Bailey,213322616.860.000.002049.10567.76
Moreno, Marie,2773969.990.000.000.0069.99
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Wang, Benjamin, R,274547.280.000.000.007.28
Taylor, Tyler, A,12032614.960.000.000.00614.96
Scott, Kaitlyn, A,12159218.910.000.000.00218.91
Rubio, Ruben, D,1887186.960.000.0056.9729.99
Morgan, Andrea, M,16870149.040.000.0039.47109.57
Hall, Luke, E,14745902.460.000.000.00902.46
Nelson, Sean,11841307.970.000.000.00307.97
Phillips, Miguel,2049812.940.000.000.0012.94
Nelson, Sierra,161322459.620.000.002459.620.00
Lewis, Rachel, J,14900839.480.000.000.00839.48
Hill, Fernando,247634.990.000.000.004.99
Raje, Mindy, A,16083561.970.000.000.00561.97
Thompson, Lucas, O,212774.990.000.000.004.99
Reed, Paige,221126047.320.003578.270.002469.05
Alexander, Jordan,2141259.980.000.0059.980.00
Miller, Sydney, A,134404818.530.000.000.004818.53
Thomas, Isabella, M,27265782.990.000.00782.990.00
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Flores, Madison,14416769.490.000.000.00769.49
Williams, Austin,2035432.220.000.000.0032.22
Parker, Morgan, S,1677236.960.000.000.0036.96
Campbell, Kevin, S,121774811.500.000.000.004811.50
Collins, Lucas, T,219214142.750.003578.270.00564.48
Hayes, Jason,261764.990.000.000.004.99
Yang, Thomas, A,14108839.480.000.000.00839.48
Simmons, Adam,253274.990.000.000.004.99
Ward, Cole,214907.280.000.000.007.28
Washington, Robert, J,14906143.950.000.000.00143.95
Powell, Spencer,14904468.120.000.000.00468.12
Davis, Emily,27267782.990.000.00782.990.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Adams, Kyle, E,1881269.990.000.000.0069.99
Sanders, Alexandra,259112181.560.000.002181.560.00
Thompson, Devin,207084406.400.000.002071.422334.98
Long, Elizabeth, F,127822400.950.000.000.002400.95
Garcia, Chloe, M,110372374.230.000.002374.230.00
Richardson, Arianna, C,1205534.980.000.000.0034.98
James, Sara,198023374.993374.990.000.000.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Smith, John,198555709.960.003399.990.002309.97
Garcia, Isabella,18382204.940.000.000.00204.94
Sanz, Lori, L,238654891.610.003578.270.001313.34
Diaz, Luis, D,11203801.770.000.000.00801.77
Lal, Robert, L,14084138.680.000.000.00138.68
Gray, Sebastian, B,138782366.960.000.000.002366.96
Murphy, Maria,160113657.260.000.000.003657.26
Scott, Sean, F,2475539.980.000.000.0039.98
Moore, Fernando,265821000.440.000.001000.440.00
Washington, Riley, L,185441155.480.000.001155.480.00
Martin, Joshua, A,276077.280.000.000.007.28
Hall, Wyatt,2382713.980.000.000.0013.98
Young, Jenna, W,163652490.180.000.000.002490.18
Smith, Tyler, J,2034156.970.000.000.0056.97
Parker, Kaylee, M,2773878.980.000.000.0078.98
Powell, Miranda, J,153044843.000.000.000.004843.00
Bell, Eduardo,27101782.990.000.00782.990.00
Washington, Elijah, L,250164.990.000.000.004.99
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Morgan, Isaiah,18978118.730.000.000.00118.73
Gonzales, Luis,15856116.250.000.0037.2778.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Scott, Allison,14497804.480.000.000.00804.48
Sanchez, Rachel, C,267304.990.000.000.004.99
Hughes, Anna,197052341.970.000.000.002341.97
Lal, Jack, R,185251735.980.000.000.001735.98
Torres, Mackenzie,28153570.470.000.000.00570.47
Reed, Melanie, A,28160574.980.000.000.00574.98
Anderson, Emma, A,185801170.480.000.000.001170.48
Peterson, Mason, A,185701174.480.000.000.001174.48
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Carter, Katherine,11861286.300.000.000.00286.30
Clark, Anthony,27071782.990.000.00782.990.00
Powell, Elijah, E,231135997.330.003578.270.002419.06
Flores, Devin, A,15559172.040.000.000.00172.04
Coleman, Joan, W,2669964.470.000.000.0064.47
Long, Jordan,199884555.470.003399.990.001155.48
Deng, Wayne,2145336.960.000.000.0036.96
Peterson, Brian,12892419.470.000.000.00419.47
Richardson, Charles, I,121144719.020.000.000.004719.02
Hughes, Julia,250612443.350.002443.350.000.00
Parker, Jeremy,2866878.980.000.000.0078.98
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Washington, Hailey, S,2588559.980.000.000.0059.98
Allen, Angel, G,15571101.850.000.0034.8966.96
Reed, Isaac, D,260747.280.000.000.007.28
Kelly, Erin, D,2351364.470.000.000.0064.47
Lee, Emma,16948176.430.000.000.00176.43
Perry, James,192051249.840.000.000.001249.84
King, Morgan,196811179.970.000.000.001179.97
Russell, Samantha,11211723.560.000.0064.47659.09
Washington, Thomas, C,2745137.430.000.000.0037.43

Generated 2025-12-21 15:42:39.370 UTC