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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Gonzales, Jordan,2368113.980.000.000.0013.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Russell, Xavier,12964119.950.000.000.00119.95
Russell, Samantha,11211723.560.000.00118.46605.10
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Foster, Isabelle,2637739.980.000.000.0039.98
Turner, Eduardo,158764789.020.000.000.004789.02
Zukowski, Jake,220584118.263578.270.000.00539.99
Garcia, Henry, B,112871009.240.000.00219.26789.98
Sun, Arturo, C,11498557.540.000.00151.90405.64
Jenkins, Samantha,113311290.330.000.00410.31880.02
Cooper, Brooke,195361120.490.000.000.001120.49
Powell, Jack, J,1841156.960.000.000.0056.96
Turner, Jose,11784272.690.000.000.00272.69
Rivera, Allison, M,13751224.910.000.000.00224.91
Foster, Jose, C,2878534.990.000.000.0034.99
Rogers, Carlos,19645134.440.000.000.00134.44
Turner, Kaylee, M,16213154.540.000.000.00154.54
Smith, Austin,13707149.050.000.000.00149.05
Evans, Connor, J,15402131.550.000.000.00131.55
Allen, Allison, A,1975737.270.000.000.0037.27
Flores, Kevin,15878225.920.000.0069.97155.95
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Rodriguez, Richard,12969180.790.000.000.00180.79
Rivera, Amanda,11131115.920.000.000.00115.92
Walker, Brandon, J,159164793.270.000.000.004793.27
Davis, Nicholas,1320173.160.000.000.0073.16
Evans, Alexandra,2432268.490.000.000.0068.49
Perez, Timothy, L,227304.990.000.000.004.99
Griffin, Marcus,2075634.560.000.000.0034.56
Parker, Katherine,13268289.700.000.0068.97220.73
Jai, Jose,12944164.210.000.0039.99124.22
James, Zoe, R,14611304.550.000.000.00304.55
Simmons, Adam,253274.990.000.000.004.99
Morgan, Jada, A,11520702.990.000.00137.45565.54
Young, Kaylee, S,13756298.490.000.0058.47240.02
Cooper, Grace, C,1601294.260.000.000.0094.26
Martin, James, M,1987077.250.000.000.0077.25
Ross, Natalie, J,12916261.220.000.000.00261.22
Thompson, Devin,207084406.400.000.002071.422334.98
Foster, Aaron,155664912.470.000.000.004912.47
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Chandra, Brandy, P,11501603.530.000.0098.23505.30
Russell, Isabella, A,11507645.780.000.0028.48617.30
Jones, Natalie, A,11845197.200.000.0082.26114.94
Hayes, Brittany,13941286.820.000.000.00286.82
Ward, Natalie, J,132412325.960.000.000.002325.96
Nath, Kenneth, W,170372334.970.000.000.002334.97
Thompson, Kayla, D,12363273.900.000.000.00273.90
James, Jeremiah, S,11661287.700.000.000.00287.70
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Stewart, Lucas, J,2934198.970.000.000.0098.97
Simmons, Nicole, S,2617729.480.000.000.0029.48
Kelly, Angel, E,15418232.230.000.000.00232.23
Diaz, Faith, M,2236356.970.000.000.0056.97
Sanchez, Shelby,16021539.990.000.000.00539.99
Rowe, Todd,14586233.940.000.000.00233.94
Perry, Christian,246714354.600.003578.270.00776.33
Campbell, Evan, W,243424828.110.003578.270.001249.84
Lewis, Zachary, L,14760167.260.000.000.00167.26
Sanders, Allison, B,18852268.250.000.000.00268.25
Barnes, Fernando,113001390.550.000.00248.381142.17
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Flores, Hannah,1952540.230.000.000.0040.23
Roberts, Amber, W,215822638.060.000.002049.10588.96
Winston, Ethan, R,216222612.060.000.002049.10562.96
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
King, Jordan, C,110202316.970.000.002316.970.00
Zhang, Connor, R,138532329.980.000.000.002329.98
Rogers, Sean, G,18685124.460.000.000.00124.46
Carter, Jason,11724210.090.000.00113.8696.23
Perry, James,192051249.840.000.000.001249.84
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Sharma, Kathryn,20740140.940.000.000.00140.94
Morgan, Isaiah,18978118.730.000.000.00118.73
Turner, Morgan,11823178.470.000.000.00178.47
Smith, Katherine, J,13197105.190.000.000.00105.19
Phillips, Andrea,1857383.740.000.000.0083.74
Reed, Sean, L,145974803.310.000.000.004803.31
Adams, Gabriel, S,195271219.450.000.000.001219.45
Bradley, Nathaniel,169551760.470.000.000.001760.47
King, Aaron, L,117394758.030.000.002359.982398.05
Martinez, Dominique,287888.990.000.008.990.00
Diaz, Luke,12054402.530.000.00139.97262.56
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Alexander, Paige, W,1860459.250.000.0037.2721.98
Howard, Danielle,28357133.490.000.000.00133.49
Gray, Cody, C,144594775.010.000.000.004775.01
Young, Courtney,176222374.980.000.000.002374.98
Ross, Alexia, S,13231247.900.000.000.00247.90
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Washington, Emma,191231170.480.000.000.001170.48
James, Richard, D,15760109.230.000.003.99105.24
Martin, Christian, V,19709197.250.000.000.00197.25
Butler, Victoria,132844767.530.000.000.004767.53
Murphy, Catherine, L,1650692.050.000.000.0092.05
Garcia, Anna, B,15572104.550.000.000.00104.55
Moore, Taylor, A,199874564.450.003374.990.001189.46
Walker, Thomas,1307193.980.000.000.0093.98
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Lee, Ian,19646197.040.000.000.00197.04
Allen, Madeline,2924068.970.000.000.0068.97
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Ward, Lucas, N,183631700.990.000.000.001700.99
Taylor, Edward, C,17442319.880.000.00230.9088.98
Foster, Alyssa, I,14875839.480.000.000.00839.48
White, Miguel, S,13988195.520.000.000.00195.52
Alvarez, Melody,2507068.490.000.000.0068.49
Stewart, Sara,17347119.720.000.000.00119.72
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Coleman, Miguel, D,2740069.990.000.0069.990.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Sanz, Lori, L,238654891.610.003578.270.001313.34
Rogers, Jared, J,12166162.220.000.000.00162.22
Hill, Blake,11748131.540.000.000.00131.54
Srini, Ruben,18078200.940.000.0071.97128.97
Edwards, Hunter,2422067.930.000.000.0067.93
Carter, Katherine,11861286.300.000.000.00286.30
Griffin, Jordan,13095328.890.000.0069.97258.92
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Simmons, Dylan,16133107.850.000.0038.8868.97
Washington, Adam, G,2543713.980.000.000.0013.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Moore, Logan,2634889.970.000.0089.970.00
Hayes, Luis,12880200.730.000.000.00200.73
Taylor, Madison, A,11802215.290.000.00127.9687.33
Tang, Carl,2123832.270.000.000.0032.27
Griffin, Jason, L,112001267.110.000.00391.08876.03
Long, Natalie,14363192.340.000.000.00192.34
Moreno, Renee, C,12936265.220.000.000.00265.22
Perez, Sydney, C,221174158.243578.270.000.00579.97
Flores, Zachary, H,233765314.250.003578.270.001735.98
Diaz, Luis, D,11203801.770.000.00183.97617.80
Lee, John,19801193.010.000.000.00193.01
Walker, Charles,11677298.210.000.000.00298.21
King, Morgan,196811179.970.000.000.001179.97
Martin, Gina, E,11078793.270.000.00158.36634.91
Gray, Jesse,14626197.040.000.000.00197.04
Green, Gabrielle, M,2181564.470.000.000.0064.47
Wilson, Tyler, L,15879196.930.000.000.00196.93
Rogers, Amanda, A,13920266.970.000.000.00266.97
Patterson, Maria, G,1333094.950.000.000.0094.95
Washington, Kayla, E,14655174.960.000.0069.97104.99
Perry, Ryan,132494795.340.000.000.004795.34
Perry, Ana,112151155.520.000.00332.92822.60
Garcia, Patricia,11651226.430.000.0099.97126.46
Chen, James, D,11641303.200.000.0021.49281.71
Prasad, Molly,243924329.610.003578.270.00751.34
Lopez, Carlos,186171147.770.000.000.001147.77
Murphy, Shelby,244894.990.000.000.004.99
Serrano, Albert, E,133284708.020.000.000.004708.02
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Wright, Kyle,2371626.970.000.000.0026.97
Peterson, Jared,11502829.370.000.00171.95657.42
Green, Isabella,26620699.10699.100.000.000.00
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Isla, Julian, A,13732108.960.000.004.99103.97
Long, Gabrielle,198305765.923374.990.000.002390.93
Bailey, Mariah, L,2724354.980.000.000.0054.98
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Miller, Joseph, A,227134148.190.003578.270.00569.92
Ward, Devin, J,15378170.910.000.0076.9593.96
Brooks, Bryce,12061140.170.000.00112.2527.92
Sharma, Samuel,27725119.980.000.000.00119.98
Phillips, Adam, R,227484188.240.003578.270.00609.97
Howard, Morgan, T,229713578.270.003578.270.000.00
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Williams, Ian, M,175581750.470.000.000.001750.47
Simmons, James,198844588.450.003399.990.001188.46
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Campbell, Jordan,13290111.890.000.000.00111.89
Lopez, Katelyn,11820232.710.000.0060.47172.24
Gomez, Rebekah,13486225.440.000.000.00225.44
Zeng, Jake,18054106.930.000.000.00106.93
Butler, Isabel,16241126.960.000.000.00126.96
Lal, Luke, L,11019698.230.000.00139.93558.30
Rivera, Makayla, A,2878334.990.000.000.0034.99
Hernandez, Haley, L,11769478.950.000.000.00478.95
Harris, Emily, P,1986298.480.000.000.0098.48
Hall, Amber,20106131.950.000.000.00131.95
Scott, Haley,13701154.540.000.000.00154.54
Johnson, Anthony, D,270224.990.000.000.004.99
Coleman, Joan, W,2669964.470.000.000.0064.47
Moore, Andrew, A,13944150.130.000.0036.27113.86
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Turner, Adam, K,16109548.980.000.000.00548.98
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Brown, Benjamin, D,151874725.320.000.000.004725.32
Sanchez, Faith,270494.990.000.000.004.99
Flores, Megan, N,230746021.820.003578.270.002443.55
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Shan, Benjamin,235663578.270.003578.270.000.00
White, Cameron,238304802.110.003578.270.001223.84
Washington, Vanessa,238194802.110.003578.270.001223.84
Thompson, Jose,237314828.110.003578.270.001249.84
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Hughes, Edward,200234530.470.003374.990.001155.48
Chander, Wayne, S,243444329.610.003578.27751.340.00
Flores, Xavier,238664828.110.003578.270.001249.84
Turner, Wyatt,200345769.960.003399.990.002369.97
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Robinson, William,20103103.480.000.000.00103.48
Lal, Robert, L,14084138.680.000.000.00138.68
Cox, Devin, C,134184768.050.000.000.004768.05
Hall, Noah, A,1525175.250.000.000.0075.25
Diaz, Thomas, O,16020595.960.000.000.00595.96
Bradley, Melanie, G,133434720.270.000.000.004720.27
Diaz, Alyssa,139084715.330.000.000.004715.33
Griffin, Jack, L,1768632.280.000.000.0032.28
Bailey, Lauren,15864103.550.000.000.00103.55
Alexander, Nathan, A,187951198.970.000.000.001198.97
Shan, Logan,1867760.960.000.0029.9930.97
Thomas, Logan, A,14091251.200.000.0053.99197.21
Moreno, Marie,2773969.990.000.000.0069.99
Griffin, Haley, L,1892582.180.000.000.0082.18
Hall, Kaylee, E,1975137.270.000.000.0037.27
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Martin, John, A,144364776.010.000.000.004776.01
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Bryant, Samantha,18345115.470.000.000.00115.47
Young, Adam,12984200.200.000.00107.2692.94
Russell, Oscar, A,12140118.170.000.000.00118.17
Price, Lauren, J,14079184.740.000.0037.29147.45
Foster, Kayla,1969371.950.000.000.0071.95
Flores, Madison,14416769.490.000.000.00769.49
Allen, Sean, L,12097159.220.000.000.00159.22
Washington, Alexis,1978146.260.000.007.2838.98
Murphy, Juan, T,246463578.270.003578.270.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Jai, Adam,250952443.350.002443.350.000.00
White, Jennifer, S,27027782.990.00782.990.000.00
Gray, Alexandria, E,253632443.350.002443.350.000.00
Lazecky, Petr,258642443.350.002443.350.000.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Perry, Olivia,203754438.380.000.002071.422366.96
Suri, Carolyn, S,12972175.710.000.000.00175.71
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Yang, Jordan, K,14458133.950.000.000.00133.95

Generated 2025-11-02 12:49:29.685 UTC