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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Scott, Adam,15863243.010.000.00171.4371.58
Tang, Carl,2123832.270.000.0032.270.00
Gonzales, Ashley, C,1860051.970.000.0021.9829.99
Alexander, Aidan,17387148.190.000.00148.190.00
Yang, Justin, S,153634719.040.000.002334.972384.07
Morris, Paige, W,220414167.233578.270.000.00588.96
Townsend, Bryan,14077180.730.000.000.00180.73
Roberts, Thomas, J,219394163.243578.270.00584.970.00
Perez, Dalton,110911125.360.000.00471.29654.07
Torres, Pedro, E,16958168.020.000.00168.020.00
Russell, Samantha,11211723.560.000.00369.40354.16
Zukowski, Jake,220584118.263578.270.000.00539.99
Jones, Nicole,14504112.270.000.000.00112.27
Reed, Paige,221126047.323578.270.002469.050.00
Powell, Vanessa,26630699.10699.100.000.000.00
Butler, Victoria,132844767.530.000.004767.530.00
Morris, Abigail, C,287762.290.000.000.002.29
Dominguez, Meghan,14370122.560.000.000.00122.56
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Smith, John,198555709.963399.990.000.002309.97
Davis, Nicholas,1320173.160.000.000.0073.16
Rogers, Carlos,19645134.440.000.00134.440.00
Brown, Isabella, L,266921266.86699.100.000.00567.76
Flores, Emily,13206163.190.000.0069.9793.22
Ross, Natalie, J,12916261.220.000.0068.97192.25
Walker, Charles,11677298.210.000.0021.49276.72
King, Morgan,196811179.970.000.000.001179.97
Collins, Luis, J,227655978.613578.270.000.002400.34
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Turner, Courtney, A,229753578.273578.270.000.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Hughes, Samantha,2721564.470.000.000.0064.47
Reed, Erin, I,14353128.840.000.00128.840.00
Miller, Chloe, V,228936056.510.003578.272478.240.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Long, Jordan,199884555.470.003399.990.001155.48
Russell, Jacqueline,18391100.960.000.00100.960.00
Flores, Megan, N,230746021.820.003578.270.002443.55
Powell, Elijah, E,231135997.330.003578.270.002419.06
Thompson, Ethan,199894495.480.003374.990.001120.49
James, Juan,232674862.090.003578.271283.820.00
Flores, Logan, K,14631848.470.000.000.00848.47
Harris, Emily, P,1986298.480.000.004.9993.49
Ward, Angela, M,2775669.990.000.000.0069.99
Yang, Jordan, K,14458133.950.000.000.00133.95
Wilson, Tyler, L,15879196.930.000.00126.9669.97
Diaz, Elijah,200004495.480.003374.990.001120.49
Ware, Dennis, L,237254828.110.003578.271249.840.00
Garcia, Cameron,186411120.490.000.001120.490.00
Bryant, Connor,238424828.110.003578.270.001249.84
Young, Julia, J,274144.990.000.000.004.99
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Perry, Ana,112151155.520.000.00839.29316.23
Rodriguez, Joshua, A,235114843.110.003578.271264.840.00
Griffin, Julian, M,113284718.040.000.004718.040.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Campbell, Evan, W,243424828.110.003578.270.001249.84
Martinez, Jill,242354829.390.003578.270.001251.12
Davis, James,11922275.500.000.00131.55143.95
Russell, Isabella, A,11507645.780.000.00278.85366.93
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Yang, Thomas, A,14108839.480.000.00839.480.00
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Miller, Alexis, A,12196124.930.000.0054.9669.97
Walker, John, M,2858969.990.000.0069.990.00
Diaz, Luke,12054402.530.000.00139.97262.56
Bennett, Maria, G,229837.280.000.000.007.28
Suarez, Juan, R,167631700.990.000.001700.990.00
Rodriguez, Lucas, P,15942191.870.000.0069.99121.88
Lal, Luke, L,11019698.230.000.00305.18393.05
Perez, Angel, S,213362628.350.000.002628.350.00
Wright, Jackson,11698225.950.000.00204.4621.49
Stewart, Grace, H,247737.280.000.007.280.00
Isla, Julian, A,13732108.960.000.0073.9635.00
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Barnes, Fernando,113001390.550.000.00480.17910.38
Reed, Marcus,14582111.790.000.0061.8149.98
Peterson, Jared,11502829.370.000.00446.84382.53
Murphy, Juan, T,246463578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Washington, Ian, M,246644368.580.003578.270.00790.31
Baker, Sean, T,247782858.490.002181.56676.930.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Green, Sophia, E,249772181.560.002181.560.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Turner, Amanda, L,203183241.900.002071.420.001170.48
Griffin, Jordan,13095328.890.000.0069.97258.92
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Cook, Steven, J,27053782.990.00782.990.000.00
Long, Brandon, M,16110650.470.000.000.00650.47
Harris, Edward,27062782.990.00782.990.000.00
Russell, Fernando,27084782.990.00782.990.000.00
Perry, Olivia,203754438.380.002071.420.002366.96
Gonzales, Melissa, W,204704408.690.002071.420.002337.27
Brooks, Lucas, S,16089342.030.000.00180.98161.05
Moore, Andrew, A,13944150.130.000.00107.8542.28
Parker, Morgan, S,1677236.960.000.0014.9821.98
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Parker, Blake,15008170.530.000.0074.9895.55
Thomas, Emily,2180339.980.000.000.0039.98
Hernandez, Marcus,185952329.990.000.000.002329.99
Brown, Benjamin, D,151874725.320.000.002304.982420.34
Robinson, Sarah, A,2702859.980.000.0059.980.00
Lewis, Isabella,2624267.930.000.0067.930.00
Smith, Lucas, P,1809064.910.000.0064.910.00
Deng, Damien, A,16873578.460.000.000.00578.46
Perez, Jordan, A,292674.990.000.000.004.99
Lopez, Katelyn,11820232.710.000.00127.74104.97
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Thomas, Victoria, A,15536249.530.000.000.00249.53
Washington, Elijah, L,250164.990.000.000.004.99
Walker, Emma, M,2520998.960.000.000.0098.96
Parker, Katherine,13268289.700.000.0068.97220.73
Ross, Alexia, S,13231247.900.000.00104.97142.93
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
Rodriguez, Alexis, L,15244179.190.000.00125.2353.96
Jai, Kevin,1983678.960.000.0038.9839.98
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Johnson, Edward, H,23279124.990.000.000.00124.99
Carter, Sydney,12959203.920.000.0034.98168.94
Reed, Mariah,263731565.910.001000.440.00565.47
Hall, Lauren, A,19648100.840.000.0043.8756.97
Moore, Chloe, L,2626913.980.000.000.0013.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Washington, Robert, J,14906143.950.000.000.00143.95
Henderson, Abigail,2044139.980.000.000.0039.98
Martin, Samuel,15874225.440.000.0069.99155.45
Jones, Charles,22882101.450.000.000.00101.45
Russell, Xavier,12964119.950.000.0029.9989.96
Hernandez, Haley, L,11769478.950.000.00204.45274.50
Murphy, Maria,160113657.260.000.000.003657.26
Hall, Jan, M,11740334.120.000.00270.1563.97
Rodriguez, Richard,12969180.790.000.0073.54107.25
Blue, Paige,2170313.980.000.000.0013.98
Chapman, Nancy, E,11276840.150.000.00205.68634.47
Bennett, Antonio, C,11631707.500.000.00415.52291.98
Patterson, Taylor,12147271.450.000.0013.98257.47
Powell, Spencer,14904468.120.000.000.00468.12
Taylor, Madison, A,11802215.290.000.00155.7359.56
Young, Sierra, J,11619634.840.000.00244.70390.14
Garcia, Henry, B,112871009.240.000.00572.88436.36
Alexander, Edward, E,18524195.950.000.000.00195.95
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Price, Caroline,180511735.980.000.000.001735.98
Hernandez, José, M,11253696.610.000.00372.94323.67
Foster, Abigail,1982346.470.000.000.0046.47
Taylor, Taylor,159054899.020.000.000.004899.02
Williams, Ethan,243094793.120.003578.270.001214.85
Thompson, Abigail,243324816.090.003578.270.001237.82
Martin, Kellie, R,28195574.980.000.000.00574.98
Thomas, Seth,14567161.280.000.00146.3014.98
Gonzales, Brianna, L,211483223.580.002049.100.001174.48
Wright, Robert, C,158894848.030.000.000.004848.03
Jones, Natalie, A,11845197.200.000.0082.26114.94
Morgan, Evan, G,14725318.830.000.00228.8589.98
Chen, Ethan,2054756.970.000.000.0056.97
Ye, Alisha, J,220084141.233578.270.000.00562.96
Brown, Julia,18065155.470.000.000.00155.47
Reed, Kaylee, R,17371151.920.000.0071.9779.95
Patterson, Abigail, H,144784795.010.000.002341.972453.04
Thompson, Kayla, D,12363273.900.000.00109.95163.95
Hughes, Eduardo,15564188.520.000.0086.96101.56
Washington, Caroline, D,231145996.320.003578.270.002418.05
Hughes, Edward,200234530.470.003374.990.001155.48
Roberts, Noah, S,2704268.490.000.000.0068.49
Hughes, Zachary,12203157.910.000.0043.97113.94
Perry, Christian,246714354.600.003578.270.00776.33
Thomas, Zachary, D,28045119.980.000.000.00119.98
Lewis, Zachary, L,14760167.260.000.0047.28119.98
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Patterson, Maria, G,1333094.950.000.0079.9714.98
Lewis, Ethan,27998144.470.000.000.00144.47
Edwards, Elijah, D,281577.280.000.000.007.28
Sanchez, Stephanie,1786756.970.000.000.0056.97
Smith, Katherine, J,13197105.190.000.0049.9755.22
Long, Sarah,173721729.970.000.000.001729.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Price, Nicole, N,15815141.830.000.0056.9784.86
Sanders, Zoe, L,248254.990.000.000.004.99
Hall, Grace, A,201894.990.000.000.004.99
Brown, Christian,227554.990.000.000.004.99
Reed, Michelle,2804669.990.000.000.0069.99
Patterson, Austin, O,270247.280.000.000.007.28
Carter, Jason,11724210.090.000.00113.8696.23
Flores, Julian,158464943.320.000.000.004943.32
Cooper, Brian, L,13760128.840.000.0092.2536.59
Rivera, Allison, M,13751224.910.000.0068.97155.94
Alvarez, Melody,2507068.490.000.000.0068.49
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Stewart, Sara,17347119.720.000.0021.9897.74
Collins, Hailey,11709325.890.000.00156.45169.44
Griffin, Haley, L,1892582.180.000.0045.2236.96
Turner, Jose,11784272.690.000.00144.97127.72
Alexander, Paige, W,1860459.250.000.0037.2721.98
Sanz, Lori, L,238654891.610.003578.270.001313.34
Lee, John,19801193.010.000.0057.09135.92
Scott, Haley,13701154.540.000.0036.59117.95
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Taylor, Marcus, A,18944146.940.000.0056.9789.97
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Kelly, Bailey, R,28284563.770.000.000.00563.77
Martin, Jill, C,11824181.030.000.0069.97111.06
Wang, Austin, A,1463284.970.000.009.9974.98
Bennett, Jordyn, L,222304223.233578.270.000.00644.96
Carter, Katherine,11861286.300.000.00101.26185.04
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Gray, Jesse,14626197.040.000.0032.60164.44
Collins, Xavier, C,16646250.910.000.000.00250.91
Campbell, Timothy,2584513.980.000.000.0013.98
Martin, Christian, V,19709197.250.000.0069.97127.28
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Brooks, Bryce,12061140.170.000.00125.1914.98
James, Christina,17409219.920.000.000.00219.92
Mitchell, Kaylee, R,14566401.490.000.00195.59205.90
Moore, Hunter,14897196.270.000.00146.0450.23
Stewart, Alexandria,174761700.990.000.000.001700.99
Martinez, Matthew, L,16009170.450.000.000.00170.45
Malhotra, Brenda,133912405.470.000.000.002405.47
White, Emily, M,159174679.060.000.000.004679.06
Stewart, Cody, A,212843223.580.000.002049.101174.48
Chen, David,2720839.980.000.000.0039.98
Miller, Joseph, A,227134148.193578.270.000.00569.92
Russell, Katherine,2877169.990.000.000.0069.99
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Hall, Elizabeth, L,13474339.480.000.0083.95255.53
Allen, Angel, G,15571101.850.000.0044.8856.97
Li, Connor,201863191.910.002071.420.001120.49
Davis, Jonathan,2925913.980.000.000.0013.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Hughes, Luke, I,270141274.080.00699.100.00574.98
Yuan, Brendan, S,247444.990.000.000.004.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Li, Eugene, A,15283865.950.000.000.00865.95
Hall, Jason, A,29351119.980.000.000.00119.98
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Ross, Seth, M,184332329.980.000.000.002329.98
Ross, Miranda,145984839.000.000.002445.942393.06
Lee, Samantha, B,2737878.980.000.000.0078.98
Johnson, Ian, E,2173283.470.000.000.0083.47

Generated 2026-07-21 22:31:46.330 UTC