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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Bradley, Alexandria,176911779.470.000.000.001779.47
Simmons, Jennifer,112621010.560.000.00488.15522.41
Hall, Fernando,2210090.950.000.000.0090.95
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Lewis, Brandon, A,2903769.990.000.0069.990.00
Patterson, Hailey, I,112231155.900.000.00637.86518.04
Gonzales, Miranda,11660324.720.000.00200.74123.98
Griffin, Jack, L,1768632.280.000.0032.280.00
Lee, William,13185149.840.000.00117.2432.60
Carter, Savannah, M,120902350.960.000.002350.960.00
Johnson, Christopher,119794813.760.000.004813.760.00
Alexander, Nathan, A,187951198.970.000.001198.970.00
James, Jeremiah, S,11661287.700.000.00104.97182.73
Sanders, Hailey,19647282.040.000.0086.45195.59
Fernandez, Cesar,200355694.980.003374.990.002319.99
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Jenkins, Samantha,113311290.330.000.00822.35467.98
Evans, Gabriel,2348789.970.000.000.0089.97
Sun, Arturo, C,11498557.540.000.00321.57235.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Taylor, Zachary, M,27082782.990.00782.990.000.00
Fernandez, Ruth,205463246.550.002049.100.001197.45
Wilson, Christian,27085782.990.00782.990.000.00
Bell, Eduardo,27101782.990.00782.990.000.00
Cooper, Timothy, J,206513198.570.002049.100.001149.47
Perry, Marcus, L,206563245.900.002071.420.001174.48
Diaz, Angela, K,27259782.990.00782.990.000.00
Cox, Julia, A,206703228.570.002049.100.001179.47
Thompson, Joshua, F,259992181.560.002181.560.000.00
White, Christopher, R,260492181.560.002181.560.000.00
Howard, Alexandra,207363194.580.002049.100.001145.48
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Coleman, Ashley,27297782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Sanchez, Adrian, L,13179190.170.000.0077.92112.25
Jenkins, Megan, R,12074261.380.000.000.00261.38
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Russell, Oscar, A,12140118.170.000.0032.2885.89
Kelly, Trinity,2609515.230.000.000.0015.23
Cooper, Andrea,2932378.980.000.000.0078.98
Washington, Kayla, E,14655174.960.000.00174.960.00
Gonzalez, James, M,188421155.480.000.001155.480.00
Thompson, Ryan, M,113301111.360.000.00623.78487.58
Roberts, Seth, H,11510258.150.000.0071.74186.41
Moore, Jonathan,2047896.460.000.0096.460.00
Griffin, Jason, L,112001267.110.000.00724.21542.90
Morgan, Abigail, C,244314334.600.003578.27756.330.00
Brown, Nicholas, S,11506675.640.000.00401.27274.37
Jai, Edwin,169211754.980.000.001754.980.00
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Jai, Hunter, M,28272111.950.000.000.00111.95
Foster, Antonio,12795108.540.000.0066.2642.28
White, Nicole,16731155.910.000.0084.9670.95
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Perry, Natalie,1712669.990.000.000.0069.99
Cox, Devin, C,134184768.050.000.002329.992438.06
Davis, Ethan,136604750.010.000.002351.962398.05
Garcia, Anna, B,15572104.550.000.0049.9754.58
Price, Marissa,15826160.740.000.00120.4840.26
Thomas, David,168363193.790.000.000.003193.79
Cooper, Ariana,17348205.420.000.0084.96120.46
White, Edward, J,15847205.460.000.00119.9885.48
Peterson, Christina,2897694.480.000.0094.480.00
Harris, Matthew,14330806.760.000.00806.760.00
Young, Kaylee, S,13756298.490.000.00298.490.00
Barnes, Emily, G,15996564.990.000.00564.990.00
Bell, Christina,2609939.980.000.0039.980.00
Watson, Marcus,2271585.480.000.0085.480.00
Phillips, Jackson, D,233785317.230.003578.271738.960.00
Campbell, Lucas,2932953.990.000.000.0053.99
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Flores, Kevin,15878225.920.000.0069.97155.95
Bailey, Jessica, L,12945218.440.000.0049.97168.47
Hernandez, Jonathan, J,1901465.950.000.0030.9734.98
Rubio, Kellie,27653128.970.000.00128.970.00
Turner, Morgan,11823178.470.000.0063.96114.51
Morris, Mason, J,22349124.990.000.000.00124.99
Flores, Julia, E,172631700.990.000.000.001700.99
Morgan, Marcus, W,289682.290.000.000.002.29
Chen, James, D,11641303.200.000.00265.9137.29
Suri, Carolyn, S,12972175.710.000.0098.4577.26
Wilson, Madison, H,1982821.980.000.000.0021.98
Baker, Sara, M,11827512.470.000.00218.44294.03
Murphy, Chase, J,2472958.980.000.0058.980.00
Kelly, Angel, E,15418232.230.000.00232.230.00
Ward, Stephanie, A,27429782.990.000.00782.990.00
Winston, Ethan, R,216222612.060.000.002049.10562.96
Carter, Elijah,216182611.070.000.002611.070.00
Parker, Jordan,216212616.860.000.002616.860.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Morgan, Brianna, D,111362380.470.000.002380.470.00
Walker, Isabella,243864143.740.003578.27565.470.00
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Davis, Richard, R,15549574.980.000.00574.980.00
James, Adrian, C,253404.990.000.000.004.99
Wilson, Eduardo,15323804.470.000.000.00804.47
Kelly, Haley,15511128.560.000.00128.560.00
Davis, Thomas,167641760.470.000.001760.470.00
Wright, Carol, C,12928247.410.000.00128.46118.95
Butler, Dalton, A,133454759.510.000.004759.510.00
Stewart, Alex, M,2008463.150.000.0038.8824.27
Yuan, Leonard, F,167911729.970.000.001729.970.00
Jai, Samuel, L,1635887.950.000.0083.963.99
Torres, Xavier,16840176.950.000.00176.950.00
Green, Mackenzie, C,280737.280.000.007.280.00
Campbell, Chloe,11212760.930.000.00307.78453.15
Rogers, Jade, I,14332102.250.000.0044.9957.26
Wilson, Grace,17539205.920.000.000.00205.92
Russell, Samuel, V,11652310.930.000.0034.98275.95
Harris, Samantha, A,244874.990.000.000.004.99
Baker, Isaiah,12106169.540.000.0037.29132.25
Hill, Timothy,14871848.470.000.000.00848.47
Thompson, Madison, L,187882351.960.000.000.002351.96
Sanchez, Jared, J,2585064.470.000.0064.470.00
Phillips, Andrea,1857383.740.000.0083.740.00
Hu, Gilbert, L,2876769.990.000.0069.990.00
Carter, Isaac,137191129.480.000.001129.480.00
Lal, Kyle,17360122.180.000.0035.2386.95
King, Aaron, L,117394758.030.000.004758.030.00
Nelson, Sierra,161322459.620.000.002459.620.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Jones, Madison,246614181.760.003578.27603.490.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
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
Townsend, Bryan,14077180.730.000.000.00180.73
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
Jones, Nicole,14504112.270.000.000.00112.27
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
Davis, Nicholas,1320173.160.000.000.0073.16
Rogers, Carlos,19645134.440.000.00134.440.00
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
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Hughes, Samantha,2721564.470.000.000.0064.47
Reed, Erin, I,14353128.840.000.00128.840.00
Russell, Jacqueline,18391100.960.000.00100.960.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
Garcia, Cameron,186411120.490.000.001120.490.00
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
Griffin, Julian, M,113284718.040.000.004718.040.00
Davis, James,11922275.500.000.00131.55143.95
Russell, Isabella, A,11507645.780.000.00278.85366.93
Yang, Thomas, A,14108839.480.000.00839.480.00
Roberts, Thomas, J,219394163.243578.270.00584.970.00
Peterson, Jared,11502829.370.000.00446.84382.53
Morris, Paige, W,220414167.233578.270.000.00588.96
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Miller, Alexis, A,12196124.930.000.0054.9669.97
Zukowski, Jake,220584118.263578.270.000.00539.99
Walker, John, M,2858969.990.000.0069.990.00
Reed, Paige,221126047.323578.270.002469.050.00
Powell, Vanessa,26630699.10699.100.000.000.00
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Diaz, Luke,12054402.530.000.00139.97262.56
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Bennett, Maria, G,229837.280.000.000.007.28
Smith, John,198555709.963399.990.000.002309.97
Griffin, Jordan,13095328.890.000.0069.97258.92
Brown, Isabella, L,266921266.86699.100.000.00567.76
Collins, Luis, J,227655978.613578.270.000.002400.34
Rodriguez, Lucas, P,15942191.870.000.0069.99121.88
Suarez, Juan, R,167631700.990.000.001700.990.00
Turner, Courtney, A,229753578.273578.270.000.000.00
Long, Brandon, M,16110650.470.000.000.00650.47
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Miller, Chloe, V,228936056.510.003578.272478.240.00
Lal, Luke, L,11019698.230.000.00305.18393.05
Brooks, Lucas, S,16089342.030.000.00180.98161.05
Griffin, Xavier,228775962.340.003578.270.002384.07
Long, Jordan,199884555.470.003399.990.001155.48
Moore, Andrew, A,13944150.130.000.00107.8542.28
Flores, Megan, N,230746021.820.003578.270.002443.55
Powell, Elijah, E,231135997.330.003578.270.002419.06
Parker, Morgan, S,1677236.960.000.0014.9821.98
Thompson, Ethan,199894495.480.003374.990.001120.49
Brooks, Jennifer, L,17411155.470.000.000.00155.47
James, Juan,232674862.090.003578.271283.820.00
Deng, Damien, A,16873578.460.000.000.00578.46
Perez, Jordan, A,292674.990.000.000.004.99
Diaz, Elijah,200004495.480.003374.990.001120.49
Ware, Dennis, L,237254828.110.003578.271249.840.00
Barnes, Fernando,113001390.550.000.00480.17910.38
Parker, Blake,15008170.530.000.0074.9895.55
Bryant, Connor,238424828.110.003578.270.001249.84
Thomas, Emily,2180339.980.000.000.0039.98
Thomas, Victoria, A,15536249.530.000.000.00249.53
Rodriguez, Joshua, A,235114843.110.003578.271264.840.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Perez, Angel, S,213362628.350.000.002628.350.00
Washington, Elijah, L,250164.990.000.000.004.99
Walker, Emma, M,2520998.960.000.000.0098.96
Hernandez, Marcus,185952329.990.000.000.002329.99
Campbell, Evan, W,243424828.110.003578.270.001249.84
Martinez, Jill,242354829.390.003578.270.001251.12
Brown, Benjamin, D,151874725.320.000.002304.982420.34
Parker, Katherine,13268289.700.000.0068.97220.73
Wright, Jackson,11698225.950.000.00204.4621.49
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Rodriguez, Alexis, L,15244179.190.000.00125.2353.96
Stewart, Grace, H,247737.280.000.007.280.00
Jai, Kevin,1983678.960.000.0038.9839.98
Isla, Julian, A,13732108.960.000.0073.9635.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Johnson, Edward, H,23279124.990.000.000.00124.99
Reed, Marcus,14582111.790.000.0061.8149.98
Carter, Sydney,12959203.920.000.0034.98168.94
Morris, Alyssa,28072548.980.000.000.00548.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
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
Lopez, Katelyn,11820232.710.000.00127.74104.97
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Ross, Alexia, S,13231247.900.000.00104.97142.93
Thompson, Isabella,18756128.410.000.000.00128.41
Brown, Samantha, G,2514739.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Washington, Thomas, C,2745137.430.000.000.0037.43
Green, Blake, P,11719287.200.000.00224.9262.28
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

Generated 2026-07-21 19:50:39.725 UTC