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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Chandra, Allen,2932753.990.000.000.0053.99
Hall, Wyatt,2382713.980.000.000.0013.98
Lal, Luke, L,11019698.230.000.00139.93558.30
Perez, Amber, D,13318214.260.000.00116.9197.35
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Howard, Alexandra,207363194.580.000.002049.101145.48
Foster, Abigail,1982346.470.000.000.0046.47
Jones, Natalie, A,11845197.200.000.0082.26114.94
Lewis, Seth,26782699.100.00699.100.000.00
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Martinez, Joseph, E,2921459.980.000.0059.980.00
Richardson, Melissa, E,111322371.940.000.000.002371.94
Barnes, Jeremy,2144654.980.000.000.0054.98
Jai, Kevin,1983678.960.000.0038.9839.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
Martin, Kellie, R,28195574.980.000.000.00574.98
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Green, Blake, P,11719287.200.000.000.00287.20
Alexander, Jason,2932849.990.000.000.0049.99
Bryant, Dakota, L,176132401.950.000.000.002401.95
Thomas, Seth,14567161.280.000.0096.0765.21
Diaz, Thomas, O,16020595.960.000.000.00595.96
Peterson, Xavier, R,2645639.980.000.000.0039.98
Yuan, Carly,19839194.960.000.000.00194.96
Gray, Sara,292472447.050.000.002447.050.00
Cox, Katelyn, B,2174230.970.000.000.0030.97
Johnson, Edward, H,23279124.990.000.000.00124.99
Miller, Katherine, B,27102782.990.000.00782.990.00
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
James, Sara,198023374.993374.990.000.000.00
Powell, David, W,266151000.440.000.001000.440.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Sanchez, Martin, E,216317.280.000.000.007.28
Thompson, Abigail,243324816.090.003578.270.001237.82
Martin, Morgan,248322181.560.002181.560.000.00
Jones, Joshua,184012294.990.000.000.002294.99
Morris, Mason, J,22349124.990.000.000.00124.99
Ortega, Javier, P,127852294.990.000.000.002294.99
Jai, Hunter, M,28272111.950.000.000.00111.95
Williams, Ethan,243094793.120.003578.270.001214.85
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Walker, Isabella,243864143.740.003578.27565.470.00
Wilson, Christian,27085782.990.000.00782.990.00
Kelly, Angel, E,15418232.230.000.000.00232.23
Brooks, Lucas, S,16089342.030.000.000.00342.03
Gonzalez, James, M,188421155.480.000.000.001155.48
Simmons, Dylan,16133107.850.000.0038.8868.97
Li, Thomas,181162376.960.000.000.002376.96
Watson, Erin, B,227724.990.000.004.990.00
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Turner, Eduardo,158764789.020.000.000.004789.02
Jones, Zachary, J,27285782.990.000.00782.990.00
Shan, Chad, M,2462112.940.000.000.0012.94
He, Micah,2740169.990.000.000.0069.99
Sandberg, Isaac,1335053.970.000.000.0053.97
Stewart, Marcus, R,2063221.980.000.000.0021.98
Smith, Lucas, P,1809064.910.000.000.0064.91
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Patterson, Abigail, H,144784795.010.000.000.004795.01
Young, Julia, J,274144.990.000.000.004.99
Taylor, Madison, A,11802215.290.000.00127.9687.33
Diaz, Hailey, W,116932294.990.000.002294.990.00
Sanders, Xavier,1672173.750.000.000.0073.75
Baker, Mason, A,132702394.950.000.000.002394.95
Ross, Natalie, J,12916261.220.000.000.00261.22
Morris, Chase, F,26789699.100.00699.100.000.00
Ross, Jose,2744178.980.000.0078.980.00
Xu, Louis,2010466.530.000.0066.530.00
Brooks, Ian, W,2829064.470.000.000.0064.47
Price, Marissa,15826160.740.000.00120.4840.26
Hu, Gilbert, L,2876769.990.000.000.0069.99
Stewart, Sara,17347119.720.000.000.00119.72
Roberts, Amanda,171752334.980.000.000.002334.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Adams, Jennifer,153624745.020.000.000.004745.02
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Johnson, Madison, L,15530846.460.000.000.00846.46
Yang, Justin, S,153634719.040.000.000.004719.04
Henderson, Caroline,2008256.970.000.000.0056.97
Nelson, Sean,11841307.970.000.000.00307.97
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Townsend, Bryan,14077180.730.000.000.00180.73
Ruiz, Philip,1807781.460.000.000.0081.46
Jackson, Hannah, G,131432404.970.000.000.002404.97
Thomas, Thomas,216292624.080.000.002049.10574.98
Ramos, Derrick,18449100.940.000.0030.9769.97
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Walker, Ian,16771104.550.000.0054.5849.97
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Clark, William,2902169.990.000.000.0069.99
Suri, Carolyn, S,12972175.710.000.000.00175.71
Smith, Katherine, J,13197105.190.000.000.00105.19
She, Martha, E,222515971.330.003578.270.002393.06
Carter, Katherine,11861286.300.000.000.00286.30
Price, Rachel, D,2532889.970.000.000.0089.97
Richardson, Olivia,204683169.590.000.002049.101120.49
Zhao, Clarence, R,1982671.970.000.0071.970.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
White, Tyler,14291258.440.000.0049.97208.47
Allen, Jack, M,291372419.060.000.002419.060.00
Carter, Isaac,137191129.480.000.000.001129.48
Edwards, Eric,2462768.490.000.000.0068.49
Roberts, Wyatt,15900699.970.000.00699.970.00
Washington, Hailey, S,2588559.980.000.000.0059.98
Moore, Jessica, J,2008576.760.000.000.0076.76
Simmons, Jose,2464739.980.000.000.0039.98
Gray, Jesse,14626197.040.000.000.00197.04
Wright, Robert, C,158894848.030.000.000.004848.03
Bryant, Samantha,18345115.470.000.000.00115.47
Johnson, Cameron, R,137201155.480.000.000.001155.48
Adams, Haley, M,247862443.350.002443.350.000.00
White, Nicole,16731155.910.000.0084.9670.95
Hughes, Miranda,266784.990.000.000.004.99
Jai, Samuel, L,1635887.950.000.0039.9947.96
Flores, Zachary, H,233765314.250.003578.270.001735.98
Williams, Joshua,260514.990.000.000.004.99
Chow, Candice,1923260.960.000.000.0060.96
Walker, Hunter,271007.280.000.000.007.28
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Moreno, Lance, A,2922939.980.000.000.0039.98
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Wilson, Emily,174002331.950.000.000.002331.95
Wang, Austin, A,1463284.970.000.009.9974.98
Dominguez, Meghan,14370122.560.000.000.00122.56
Gonzales, Jordan,2368113.980.000.000.0013.98
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Flores, Megan, N,230746021.820.003578.270.002443.55
Hill, Katherine, L,2670139.980.000.000.0039.98
Foster, Jessica,2606951.460.000.0051.460.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Scott, Sean, F,2475539.980.000.000.0039.98
Collins, Xavier, C,16646250.910.000.000.00250.91
Bell, Gabrielle,223735976.320.003578.270.002398.05
Wilson, Grace,17539205.920.000.000.00205.92
Perez, Timothy, L,227304.990.000.000.004.99
Moore, Chloe, L,2626913.980.000.000.0013.98
Hill, Blake,11748131.540.000.000.00131.54
Miller, Andrew, C,271104.990.000.000.004.99
Carter, Luis, E,258832443.350.002443.350.000.00
Russell, Caleb,23552103.480.000.000.00103.48
Sanchez, Shelby,16021539.990.000.000.00539.99
James, Maria,1624391.970.000.0069.9921.98
Hall, Jan, M,11740334.120.000.00235.1598.97
Kumar, Zachary,254334.990.000.000.004.99
Ward, Cole,214907.280.000.000.007.28
Smith, Megan, J,2671668.970.000.000.0068.97
Lewis, Ethan,27998144.470.000.000.00144.47
Coleman, Joan, W,2669964.470.000.000.0064.47
Thomas, Victoria, A,15536249.530.000.000.00249.53
Powell, Jordyn, K,153914828.010.000.000.004828.01
Ward, Emma, W,2179659.980.000.000.0059.98
Li, Brandon,2933973.960.000.000.0073.96
Torres, Haley, W,232834828.110.003578.270.001249.84
Hall, Fernando,2210090.950.000.000.0090.95
Chen, David,2720839.980.000.000.0039.98
Davis, Jonathan,2925913.980.000.000.0013.98
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Russell, Arianna,22728149.930.000.00149.930.00
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Reed, Paige,221126047.320.003578.272469.050.00
Bradley, Nathaniel,169551760.470.000.000.001760.47
Sanchez, Grace,120802354.990.000.000.002354.99
Harris, Natalie,2368259.980.000.0059.980.00
Russell, Oscar, A,12140118.170.000.000.00118.17
Foster, Emma,15468436.350.000.00159.99276.36
Moore, Jonathan,2047896.460.000.000.0096.46
Perry, Christian,246714354.600.003578.270.00776.33
Coleman, Jose, S,253494.990.000.000.004.99
Martin, James, M,1987077.250.000.000.0077.25
Thompson, Ethan,199894495.480.003374.990.001120.49
Perry, Melissa,221284142.230.003578.270.00563.96
Wilson, Daniel, K,142814746.300.000.000.004746.30
Russell, Jessica,265721000.440.000.001000.440.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Cooper, Amanda, P,146064716.020.000.000.004716.02
Stewart, Julia, L,129022329.980.000.000.002329.98
Cook, Seth,2301064.470.000.000.0064.47
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Peterson, Melissa, S,249954.990.000.004.990.00
Bradley, Evan,18506101.940.000.000.00101.94
Hall, Morgan,2172641.950.000.000.0041.95
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Rogers, Amanda, A,13920266.970.000.000.00266.97
She, Shawn, J,16902141.980.000.000.00141.98
Campbell, Lucas,2932953.990.000.000.0053.99
Mitchell, Savannah,261153052.800.000.002443.35609.45
Taylor, Marcus, A,18944146.940.000.000.00146.94
Diaz, Katherine, P,115262376.960.000.002376.960.00
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Stewart, Melissa,2517336.960.000.000.0036.96
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Anderson, Megan, A,238594153.250.003578.27574.980.00
Diaz, Alyssa,139084715.330.000.000.004715.33
Martin, Alfredo, P,2148039.980.000.000.0039.98
Cooper, Brooke,195361120.490.000.000.001120.49
Davis, James,11922275.500.000.0034.98240.52
Sanders, Paige,252872983.340.002443.350.00539.99
Hughes, Julia,250612443.350.002443.350.000.00
Cox, Arianna, D,1892789.250.000.000.0089.25
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Deng, Damien, A,16873578.460.000.000.00578.46
Williams, Edward, D,14274121.560.000.000.00121.56
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Ward, Kaylee, A,244154.990.000.004.990.00
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Martin, Lucas, L,221144183.233578.270.000.00604.96
Thomas, Ian,191181120.490.000.000.001120.49
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Martinez, Jonathan,1330366.250.000.000.0066.25
Huang, Kristen,251002443.350.002443.350.000.00
Lewis, Morgan,17410168.740.000.000.00168.74
Flores, Arianna,217274132.243578.270.000.00553.97
Hughes, Stephanie,263161000.440.001000.440.000.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Coleman, Luke, A,11723152.550.000.0069.9882.57
Clark, Lauren,170341750.980.000.000.001750.98
Patterson, Eduardo,11142866.810.000.0072.26794.55
White, Miguel, S,13988195.520.000.000.00195.52
Adams, Gabriel, S,195271219.450.000.000.001219.45
Jenkins, Austin, D,15748296.910.000.000.00296.91
Coleman, Stephanie,2226489.970.000.000.0089.97
Perry, Marcus, L,206563245.900.000.002071.421174.48
Scott, Adam,15863243.010.000.000.00243.01
Hill, Sydney,264821000.440.000.001000.440.00
Flores, Nathan, C,2463713.980.000.000.0013.98
Collins, Hailey,11709325.890.000.0021.49304.40
Lee, Don,188392384.970.000.000.002384.97
Turner, James, E,16841126.960.000.0069.9956.97
Diaz, Gabrielle,14893839.480.000.000.00839.48
Stewart, Jessica,16097103.550.000.0046.5856.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Simmons, Adam,253274.990.000.000.004.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Phillips, Jack, R,259952443.350.000.002443.350.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Sanchez, Faith,270494.990.000.000.004.99
Diaz, Luke,12054402.530.000.00139.97262.56
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Miller, Chloe, V,228936056.510.003578.272478.240.00
Miller, Alexis, A,12196124.930.000.000.00124.93

Generated 2025-11-04 08:02:48.714 UTC