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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Smith, Andrew,1472387.570.000.0014.9872.59
Smith, Chloe,17619163.920.000.000.00163.92
Davis, Daniel,11711999.220.000.0086.48912.74
Allen, Angel, G,15571101.850.000.0034.8966.96
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Morgan, Jada, A,11520702.990.000.00137.45565.54
Simmons, Jennifer,112621010.560.000.00207.93802.63
Morgan, Andrea, M,16870149.040.000.00116.4432.60
James, Morgan, E,2324539.980.000.000.0039.98
Evans, Connor, J,15402131.550.000.000.00131.55
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Baker, Gabriella,174041709.980.000.000.001709.98
Henderson, Ashley,111851381.370.000.00232.801148.57
Jai, Samuel, L,1635887.950.000.0039.9947.96
Stewart, Marcus, R,2063221.980.000.000.0021.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Brown, Jonathan,11875265.420.000.000.00265.42
Garcia, Isabella,18382204.940.000.000.00204.94
Jenkins, Samantha,113311290.330.000.00410.31880.02
Alexander, Angelica,2271471.950.000.000.0071.95
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Russell, Samuel, V,11652310.930.000.000.00310.93
Diaz, Faith, M,2236356.970.000.000.0056.97
Scott, Adam,15863243.010.000.000.00243.01
Reed, Sean, L,145974803.310.000.000.004803.31
Adams, Gabriel, S,195271219.450.000.000.001219.45
Green, Blake, P,11719287.200.000.000.00287.20
Adams, Carlos,1982236.960.000.000.0036.96
Brooks, Bryce,12061140.170.000.00112.2527.92
Flores, Brandon, L,2562189.970.000.000.0089.97
Russell, Nicole, M,182372318.960.000.000.002318.96
Hayes, Austin,202083219.580.002049.100.001170.48
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Stewart, Alexandria,174761700.990.000.000.001700.99
Powell, Angela, R,12970471.110.000.000.00471.11
Taylor, Edward, C,17442319.880.000.00230.9088.98
Thomas, Edward, E,19147133.710.000.000.00133.71
Perez, Dalton,110911125.360.000.00213.86911.50
Russell, Arianna,22728149.930.000.00149.930.00
Umeda, Masaki,16717233.810.000.000.00233.81
Bell, Garrett, J,14265161.230.000.000.00161.23
Martinez, Grace, M,17385208.690.000.0069.97138.72
Martinez, Jill,242354829.390.003578.270.001251.12
Campbell, Chloe,11212760.930.000.00231.72529.21
Edwards, Logan,250024.990.000.000.004.99
Hayes, Jason,261764.990.000.000.004.99
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Malhotra, Brenda,133912405.470.000.000.002405.47
Murphy, Catherine, L,1650692.050.000.000.0092.05
Sanchez, Allison,1666741.720.000.000.0041.72
Thompson, Xavier, R,15761192.410.000.000.00192.41
Moore, Taylor, A,199874564.450.003374.990.001189.46
Ramos, Derrick,18449100.940.000.0030.9769.97
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Turner, Kaylee, M,16213154.540.000.000.00154.54
Bradley, Rachel,158504813.040.000.000.004813.04
Collins, Hailey,11709325.890.000.0021.49304.40
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Kumar, Elijah,15197156.920.000.000.00156.92
Parker, Jordan,216212616.860.000.002049.10567.76
Perry, Benjamin,291652407.040.000.002407.040.00
Martin, Samuel,15874225.440.000.0069.99155.45
Hill, Eric, G,2525667.930.000.0067.930.00
Bryant, Rachel,220197.280.000.007.280.00
Xu, Louis,2010466.530.000.0066.530.00
Zhang, Heather,166543056.320.000.00751.342304.98
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Foster, Antonio,12795108.540.000.0066.2642.28
Davis, Dylan,15556588.960.000.00588.960.00
Hayes, Logan, J,19026113.240.000.0037.2775.97
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Hughes, Caroline, C,2830278.980.000.0078.980.00
Cox, Arianna, D,1892789.250.000.000.0089.25
Green, Samuel, D,14096174.730.000.000.00174.73
Foster, Aaron,155664912.470.000.000.004912.47
Williams, Destiny, S,15881564.990.000.00564.990.00
Bailey, Lauren,15864103.550.000.000.00103.55
Sanders, Xavier,1672173.750.000.000.0073.75
Turner, Eduardo,158764789.020.000.000.004789.02
Parker, Katherine,13268289.700.000.0068.97220.73
Thomas, Victoria, A,15536249.530.000.000.00249.53
Lewis, Morgan,17410168.740.000.000.00168.74
Russell, Richard,2763322.260.000.000.0022.26
Cannata, Gabrielle, C,217254.990.000.000.004.99
Robinson, Madison, W,183772394.970.000.000.002394.97
Brown, Isabella, L,266921266.860.00699.100.00567.76
Perez, Barry, M,2728269.990.000.000.0069.99
Hughes, Luke, I,270141274.080.00699.100.00574.98
Yuan, Brendan, S,247444.990.000.000.004.99
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Griffin, Xavier,228775962.340.003578.270.002384.07
Brown, Julia,18065155.470.000.000.00155.47
Coleman, Ian,2127639.980.000.000.0039.98
Henderson, Austin,2764354.980.000.000.0054.98
Rodriguez, Richard,12969180.790.000.000.00180.79
Ross, Seth, M,184332329.980.000.000.002329.98
Thomas, Matthew, K,13239185.700.000.000.00185.70
Chen, Jonathan, G,13096200.690.000.000.00200.69
Griffin, Maria,1840763.250.000.000.0063.25
Murphy, Maria,160113657.260.000.000.003657.26
Jenkins, Megan, R,12074261.380.000.000.00261.38
Cooper, Amanda, P,146064716.020.000.000.004716.02
Flores, Kevin,15878225.920.000.0069.97155.95
Davis, Justin,2807412.940.000.000.0012.94
Nelson, James, L,245257.280.000.007.280.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Roberts, Seth, H,11510258.150.000.0039.47218.68
Hernandez, Sierra,27393123.980.000.00123.980.00
James, Julia,2497567.930.000.000.0067.93
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Stewart, Allison, R,18826166.430.000.0069.9996.44
Adams, Hailey, M,121544798.530.000.002379.472419.06
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Gray, Mariah,222787.280.000.007.280.00
Reed, Erin, I,14353128.840.000.0074.9853.86
Bell, Alex, M,167543118.600.000.00756.332362.27
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Wright, Carol, C,12928247.410.000.0033.98213.43
Garcia, Alexandra, J,14107819.460.000.00819.460.00
James, Juan,232674862.090.003578.271283.820.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Simmons, David, E,120172339.970.000.002339.970.00
Gray, Brianna,249603008.820.002443.35565.470.00
Gomez, Krista,12760273.180.000.0036.27236.91
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Rivera, Amanda,11131115.920.000.000.00115.92
Watson, Erin, B,227724.990.000.004.990.00
Wilson, Andrew, R,182362414.990.000.000.002414.99
Sanders, Paige,252872983.340.002443.350.00539.99
Sandberg, Chase,2190475.970.000.000.0075.97
Smith, Nathan,217647.280.000.007.280.00
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Jai, Adam,250952443.350.002443.350.000.00
Perry, Jackson, J,213064.990.000.000.004.99
Van, Bobby,27757132.970.000.00132.970.00
Alexander, Aidan,17387148.190.000.0056.9791.22
Miller, Eduardo,14561158.840.000.0049.97108.87
Turner, Sean,227324133.240.003578.270.00554.97
Long, Gavin,13762186.030.000.000.00186.03
Yang, Justin, S,153634719.040.000.000.004719.04
Huang, Kristen,251002443.350.002443.350.000.00
Williams, Ethan,243094793.120.003578.270.001214.85
Taylor, Brianna,17027230.900.000.0051.96178.94
Moreno, Meredith, D,2228589.970.000.000.0089.97
Garcia, Henry, B,112871009.240.000.00219.26789.98
Sun, Arturo, C,11498557.540.000.0012.94544.60
Miller, Victoria,15816188.020.000.0081.46106.56
Hall, Morgan,2172641.950.000.000.0041.95
Cooper, Alexandra,19541131.240.000.000.00131.24
James, Jeremiah, S,11661287.700.000.000.00287.70
Henderson, Justin, P,235917.280.000.000.007.28
Griffin, Jason, L,112001267.110.000.00391.08876.03
Carter, Luis, E,258832443.350.002443.350.000.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Clark, Destiny, L,28600119.980.000.000.00119.98
Sanchez, Martin, E,216317.280.000.000.007.28
Gomez, Renee, L,253712181.560.002181.560.000.00
Ross, Natalie, J,12916261.220.000.000.00261.22
Patterson, Maria, G,1333094.950.000.000.0094.95
Moreno, Renee, C,12936265.220.000.000.00265.22
Peterson, Jared,11502829.370.000.00171.95657.42
Bell, Chase,180911750.980.000.000.001750.98
Edwards, Eric,2462768.490.000.000.0068.49
Torres, Pedro, E,16958168.020.000.00153.0414.98
Evans, Gabriel,2348789.970.000.000.0089.97
Nelson, Kevin,1476584.970.000.000.0084.97
Long, Natalie,14363192.340.000.000.00192.34
Morris, Abigail, C,287762.290.000.000.002.29
Price, Jocelyn, D,258752443.350.002443.350.000.00
Stewart, Lucas, J,2934198.970.000.000.0098.97
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Dominguez, Meghan,14370122.560.000.000.00122.56
Flores, Jordyn,252882721.550.002181.560.00539.99
Thomas, Seth,14567161.280.000.0096.0765.21
Flores, Zachary, H,233765314.250.003578.270.001735.98
Diaz, Luis, D,11203801.770.000.00183.97617.80
Clark, Anthony,27071782.990.00782.990.000.00
Roberts, Rebecca,2800094.480.000.000.0094.48
Watson, Shelby, J,14911867.970.000.000.00867.97
Reed, Bryan,18884133.930.000.000.00133.93
Smith, Noah,13175166.920.000.000.00166.92
Moreno, Lance, A,2922939.980.000.000.0039.98
Sanchez, Alex, K,131014736.030.000.000.004736.03
Lee, John,19801193.010.000.000.00193.01
Cook, Steven, J,27053782.990.00782.990.000.00
Martin, James, M,1987077.250.000.000.0077.25
Powell, Spencer,14904468.120.000.000.00468.12
Johnson, James,234984.990.000.000.004.99
Young, Savannah,259712749.320.002181.560.00567.76
Hayes, Brittany,13941286.820.000.000.00286.82
Carter, Marcus, l,2147131.970.000.000.0031.97
Rogers, Carlos,19645134.440.000.000.00134.44
Moore, Seth,138512331.950.000.000.002331.95
Lal, Luke, L,11019698.230.000.00139.93558.30
Walker, Charles,11677298.210.000.000.00298.21
Young, Sierra, J,11619634.840.000.0034.99599.85
Harris, Edward,27062782.990.000.00782.990.00
Bailey, Jessica, L,12945218.440.000.000.00218.44
Green, Gabrielle, M,2181564.470.000.000.0064.47
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Carter, Jason,11724210.090.000.00113.8696.23
Barnes, Fernando,113001390.550.000.00248.381142.17
Harris, Emily, P,1986298.480.000.000.0098.48
King, Morgan,196811179.970.000.000.001179.97
Perry, Olivia,203754438.380.000.002071.422366.96
Flores, Miguel,1975077.250.000.000.0077.25
Yang, Jordan, K,14458133.950.000.000.00133.95
Taylor, Ryan,170251709.980.000.000.001709.98
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Young, Julia, J,274144.990.000.000.004.99
Peterson, Brian,12892419.470.000.00156.27263.20
Roberts, Mason, D,111761106.680.000.00494.64612.04
Jones, Alexandra, B,2020245.950.000.000.0045.95
Griffin, Julian, M,113284718.040.000.002319.992398.05
Walker, Hunter,271007.280.000.000.007.28
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Wright, Robert, C,158894848.030.000.000.004848.03
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Anderson, Lucas,2926639.980.000.000.0039.98
Gonzales, Miranda,11660324.720.000.000.00324.72
Baker, Sara, M,11827512.470.000.00148.47364.00
Davis, James,11922275.500.000.0034.98240.52
Ward, Angela, M,2775669.990.000.000.0069.99
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Garcia, Kayla, L,2130881.460.000.000.0081.46
Perry, Dalton, A,16149192.040.000.000.00192.04
Wilson, Tyler, L,15879196.930.000.000.00196.93
Brown, Morgan,2919778.980.000.000.0078.98
Edwards, Elijah, D,281577.280.000.000.007.28
Lal, Jonathan,2009671.460.000.000.0071.46
Patterson, Nicole,1972937.270.000.000.0037.27
Lee, William,13185149.840.000.0069.9779.87
Ross, Miranda,145984839.000.000.000.004839.00
Long, Morgan, H,213522625.390.000.002071.42553.97
Stewart, Jessica,16097103.550.000.0046.5856.97
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Hernandez, José, M,11253696.610.000.0098.97597.64
Watson, Emma,17481126.940.000.000.00126.94
Wilson, Fernando,16643126.960.000.000.00126.96
Russell, Samantha,11211723.560.000.00118.46605.10
Gomez, Rebekah,13486225.440.000.000.00225.44
Moore, Matthew, W,13267109.950.000.000.00109.95
Mitchell, Savannah,261153052.800.000.002443.35609.45

Generated 2025-11-04 08:37:00.287 UTC