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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Gomez, Rebekah,13486225.440.000.000.00225.44
Madan, Carmen, V,155674720.270.000.000.004720.27
Jones, Alexandra, B,2020245.950.000.000.0045.95
Hayes, Brittany,13941286.820.000.000.00286.82
Morgan, Evan, G,14725318.830.000.0069.97248.86
Patterson, Eric, A,2738478.980.000.000.0078.98
White, James,253317.280.000.000.007.28
Wilson, Tyler, L,15879196.930.000.000.00196.93
Gonzalez, Morgan,130651700.990.000.000.001700.99
Gray, Isabella,168203217.790.000.000.003217.79
Chavez, Kara, P,13285214.350.000.0012.94201.41
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Flores, Eduardo, S,2896962.980.000.000.0062.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Washington, Hannah, A,291307.280.000.007.280.00
James, Jeremiah, S,11661287.700.000.000.00287.70
Moore, Jonathan,2047896.460.000.000.0096.46
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Moore, Logan,2634889.970.000.0089.970.00
Roberts, Rebecca,2800094.480.000.000.0094.48
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Thomas, Zachary, D,28045119.980.000.000.00119.98
Price, Mariah, C,2074549.480.000.000.0049.48
Bradley, Rachel,158504813.040.000.000.004813.04
Chen, Luis, G,2125294.450.000.0094.450.00
Flores, Emily,13206163.190.000.0069.9793.22
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Sanders, Angel,16219553.970.000.000.00553.97
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Ramos, Derrick,18449100.940.000.0030.9769.97
Coleman, Dylan,27403132.970.000.000.00132.97
Alexander, Elijah,11738331.680.000.00141.73189.95
Ward, Kaylee, A,244154.990.000.004.990.00
Diaz, Luis, D,11203801.770.000.00183.97617.80
Flores, Kevin,15878225.920.000.0069.97155.95
Zhang, Heather,166543056.320.000.00751.342304.98
Murphy, Maria,160113657.260.000.000.003657.26
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Young, Jenna, W,163652490.180.000.000.002490.18
Hall, Fernando,2210090.950.000.000.0090.95
Allen, Allison, A,1975737.270.000.000.0037.27
Price, Devin, M,18758158.510.000.0073.5584.96
Alexander, Caroline,176541759.970.000.000.001759.97
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Perez, Amber, D,13318214.260.000.00116.9197.35
Taylor, Tyler, A,12032614.960.000.00614.960.00
Peterson, Julia, P,16497132.710.000.000.00132.71
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Reed, Paige,221126047.323578.270.002469.050.00
White, Edward, J,15847205.460.000.000.00205.46
Baker, Isaiah,12106169.540.000.000.00169.54
Lobao, Alexandre,1892691.950.000.0091.950.00
Griffin, Jason, L,112001267.110.000.00391.08876.03
Washington, Victoria,235577.280.000.000.007.28
Morgan, Juan, C,1882191.970.000.000.0091.97
Parker, Katherine,13268289.700.000.0068.97220.73
Henderson, Ashley,111851381.370.000.00232.801148.57
Rodriguez, Richard,12969180.790.000.000.00180.79
Thomas, Jeremiah,183721760.470.000.000.001760.47
Rodriguez, Destiny, J,227397.280.000.007.280.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Young, Kaylee, S,13756298.490.000.0058.47240.02
Ward, Destiny,16128539.990.000.000.00539.99
Phillips, Kyle,12158202.200.000.000.00202.20
Powell, Jonathan,238584712.740.003578.271134.470.00
Barnes, Emily, G,15996564.990.000.000.00564.99
Ward, Eduardo, I,139162354.980.000.000.002354.98
Martinez, Jonathan,1330366.250.000.000.0066.25
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Collins, Lucas, T,219214142.753578.270.000.00564.48
Watson, Devin, A,18875114.950.000.000.00114.95
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Taylor, Christian,2076456.760.000.000.0056.76
Campbell, Angel, D,195461174.480.000.000.001174.48
Price, Riley, R,139094764.020.000.000.004764.02
Perry, Samuel,18811100.960.000.00100.960.00
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Walker, Destiny, M,169961754.980.000.000.001754.98
Rubio, Javier, E,1972664.240.000.0064.240.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Long, Jordan,199884555.470.003399.990.001155.48
Cooper, Paige,14119148.940.000.000.00148.94
Anderson, David, A,2209761.960.000.0061.960.00
Ward, Devin, J,15378170.910.000.0076.9593.96
Morris, Chase, F,26789699.100.00699.100.000.00
Powell, Ian,2608564.470.000.000.0064.47
Flores, Zachary, H,233765314.250.003578.270.001735.98
Flores, Devin, A,15559172.040.000.0086.5685.48
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Sanchez, Alex, K,131014736.030.000.000.004736.03
Moreno, Lance, A,2922939.980.000.000.0039.98
Powell, Elijah, E,231135997.330.003578.270.002419.06
Cox, Julia, A,206703228.570.000.002049.101179.47
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Sanders, Allison, B,18852268.250.000.000.00268.25
Foster, Eric,229765971.330.003578.270.002393.06
Tang, Carl,2123832.270.000.000.0032.27
Russell, Jacqueline,18391100.960.000.0078.9821.98
Smith, Austin,13707149.050.000.000.00149.05
Harris, Megan,232814828.110.003578.271249.840.00
Alexander, Aidan,17387148.190.000.0056.9791.22
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Gutierrez, Neil, L,214897.280.000.000.007.28
Shan, Benjamin,235663578.270.003578.270.000.00
Lee, Emma,16948176.430.000.000.00176.43
Edwards, Eric,2462768.490.000.000.0068.49
Sanders, Sean,14341175.150.000.000.00175.15
Bryant, Connor,238424828.110.003578.270.001249.84
Hayes, Luis,12880200.730.000.000.00200.73
Jones, Nicole,14504112.270.000.000.00112.27
Jai, Luis, A,18320185.920.000.000.00185.92
Washington, Vanessa,238194802.110.003578.270.001223.84
Hall, Morgan,2172641.950.000.000.0041.95
Brown, Anna,1624795.820.000.000.0095.82
Flores, Hannah,1952540.230.000.000.0040.23
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Sanchez, Martin, E,216317.280.000.000.007.28
Garcia, Cameron,186411120.490.000.000.001120.49
Taylor, Edward, C,17442319.880.000.00230.9088.98
Martinez, Jill,242354829.390.003578.270.001251.12
Morris, Abigail, C,287762.290.000.000.002.29
Thomas, Dylan,198737.280.000.000.007.28
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Perry, Jonathan, T,27026699.100.00699.100.000.00
Dominguez, Meghan,14370122.560.000.000.00122.56
Ross, Natalie, J,12916261.220.000.000.00261.22
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Hayes, Logan, J,19026113.240.000.0037.2775.97
Harris, Isabella,17119214.900.000.0077.96136.94
Washington, Kayla, E,14655174.960.000.0069.97104.99
Jackson, Brianna,1537797.910.000.0074.9822.93
Wilson, Eduardo,15323804.470.000.000.00804.47
Sandberg, Isaac,1335053.970.000.000.0053.97
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Phillips, Devin,18759112.060.000.000.00112.06
Smith, Katherine, J,13197105.190.000.000.00105.19
Ward, Angela, M,2775669.990.000.000.0069.99
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Ortega, Javier, P,127852294.990.000.000.002294.99
Sanders, Xavier,1672173.750.000.000.0073.75
Patterson, Nicole,1972937.270.000.000.0037.27
Taylor, Madison, A,11802215.290.000.00127.9687.33
Clark, Lauren,170341750.980.000.000.001750.98
Hughes, Samantha,2721564.470.000.000.0064.47
Perry, Ryan,132494795.340.000.000.004795.34
Flores, Morgan,19817118.940.000.0039.9878.96
Scott, Gabrielle,270614.990.000.000.004.99
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Ross, Anna, D,15494275.440.000.0029.99245.45
Brown, Samantha, G,2514739.980.000.000.0039.98
Flores, Logan, K,14631848.470.000.000.00848.47
Parker, James,11808610.190.000.00186.77423.42
Davis, Daniel,11711999.220.000.0086.48912.74
Washington, Thomas, C,2745137.430.000.000.0037.43
Harris, Emily, P,1986298.480.000.000.0098.48
Young, Julia, J,274144.990.000.000.004.99
Evans, Jordan,2920939.980.000.0039.980.00
James, Christina,17409219.920.000.000.00219.92
Yang, Jordan, K,14458133.950.000.000.00133.95
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Harris, Anthony,2144721.980.000.000.0021.98
Martinez, Matthew, L,16009170.450.000.000.00170.45
Stewart, Jessica,16097103.550.000.0046.5856.97
Rogers, Jared, J,12166162.220.000.000.00162.22
Bailey, Lauren,15864103.550.000.000.00103.55
Coleman, Vanessa,215892589.090.000.002049.10539.99
Umeda, Masaki,16717233.810.000.000.00233.81
Fernandez, Darren,2899278.980.000.000.0078.98
Flores, Julian,158464943.320.000.000.004943.32
Miller, Kayla, A,236734.990.000.000.004.99
Sharma, Samuel,27725119.980.000.000.00119.98
Moore, Matthew, W,13267109.950.000.000.00109.95
Parker, Amanda,1808151.970.000.000.0051.97
Thompson, Madison, L,187882351.960.000.000.002351.96
Rogers, Faith,2468259.980.000.000.0059.98
Perry, Dalton, A,16149192.040.000.000.00192.04
Richardson, Lauren, C,14867839.480.000.000.00839.48
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Suarez, Juan, R,167631700.990.000.000.001700.99
Allen, Amanda,2235339.980.000.000.0039.98
Taylor, Taylor,159054899.020.000.000.004899.02
Griffin, Marcus,2075634.560.000.000.0034.56
Williams, Ian, M,175581750.470.000.000.001750.47
Turner, Adam, K,16109548.980.000.000.00548.98
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Ross, Kaitlyn,16121614.470.000.000.00614.47
Moore, Andrew, A,13944150.130.000.0036.27113.86
Anderson, Emma, A,185801170.480.000.000.001170.48
Patterson, Eduardo,11142866.810.000.0072.26794.55
Blue, Melanie, L,178611749.960.000.000.001749.96
Russell, Xavier,12964119.950.000.000.00119.95
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Miller, Alexis, A,12196124.930.000.000.00124.93
She, Shawn, J,16902141.980.000.000.00141.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Flores, Emma, P,15543180.940.000.000.00180.94
Thomas, Logan, A,14091251.200.000.0053.99197.21
Yuan, Leonard, F,167911729.970.000.000.001729.97
Serrano, Albert, E,133284708.020.000.000.004708.02
Hernandez, Marcus,185952329.990.000.000.002329.99
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Jenkins, Austin, D,15748296.910.000.000.00296.91
Hughes, Justin, M,181222439.990.000.000.002439.99
Stewart, Grace, H,247737.280.000.000.007.28
James, Maria,1624391.970.000.0069.9921.98
Powell, Katherine, C,14574177.600.000.000.00177.60
Parker, Blake,15008170.530.000.0074.9895.55
Bailey, Mariah, L,2724354.980.000.000.0054.98
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Hayes, Dalton, C,188822322.280.000.000.002322.28
Sharma, Thomas, A,18637121.940.000.000.00121.94
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Hill, Haley, J,161033142.320.000.00792.342349.98
Reed, Melanie, A,28160574.980.000.000.00574.98
Thomas, Emily,2180339.980.000.000.0039.98
Thomas, Samantha,2169093.970.000.000.0093.97
Peterson, Isabella,2808039.980.000.0039.980.00
Jones, Dalton, T,189512334.970.000.000.002334.97
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Morris, Alyssa,28072548.980.000.000.00548.98
She, Kenneth,16096212.010.000.0080.96131.05
Johnson, Jacob, I,28069553.970.000.000.00553.97
Washington, Miranda,152014793.020.000.000.004793.02
Hall, Kyle, J,1749169.970.000.000.0069.97
Harris, Samuel, M,2477159.980.000.0059.980.00
Nelson, Jose,19217185.020.000.0091.9593.07
Sanchez, Allison,1666741.720.000.000.0041.72
Harris, Destiny, M,137102341.460.000.000.002341.46
Sharma, Kathryn,20740140.940.000.000.00140.94
Bradley, Jocelyn,230227.280.000.000.007.28
Johnson, Edward, H,23279124.990.000.000.00124.99
Chow, Candice,1923260.960.000.000.0060.96
Wilson, Emily,174002331.950.000.000.002331.95
Peterson, Morgan, J,168341750.980.000.000.001750.98
Murphy, Richard, M,222994145.540.003578.270.00567.27
Simmons, Jose,2464739.980.000.000.0039.98
Turner, Morgan,11823178.470.000.000.00178.47
Davis, Austin, E,133664749.040.000.000.004749.04
Phillips, James, G,16846180.950.000.00123.9856.97
Long, Gabrielle,198305765.923374.990.000.002390.93
Brooks, Evan,2340139.980.000.000.0039.98
Lal, Kyle,17360122.180.000.000.00122.18
Price, Nicole, N,15815141.830.000.000.00141.83

Generated 2025-11-03 05:14:58.576 UTC