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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Ramos, Kristi,151764703.030.000.000.004703.03
Sanchez, Alex, K,131014736.030.000.000.004736.03
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Peterson, Isabella,2808039.980.000.0039.980.00
Fernandez, Darren,2899278.980.000.000.0078.98
Peterson, Alex, M,13423132.900.000.000.00132.90
Perez, Jordan, A,292674.990.000.000.004.99
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Thomas, Victoria, A,15536249.530.000.000.00249.53
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Dominguez, Meghan,14370122.560.000.000.00122.56
Morgan, Jada, A,11520702.990.000.00137.45565.54
Young, Sierra, J,11619634.840.000.0034.99599.85
Davis, Marcus, T,17337123.910.000.0086.9536.96
Hall, Jan, M,11740334.120.000.00235.1598.97
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Evans, Dalton, E,127104774.040.000.002354.982419.06
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Deng, Wayne,2145336.960.000.0036.960.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Lopez, Jack, I,2904751.460.000.000.0051.46
Powell, Blake, J,2237139.980.000.000.0039.98
Peterson, Mason, A,185701174.480.000.001174.480.00
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Sanchez, Allison,1666741.720.000.000.0041.72
Anderson, Destiny,12895336.650.000.0037.27299.38
Johnson, Edward, H,23279124.990.000.000.00124.99
Cooper, Paige,14119148.940.000.000.00148.94
Clark, Lauren,170341750.980.000.000.001750.98
Campbell, Hailey,15507267.840.000.00228.9638.88
Thompson, Isabella,18756128.410.000.000.00128.41
Martinez, Matthew, L,16009170.450.000.000.00170.45
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Roberts, Seth, H,11510258.150.000.0039.47218.68
Hernandez, José, M,11253696.610.000.00187.94508.67
Lal, Luke, L,11019698.230.000.00139.93558.30
Perry, Ana,112151155.520.000.00432.39723.13
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Morgan, Timothy,14633242.500.000.0071.58170.92
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Hill, Blake,11748131.540.000.000.00131.54
Simmons, Jose,2464739.980.000.000.0039.98
Brown, Fernando,1900191.950.000.0069.9721.98
Parker, Morgan, S,1677236.960.000.0014.9821.98
Gray, Mariah,222787.280.000.007.280.00
Lee, William,13185149.840.000.0069.9779.87
Dominguez, Erika, C,21251191.270.000.000.00191.27
Clark, William,2902169.990.000.000.0069.99
Carter, Madeline, A,2752269.990.000.000.0069.99
Bell, Alex, M,167543118.600.000.00756.332362.27
Hughes, Eduardo,15564188.520.000.000.00188.52
Green, Samuel, D,14096174.730.000.000.00174.73
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Gill, Robyn, J,127651750.980.000.001750.980.00
Brooks, Lucas, S,16089342.030.000.000.00342.03
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Coleman, Logan,1868691.950.000.0069.9721.98
Hill, Jordan, J,16005198.730.000.00102.2796.46
Collins, Alex, S,287812.290.000.000.002.29
Sanders, Isaiah,2587339.980.000.000.0039.98
Hill, Haley, J,161033142.320.000.00792.342349.98
Cooper, Alexandra,19541131.240.000.000.00131.24
Garcia, Alexandra, J,14107819.460.000.00819.460.00
James, Juan,232674862.090.003578.271283.820.00
Gray, Brianna,249603008.820.002443.35565.470.00
Peterson, Melissa, S,249954.990.000.004.990.00
Martin, Joshua, A,276077.280.000.007.280.00
Jackson, Charles, P,112771305.660.000.00237.821067.84
Green, Eric,2738069.990.000.000.0069.99
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Phillips, Andrea,1857383.740.000.000.0083.74
Collins, Amanda,2078339.980.000.000.0039.98
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Lee, Ian,19646197.040.000.000.00197.04
Scott, Allison,14497804.480.000.000.00804.48
Collins, Isaac,260777.280.000.000.007.28
Ashe, Alexis, S,194141145.480.000.000.001145.48
Gonzales, Emily, P,21777180.980.000.000.00180.98
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Rivera, Amanda,11131115.920.000.000.00115.92
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Kennedy, Bridget,2202639.980.000.000.0039.98
Powell, Miranda, J,153044843.000.000.000.004843.00
Allen, Allison, A,1975737.270.000.000.0037.27
Cooper, Angela,195261179.470.000.000.001179.47
Flores, Kevin,15878225.920.000.0069.97155.95
Barnes, Ian, M,16106133.540.000.000.00133.54
White, Greg, C,174032322.280.000.000.002322.28
Taylor, Brianna,17027230.900.000.00145.4285.48
Rogers, Jade, I,14332102.250.000.000.00102.25
Thomas, Edward, E,19147133.710.000.000.00133.71
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Bailey, Olivia,238924.990.000.000.004.99
Jenkins, Austin, D,15748296.910.000.000.00296.91
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Long, Julia, R,228895971.330.003578.270.002393.06
Powell, Caleb, G,216132610.580.000.002049.10561.48
Lal, Kyle,17360122.180.000.000.00122.18
Brooks, Mariah,216202620.400.000.002071.42548.98
Allen, Sean, L,12097159.220.000.000.00159.22
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Gomez, Rebekah,13486225.440.000.000.00225.44
Wilson, Victoria, R,27536782.990.000.00782.990.00
Ramirez, Garrett, M,173881763.970.000.000.001763.97
King, Jordan, C,110202316.970.000.002316.970.00
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Patterson, Eric, A,2738478.980.000.000.0078.98
Jai, Jose,12944164.210.000.0039.99124.22
Roberts, Carlos,2319639.980.000.000.0039.98
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Prasad, Donald,15413318.920.000.00123.98194.94
Rivera, Sara,187852350.960.000.000.002350.96
Gonzalez, Morgan,130651700.990.000.000.001700.99
Gonzales, Jordan,2368113.980.000.000.0013.98
Flores, Gabriel,271117.280.000.000.007.28
Reed, Megan, A,181181750.980.000.000.001750.98
Hughes, Luis,130841798.960.000.000.001798.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Richardson, Evan, J,15488165.300.000.000.00165.30
Adams, Miguel,11659213.520.000.000.00213.52
Brown, Dylan, J,124492351.960.000.000.002351.96
Roberts, Jordan, M,1680039.250.000.000.0039.25
Alexander, Elijah,11738331.680.000.00141.73189.95
Brown, Julia,18065155.470.000.000.00155.47
Jackson, Brianna,1537797.910.000.0074.9822.93
Ward, Natalie, J,132412325.960.000.000.002325.96
Green, Xavier,2356739.980.000.000.0039.98
Patterson, Abigail, H,144784795.010.000.000.004795.01
Baker, Isaiah,12106169.540.000.000.00169.54
Lewis, Morgan,17410168.740.000.000.00168.74
Morgan, Juan, C,1882191.970.000.000.0091.97
Hughes, Edward,200234530.470.003374.990.001155.48
Garcia, Chloe, M,110372374.230.000.002374.230.00
Ross, Natalie, J,12916261.220.000.000.00261.22
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Torres, Mariah,16380195.950.000.000.00195.95
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Price, Caroline,180511735.980.000.000.001735.98
Campbell, Angel, D,195461174.480.000.000.001174.48
Baker, Eduardo,180921789.450.000.000.001789.45
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Price, Lauren, J,14079184.740.000.0037.29147.45
White, Tyler,14291258.440.000.0049.97208.47
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Adams, Jennifer,153624745.020.000.000.004745.02
Brooks, Steven, C,14877889.470.000.000.00889.47
Howard, Natalie,1349154.960.000.0014.9839.98
Hayes, Brittany,13941286.820.000.000.00286.82
Stewart, Melissa,2517336.960.000.000.0036.96
Henderson, Ashley,111851381.370.000.00232.801148.57
Torres, Victoria,17551160.920.000.000.00160.92
Edwards, Elijah, D,281577.280.000.000.007.28
Simmons, Anna, K,124512367.920.000.000.002367.92
Patterson, Eduardo,11142866.810.000.0072.26794.55
Miller, Eduardo,14561158.840.000.0049.97108.87
Mitchell, Evan, R,247314.990.000.000.004.99
Foster, Antonio,12795108.540.000.0066.2642.28
Griffin, Seth, R,17585164.460.000.0078.9885.48
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Taylor, Taylor,159054899.020.000.000.004899.02
Hall, Natalie, A,230704.990.000.004.990.00
Nath, Carl, H,29001624.970.000.000.00624.97
Diaz, Katherine, P,115262376.960.000.002376.960.00
Perry, Jackson, J,213064.990.000.000.004.99
Simmons, Adam,253274.990.000.000.004.99
Turner, Sean,227324133.240.003578.270.00554.97
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Bell, Chase,180911750.980.000.000.001750.98
Alexander, Angelica,2271471.950.000.000.0071.95
Collins, Luis, J,227655978.610.003578.270.002400.34
Foster, Caleb,27112114.460.000.000.00114.46
Perez, Dalton,110911125.360.000.00213.86911.50
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Sanchez, Stephanie,1786756.970.000.000.0056.97
Diaz, Faith, M,2236356.970.000.000.0056.97
Turner, Morgan,11823178.470.000.000.00178.47
Powell, Jordyn, K,153914828.010.000.000.004828.01
Smith, Katherine, J,13197105.190.000.000.00105.19
Walker, Richard, T,19640224.550.000.000.00224.55
Brooks, Evan,2340139.980.000.000.0039.98
Nelson, Jose,19217185.020.000.0091.9593.07
Butler, Isabel,16241126.960.000.000.00126.96
Luo, Donna, E,248054.990.000.000.004.99
Thompson, Xavier, R,15761192.410.000.000.00192.41
Rubio, Ruben, D,1887186.960.000.0086.960.00
Butler, Jonathan,261804.990.000.000.004.99
Carter, Jason,11724210.090.000.00113.8696.23
Gray, Cody, C,144594775.010.000.000.004775.01
Alexander, Jordan,2141259.980.000.0059.980.00
Russell, Samuel, V,11652310.930.000.000.00310.93
Ross, Jose,2744178.980.000.0078.980.00
Russell, Oscar, A,12140118.170.000.000.00118.17
Washington, Hannah, A,291307.280.000.007.280.00
Gonzalez, Molly,1637021.980.000.000.0021.98
Perry, Lauren,248164.990.000.000.004.99
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Diaz, Luis, D,11203801.770.000.00183.97617.80
Roberts, Noah, S,2704268.490.000.000.0068.49
Hughes, Zachary,12203157.910.000.000.00157.91
Perry, Christian,246714354.600.003578.270.00776.33
Shan, Gabriel, T,2773169.990.000.000.0069.99
White, Miguel, S,13988195.520.000.000.00195.52
Flores, Emma, P,15543180.940.000.000.00180.94
Lee, Kayla, M,2078115.230.000.000.0015.23
Collins, Hailey,11709325.890.000.0021.49304.40
Parker, Kaylee, M,2773878.980.000.000.0078.98
Ward, Ian,12056213.920.000.000.00213.92
Evans, James, C,206654408.560.000.002049.102359.46
Thomas, Jeremiah,183721760.470.000.000.001760.47
Reed, Michelle,2804669.990.000.000.0069.99
Rogers, Sean, G,18685124.460.000.000.00124.46
Srini, Ruben,18078200.940.000.0071.97128.97
Perry, Dalton, A,16149192.040.000.000.00192.04
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Johnson, Madison, L,15530846.460.000.000.00846.46
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Srini, Evelyn,16855150.950.000.000.00150.95
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Jai, Samuel, L,1635887.950.000.0039.9947.96
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Martin, Tyler, L,2772469.990.000.000.0069.99
Baker, Mason, A,132702394.950.000.000.002394.95
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Smith, Noah,13175166.920.000.000.00166.92
Martin, Katherine, J,2027339.980.000.000.0039.98
James, Christina,17409219.920.000.000.00219.92
Rivera, Hailey, R,2079239.980.000.000.0039.98
Wright, Katelyn, A,14502122.260.000.0014.98107.28
Hayes, Austin,202083219.580.002049.100.001170.48
Jones, Alexander, I,2002180.960.000.000.0080.96
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Ross, Antonio,18322148.890.000.000.00148.89
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Gomez, Briana, A,2878443.980.000.000.0043.98
Gonzales, Paige,2170291.940.000.0039.9851.96
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Howard, Alexandra,207363194.580.000.002049.101145.48
Simmons, Dylan,16133107.850.000.0038.8868.97
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Collins, Eduardo,139872329.990.000.000.002329.99
Townsend, Bryan,14077180.730.000.000.00180.73
Russell, Xavier,12964119.950.000.000.00119.95

Generated 2025-10-31 23:33:26.209 UTC