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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Smith, Eduardo,2069139.980.000.0039.980.00
Smith, Chloe,17619163.920.000.000.00163.92
Simmons, Nicole, S,2617729.480.000.000.0029.48
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Harris, Seth, M,161402528.330.000.002528.330.00
Torres, Mackenzie,28153570.470.000.000.00570.47
Brooks, Steven, C,14877889.470.000.000.00889.47
Russell, Xavier,12964119.950.000.000.00119.95
Lewis, Christopher,1875586.960.000.0056.9729.99
Alexander, Thomas,207607.280.000.000.007.28
Gutierrez, Neil, L,214897.280.000.000.007.28
Mehta, Carmen, C,2743694.480.000.000.0094.48
Hughes, Antonio, P,15913712.270.000.000.00712.27
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Roberts, Amanda,171752334.980.000.000.002334.98
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Robinson, Joseph,2814194.480.000.0094.480.00
Tang, Carl,2123832.270.000.000.0032.27
Perez, Katherine, J,2207924.270.000.000.0024.27
James, Morgan, E,2324539.980.000.000.0039.98
Walker, Ian,16771104.550.000.0054.5849.97
Ross, Antonio,18322148.890.000.000.00148.89
Johnson, Jonathan,220597.280.000.000.007.28
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Sanchez, Stephanie,1786756.970.000.000.0056.97
Gray, Jesse,14626197.040.000.000.00197.04
Reed, Gabriella, A,2743778.980.000.000.0078.98
Alexander, Angelica,2271471.950.000.000.0071.95
Brooks, Evan,2340139.980.000.000.0039.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Li, Eugene, A,15283865.950.000.000.00865.95
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Jackson, Victoria,270194.990.000.000.004.99
Thomas, Dylan,198737.280.000.000.007.28
Hall, Jason, A,29351119.980.000.000.00119.98
Diaz, Faith, M,2236356.970.000.000.0056.97
Harris, Joshua, L,2028095.940.000.0030.9764.97
Richardson, Melissa, E,111322371.940.000.000.002371.94
Campbell, Natalie, L,115122319.990.000.000.002319.99
Adams, Gabriel, S,195271219.450.000.000.001219.45
Diaz, Brandon,236764.990.000.004.990.00
Chen, James, D,11641303.200.000.0021.49281.71
Adams, Carlos,1982236.960.000.000.0036.96
Ward, Destiny,16128539.990.000.000.00539.99
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Hall, Charles,234764.990.000.000.004.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Lopez, Carlos,186171147.770.000.000.001147.77
Thompson, Isabella,18756128.410.000.000.00128.41
Ward, Eduardo, I,139162354.980.000.000.002354.98
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Brown, Samantha, G,2514739.980.000.000.0039.98
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Isla, Julian, A,13732108.960.000.004.99103.97
Clark, William,2902169.990.000.000.0069.99
Ramirez, Richard, C,282397.280.000.007.280.00
Williams, Ryan, R,222475978.610.003578.270.002400.34
Hughes, Miranda,266784.990.000.000.004.99
Baker, Allison,2649558.980.000.000.0058.98
Thomas, Samantha,2169093.970.000.000.0093.97
Blue, Makayla,1900029.990.000.000.0029.99
Blanco, Armando, F,139182397.950.000.000.002397.95
Sandberg, Isaac,1335053.970.000.000.0053.97
Bryant, Brittany,2254548.970.000.000.0048.97
Johnson, Madison, L,15530846.460.000.000.00846.46
Flores, Emily,13206163.190.000.0069.9793.22
Nelson, Luis,234884.990.000.000.004.99
Perez, Charles,266937.280.000.007.280.00
Green, Marcus, C,15974208.410.000.0091.95116.46
Wilson, Grace,17539205.920.000.000.00205.92
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Lopez, Katelyn,11820232.710.000.0060.47172.24
Hall, Fernando,2210090.950.000.000.0090.95
Hughes, Austin, P,183681754.980.000.000.001754.98
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Martinez, Kristina, S,2134529.930.000.000.0029.93
Griffin, James,28189567.760.000.000.00567.76
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Scott, Sean, F,2475539.980.000.000.0039.98
Roberts, Wyatt,15900699.970.000.00699.970.00
Simmons, Dakota, T,14110819.460.000.000.00819.46
Foster, Isabel, M,2174571.950.000.000.0071.95
Srini, Ruben,18078200.940.000.000.00200.94
Sharma, Jackson,16876151.840.000.000.00151.84
Rodriguez, Taylor,1607166.960.000.000.0066.96
Edwards, Hunter,2422067.930.000.000.0067.93
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Butler, Isabel,16241126.960.000.000.00126.96
Stewart, Olivia, B,1874923.780.000.000.0023.78
Mitchell, Bailey, B,267067.280.000.007.280.00
Rivera, Makayla, A,2878334.990.000.000.0034.99
Flores, Brittany,169062359.980.000.000.002359.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Rivera, Ariana,261734.990.000.000.004.99
Lee, Don,188392384.970.000.000.002384.97
Garcia, Xavier, M,2030071.970.000.000.0071.97
Coleman, Joan, W,2669964.470.000.000.0064.47
Edwards, Logan,250024.990.000.000.004.99
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Hughes, Brittany,14387898.460.000.000.00898.46
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Allen, Mason,176252431.950.000.000.002431.95
Roberts, Amber, W,215822638.060.000.002049.10588.96
Robinson, Zachary, L,137092332.280.000.000.002332.28
Kapoor, Preston,2143156.970.000.000.0056.97
Sanchez, Faith,270494.990.000.000.004.99
Richardson, Brian,2860878.980.000.000.0078.98
Williams, Sydney, J,15334848.470.000.000.00848.47
Lee, Ethan, J,223597.280.000.000.007.28
Ramos, Derrick,18449100.940.000.0030.9769.97
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Lee, William,13185149.840.000.0069.9779.87
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Martin, Katherine, J,2027339.980.000.000.0039.98
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Baker, Ian, V,262002756.540.000.002181.56574.98
Ortega, Sheila, M,2763239.980.000.000.0039.98
Johnson, Christopher,119794813.760.000.002352.212461.55
Bradley, Rachel,158504813.040.000.000.004813.04
Kelly, Julia,2379867.930.000.0067.930.00
Alexander, Nathan, A,187951198.970.000.000.001198.97
Parker, Jordan,216212616.860.000.002049.10567.76
Smith, Hannah, J,2526554.980.000.0054.980.00
Long, Xavier,112512318.960.000.000.002318.96
Richardson, Olivia,204683169.590.000.002049.101120.49
Kumar, Cameron, S,185711120.490.000.001120.490.00
Powell, Miranda, J,153044843.000.000.000.004843.00
Fernandez, Ruth,205463246.550.000.002049.101197.45
Robinson, Lauren,2719668.490.000.0068.490.00
Davis, Nicholas,1320173.160.000.000.0073.16
Williams, Zachary, B,27099782.990.000.00782.990.00
Peterson, Melissa, S,249954.990.000.004.990.00
Nelson, Adam, B,27402128.970.000.000.00128.97
Bell, Eduardo,27101782.990.000.00782.990.00
Martin, Joshua, A,276077.280.000.007.280.00
Hall, Jan, M,11740334.120.000.00235.1598.97
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Cox, Sara, P,2775869.990.000.0069.990.00
Moreno, Marie,2773969.990.000.000.0069.99
Perry, Marcus, L,206563245.900.000.002071.421174.48
Barnes, Kayla,2425639.980.000.0039.980.00
Barnes, Emily, G,15996564.990.000.000.00564.99
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Hall, Kaylee, E,1975137.270.000.000.0037.27
Diaz, Angela, K,27259782.990.000.00782.990.00
Gray, Jared, A,264494.990.000.000.004.99
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Diaz, Hunter, S,27242782.990.000.00782.990.00
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Rubio, Kellie,27653128.970.000.000.00128.97
Jai, Connor, D,27253782.990.000.00782.990.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Murphy, Chase, J,2472958.980.000.000.0058.98
White, Christopher, R,260492181.560.000.002181.560.00
Rogers, Paige, H,17125539.990.000.000.00539.99
Zhang, Robert,188551155.480.000.000.001155.48
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Hill, Katherine, L,2670139.980.000.000.0039.98
Moore, Hunter,14897196.270.000.0071.58124.69
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Thompson, Lucas, O,212774.990.000.000.004.99
Miller, Kayla, A,236734.990.000.000.004.99
Mitchell, Maria, D,27404782.990.000.00782.990.00
Jackson, Andrew,2047985.480.000.000.0085.48
Davis, Thomas,167641760.470.000.000.001760.47
Cox, Arianna, D,1892789.250.000.000.0089.25
Rogers, Olivia,12020804.470.000.000.00804.47
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
Campbell, Lucas,2932953.990.000.000.0053.99
Lewis, Rachel, J,14900839.480.000.000.00839.48
Butler, Dalton, A,133454759.510.000.000.004759.51
Foster, Aaron,155664912.470.000.000.004912.47
Li, Thomas,181162376.960.000.000.002376.96
Coleman, Spencer,15993597.260.000.000.00597.26
Alexander, Caroline,176541759.970.000.000.001759.97
Adams, Katherine, M,235184.990.000.000.004.99
Bradley, Jocelyn,230227.280.000.000.007.28
Turner, Eduardo,158764789.020.000.000.004789.02
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Flores, Devin, A,15559172.040.000.0086.5685.48
Lewis, Morgan,17410168.740.000.000.00168.74
Johnson, Ian, E,2173283.470.000.000.0083.47
Hu, Gilbert, L,2876769.990.000.000.0069.99
Russell, Richard,2763322.260.000.000.0022.26
Carter, Isaac,137191129.480.000.000.001129.48
Cannata, Gabrielle, C,217254.990.000.000.004.99
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Rogers, Faith,2468259.980.000.000.0059.98
Thomas, Richard,27557782.990.000.00782.990.00
Martin, Lucas, L,221144183.233578.270.000.00604.96
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Robinson, Emily,12183228.420.000.0054.96173.46
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Reed, Paige,221126047.320.003578.272469.050.00
Nelson, Sierra,161322459.620.000.002459.620.00
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Wilson, Eduardo,15323804.470.000.000.00804.47
Smith, John,198555709.960.003399.990.002309.97
Diaz, Hailey, W,116932294.990.000.002294.990.00
Green, Kaylee, C,2618567.970.000.000.0067.97
Moore, Chloe, L,2626913.980.000.000.0013.98
Miller, Joseph, A,227134148.190.003578.270.00569.92
Harris, Samantha, A,244874.990.000.000.004.99
Phillips, Aaron, R,2494739.980.000.000.0039.98
Griffin, Miguel,2146476.970.000.000.0076.97
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Washington, Hailey, S,2588559.980.000.000.0059.98
Madan, Carmen, V,155674720.270.000.000.004720.27
Henderson, Abigail,2044139.980.000.000.0039.98
Howard, Morgan, T,229713578.270.003578.270.000.00
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Long, Julia, R,228895971.330.003578.270.002393.06
Wood, Brittany,2877753.990.000.000.0053.99
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Sanders, Chloe, C,231375314.250.003578.271735.980.00
Alexander, Jordan,2141259.980.000.0059.980.00
Cooper, Angela,195261179.470.000.000.001179.47
Ross, Jose,2744178.980.000.0078.980.00
Barnes, Ian, M,16106133.540.000.000.00133.54
Harris, Jacob, G,2367939.980.000.0039.980.00
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Russell, Rachel, C,2158124.270.000.0024.270.00
Stewart, Cindy,14496804.480.000.000.00804.48
Coleman, Samuel, N,17450123.980.000.000.00123.98
Sanz, Lori, L,238654891.610.003578.270.001313.34
Russell, Caleb,23552103.480.000.000.00103.48
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Smith, Austin,13707149.050.000.000.00149.05
Hughes, Edward,200234530.470.003374.990.001155.48
Kennedy, Bridget,2202639.980.000.000.0039.98
Bennett, Seth,244933578.270.003578.270.000.00
Jones, Dalton, T,189512334.970.000.000.002334.97
Allen, Aaron, A,200753399.990.003399.990.000.00
Chen, Luis, G,2125294.450.000.0094.450.00
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Barnes, Blake, A,178651789.970.000.000.001789.97
Roberts, Carlos,2319639.980.000.000.0039.98
Collins, Allison,28581119.980.000.000.00119.98
Prasad, Donald,15413318.920.000.00123.98194.94
Price, Caroline,180511735.980.000.000.001735.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Stewart, Gabriella,2803469.990.000.000.0069.99
Howard, Alyssa, A,11513863.950.000.000.00863.95
Li, Rafael, M,217527.280.000.000.007.28
Sanders, Angel,16219553.970.000.000.00553.97
Thomas, Dalton,230097.280.000.000.007.28
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Rodriguez, Natalie,2077330.970.000.000.0030.97
Diaz, Richard, A,2668264.470.000.000.0064.47
Hughes, Riley,2928449.990.000.000.0049.99
Torres, Christina, M,20746119.950.000.000.00119.95
Lobao, Alexandre,1892691.950.000.0091.950.00
Garcia, Christian, J,164913106.330.000.00751.342354.99
Peterson, Steven, L,234497.280.000.007.280.00
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Sanders, Sean,14341175.150.000.000.00175.15
Wu, Randy, J,116472365.940.000.002365.940.00
Morris, Mason, J,22349124.990.000.000.00124.99
Ward, Natalie, J,132412325.960.000.000.002325.96
Flores, Julia, E,172631700.990.000.000.001700.99
Martin, Noah, A,1765775.970.000.0075.970.00
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Taylor, Tyler, A,12032614.960.000.00614.960.00
Ward, Emma, W,2179659.980.000.000.0059.98
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Wilson, Madison, H,1982821.980.000.000.0021.98
Flores, Hannah,1952540.230.000.000.0040.23
Alexander, Edward, E,18524195.950.000.000.00195.95
Johnson, Xavier, R,2325539.980.000.0039.980.00
Richardson, Lauren, C,14867839.480.000.000.00839.48
Taylor, Taylor,159054899.020.000.000.004899.02
Wang, Zachary,2214489.970.000.000.0089.97
Watson, Michelle, H,262352181.560.000.002181.560.00
Bell, Julia,216522646.060.000.002646.060.00
Russell, Jessica,265721000.440.000.001000.440.00
Powell, David, W,266151000.440.000.001000.440.00
Wilson, Victoria, R,27536782.990.000.00782.990.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Allen, Jack, M,291372419.060.000.002419.060.00
Martinez, Dominique,287888.990.000.008.990.00
Gray, Isabella,168203217.790.000.000.003217.79
Russell, Melanie, B,15478182.830.000.00167.8514.98
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
James, Maria,1624391.970.000.0069.9921.98
Nelson, Jordan, H,201304.990.000.004.990.00
Ward, Cole,214907.280.000.000.007.28
Ross, Kaitlyn,16121614.470.000.000.00614.47
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Sánchez, Angela, C,176551750.980.000.000.001750.98
White, Greg, C,174032322.280.000.000.002322.28
Turner, Samuel,2742069.990.000.0069.990.00
James, Bryce,13466133.450.000.000.00133.45
Johnson, Jacob, I,28069553.970.000.000.00553.97
Phillips, Isaiah,28631144.470.000.00144.470.00
Harris, Natalie,2368259.980.000.0059.980.00
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Rivera, Sara,187852350.960.000.000.002350.96
Diaz, Trevor, B,2051954.960.000.000.0054.96
Phillips, Haley, B,2807939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Ma, Tiffany,2157739.980.000.000.0039.98
Watson, Victoria,16125588.960.000.000.00588.96
Lal, Jack, R,185251735.980.000.000.001735.98
Jones, Natalie, A,11845197.200.000.0082.26114.94
Gonzalez, Molly,1637021.980.000.000.0021.98
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Roberts, Noah, S,2704268.490.000.000.0068.49
Zhao, Clarence, R,1982671.970.000.0071.970.00
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Martinez, Joseph, E,2921459.980.000.0059.980.00
Gray, Sara,292472447.050.000.002447.050.00
Thomas, Zachary, D,28045119.980.000.000.00119.98
Morris, Jessica,289678.990.000.008.990.00
Collins, Sierra,185491169.460.000.001169.460.00
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Lewis, Ethan,27998144.470.000.000.00144.47
Richardson, Arianna, C,1205534.980.000.0034.980.00
Perry, Samuel,18811100.960.000.00100.960.00
Wilson, Emily,174002331.950.000.000.002331.95
Gray, Cindy, A,13198114.950.000.0099.9714.98
Flores, Morgan,19817118.940.000.0039.9878.96
Evans, Jordan,2920939.980.000.0039.980.00
Brown, Christian,227554.990.000.000.004.99
Perry, James,192051249.840.000.000.001249.84
Li, Jordan,17026261.390.000.00261.390.00
Peterson, Isabella,2808039.980.000.0039.980.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Butler, Jonathan,261804.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Luo, Jodi,2921368.490.000.000.0068.49
Anderson, Ryan, W,132712319.990.000.000.002319.99
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Smith, Zachary, W,2378358.980.000.0058.980.00
Foster, Jessica,2606951.460.000.0051.460.00
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Butler, Jackson, J,183241735.980.000.000.001735.98
Jones, Alexander, I,2002180.960.000.000.0080.96
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Deng, Wayne,2145336.960.000.0036.960.00
Richardson, Erin, R,1633188.850.000.0038.8849.97
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Li, Brandon,2933973.960.000.000.0073.96
Carter, Jose, H,12532235.720.000.000.00235.72
Collins, Eduardo,139872329.990.000.000.002329.99
Reed, Morgan, E,2877923.970.000.000.0023.97
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Williams, Joshua,260514.990.000.000.004.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Baker, Mason, A,132702394.950.000.000.002394.95
Gill, Robyn, J,127651750.980.000.001750.980.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Harris, Noah,292562393.060.000.002393.060.00
Torres, Dalton,235037.280.000.007.280.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Davis, Jonathan,2925913.980.000.000.0013.98
Powell, Sydney, M,14886539.990.000.00539.990.00
Sanchez, Grace,120802354.990.000.000.002354.99
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Morgan, Isabella, L,28602144.470.000.000.00144.47
_SUM1806517.5065197.22487005.99323518.76930795.53

Generated 2025-11-04 10:04:23.013 UTC