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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Bennett, Jessica, S,24330574.980.000.000.00574.98
Perry, Wyatt,222291147.770.000.000.001147.77
Murphy, Hailey, F,190081760.470.000.000.001760.47
Cook, Trinity,147322450.080.00699.100.001750.98
Gonzales, Morgan, C,2610540.220.000.000.0040.22
Gray, Katherine,2216669.970.000.000.0069.97
Guo, Laura, S,13488141.980.000.000.00141.98
Gonzalez, Monica,28421776.330.000.000.00776.33
Sun, Randy, W,11974113.450.000.000.00113.45
Mitchell, Charles, L,16216614.470.000.000.00614.47
Long, Elijah,188642331.950.000.000.002331.95
Rodriguez, John, M,185282381.940.000.000.002381.94
Butler, Faith,184602341.970.000.000.002341.97
Simmons, Jasmine, D,266472889.940.000.002049.10840.84
Wright, Janet, E,24323600.460.000.000.00600.46
Smith, Kari, A,141646484.710.003578.270.002906.44
Young, Luis,1393430.970.000.000.0030.97
Goel, Cristina,228053.990.000.000.003.99
Carson, Kathryn, L,185372294.990.000.000.002294.99
Howard, Xavier, D,183952374.980.000.000.002374.98
Scott, Gabriel,24321548.980.000.000.00548.98
Bennett, Aidan,189981784.960.000.000.001784.96
Luo, Jenny, L,194741589.750.000.00782.99806.76
Griffin, Alexis, S,2537632.600.000.000.0032.60
Carlson, Gina, R,2052125.220.000.000.0025.22
Lopez, Jan,168584.990.000.000.004.99
Yang, Amy,1694164.970.000.000.0064.97
Stewart, Riley, L,184202414.990.000.000.002414.99
Lopez, Jordan, L,184322350.960.000.000.002350.96
Powell, Nicole,23895539.990.000.000.00539.99
King, Marcus,221521205.470.000.000.001205.47
Prasad, Manuel,269841764.960.000.000.001764.96
Sai, Ebony, C,162592756.540.000.002181.56574.98
Price, Jacqueline, R,11194105.750.000.0042.2863.47
Jackson, Morgan, P,1987869.990.000.000.0069.99
Ross, Kevin, L,18993128.970.000.000.00128.97
Nara, Kenneth, K,1417746.830.000.000.0046.83
Robinson, Jessica,20012554.970.000.000.00554.97
Jones, Taylor, A,184222351.960.000.000.002351.96
Luo, Karl, L,219281170.480.000.000.001170.48
Stewart, Haley,191081700.990.000.000.001700.99
Shan, Jodi, A,150957255.660.000.002443.354812.31
Gill, Michele, M,178344158.720.000.001000.443158.28
Jimenez, Ebony,148344397.750.003578.270.00819.48
Huang, Alisha, E,177804112.770.000.001000.443112.33
Xu, Leonard, D,160512746.550.000.002181.56564.99
Subram, Brett, B,169174.990.000.000.004.99
Williams, Jacob,1672513.980.000.000.0013.98
Turner, Amber,1123054.220.000.000.0054.22
Butler, Chloe, E,140261589.700.001000.440.00589.26
Gonzales, Faith, R,184292341.970.000.000.002341.97
Xu, Mandy,27899777.340.000.000.00777.34
Zhu, Todd, G,281316011.313578.270.000.002433.04
Taylor, Noah, E,189791749.960.000.000.001749.96
Henderson, Lauren, E,171314.990.000.000.004.99
Martin, Ryan,153604.990.000.000.004.99
Rubio, Paula, A,1372780.960.000.000.0080.96
Subram, Kristopher,1282444.540.000.000.0044.54
Suarez, Byron, R,1640337.970.000.000.0037.97
Perez, Kaitlin,20004589.960.000.000.00589.96
Richardson, Trinity,112636754.060.003578.272394.97780.82
Thompson, Alexis, R,190021729.970.000.000.001729.97
Vazquez, Ricky, D,1124510580.350.003374.992334.974870.39
Gonzales, Megan,218282322.280.000.000.002322.28
Zheng, Micah,19234119.980.000.000.00119.98
Gray, Erin,1650539.980.000.000.0039.98
Morris, Nathaniel, K,1392885.480.000.000.0085.48
Clark, Grace, L,1209883.970.000.008.9974.98
Dominguez, Linda,200514464.270.00782.990.003681.28
Hernandez, Robin,22619819.480.000.000.00819.48
Jai, Mitchell, D,135462339.970.000.000.002339.97
Rana, Veronica, R,194534267.900.00699.100.003568.80
James, Brian, B,2177449.970.000.000.0049.97
Smith, Samantha, J,1447981.960.000.000.0081.96
Carlson, Brandi, W,162767.280.000.000.007.28
Hall, Robert, M,2089334.980.000.000.0034.98
Lal, Cameron, M,154741676.460.000.00782.99893.47
Murphy, Jade,154271574.460.000.00782.99791.47
James, Dalton,250842393.060.000.000.002393.06
Perry, Jordyn,266462972.770.000.002071.42901.35
Diaz, Andy,208291962.460.000.00782.991179.47
James, Alexa,24334574.980.000.000.00574.98
Madan, Chelsea, O,241982433.040.000.000.002433.04
Taylor, Olivia, R,2634124.990.000.000.0024.99
Torres, Armando,2324169.970.000.000.0069.97
Raje, Ricardo,159236592.780.000.002443.354149.43
Sai, Heidi, S,22737165.220.000.000.00165.22
Andersen, Darrell,192802537.970.000.00782.991754.98
Cox, Bailey, D,17444124.990.000.000.00124.99
Wood, Miranda,1585441.950.000.000.0041.95
Peterson, Faith,2859334.990.000.000.0034.99
Vazquez, Gina,1482990.470.000.000.0090.47
Cai, Erica,228162340.940.000.000.002340.94
Huang, Jenny,1381735.000.000.000.0035.00
Ma, Alvin,1509990.580.000.000.0090.58
Jai, Keith,21054625.470.000.000.00625.47
Jackson, Dalton,281254.990.000.000.004.99
Young, Janet,254664.990.000.000.004.99
Lopez, Fernando, M,1368215.230.000.000.0015.23
Kapoor, Allen,2888139.980.000.000.0039.98
Simmons, Marissa,2203934.980.000.000.0034.98
Alexander, Aaron,2028569.990.000.000.0069.99
Jai, Russell, L,138734765.630.000.002443.352322.28
Adams, Adam,13323141.980.000.000.00141.98
Peterson, Charles,186152334.970.000.000.002334.97
Butler, Haley, L,285967.950.000.000.007.95
Fernandez, Janelle,128665883.250.003578.270.002304.98
Gonzalez, Stanley,163052983.340.000.002443.35539.99
Blanco, Tyrone, F,194581957.470.000.00782.991174.48
Gonzalez, Whitney, Y,22607609.450.000.000.00609.45
Bell, Arianna, M,2767527.770.000.000.0027.77
Reed, Alex, I,2886531.270.000.000.0031.27
Cooper, Natalie, A,2903331.270.000.000.0031.27
Baker, Hailey,1637813.980.000.000.0013.98
Torres, Ross, L,25551143.780.000.000.00143.78
Jai, Johnny, L,1408221.980.000.000.0021.98
Campbell, Jordan, T,282685997.330.003578.270.002419.06
Powell, Jacqueline,112576677.380.003578.272297.28801.83
Simmons, Connor,191191764.960.000.000.001764.96
Perez, Rebekah, C,219101174.480.000.000.001174.48
Dominguez, Anne,132585308.260.000.000.005308.26
Gutierrez, Michele, K,162713014.310.000.002443.35570.96
Kumar, Lindsey,162682778.820.000.002181.56597.26
Henderson, Chloe,2423771.580.000.000.0071.58
Morgan, Devin, E,2609264.970.000.000.0064.97
Butler, Robert, D,1478156.970.000.000.0056.97
Xu, Lisa,2421588.970.000.000.0088.97
Martin, Marcus, R,2237629.990.000.000.0029.99
Yuan, Johnny,2891539.980.000.000.0039.98
Griffin, Benjamin,134542344.260.000.000.002344.26
Mr., Singer, Mircea, Radu,26952751.340.000.000.00751.34
Bell, Sydney,173581728.270.000.000.001728.27
Diaz, Pedro, J,1295451.270.000.000.0051.27
Chen, Luke,188762329.980.000.000.002329.98
Suarez, Walter, E,137304571.020.000.002181.562389.46
Hill, Mason,184422312.260.000.000.002312.26
Parker, Kaitlyn, M,24400608.960.000.000.00608.96
Peterson, Megan,23896548.980.000.000.00548.98
Patel, Geoffrey, M,24311624.970.000.000.00624.97
Ramirez, Devin,20315132.970.000.000.00132.97
Diaz, Caleb, S,1637154.980.000.000.0054.98
Raje, Bethany, B,2270441.930.000.000.0041.93
Subram, Manuel,2568027.770.000.000.0027.77
Rai, Mario, H,143641893.910.000.001000.44893.47
Xu, Jon, D,165724886.700.000.002443.352443.35
Gonzales, Jack, L,2828954.980.000.000.0054.98
Collins, Jada, C,11668128.970.000.000.00128.97
Torres, Jennifer, B,154721560.430.000.00782.99777.44
Russell, Marcus,185322345.220.000.000.002345.22
Nara, Nicolas, M,208612368.060.000.001589.44778.62
She, April,191964657.740.000.001000.443657.30
Anand, Kate, K,1326310872.060.003578.270.007293.79
Gonzales, Aaron,188041810.460.000.000.001810.46
Powell, Isabella, L,209232374.800.000.00782.991591.81
Green, Savannah, M,2925363.470.000.000.0063.47
Watson, Angela, M,223911174.480.000.000.001174.48
Lopez, Haley, M,264062334.460.000.000.002334.46
Ferrier, Gilbert, I,1982569.990.000.000.0069.99
Bell, Brianna, R,175384.990.000.000.004.99
Jai, Andres, B,248412319.260.000.000.002319.26
Townsend, Felicia, L,236212309.970.000.000.002309.97
Diaz, Albert, A,1243642.280.000.000.0042.28
Allen, Jordan, L,1983578.980.000.000.0078.98
Diaz, Amanda, S,169664.990.000.000.004.99
Serrano, Renee,1532450.940.000.000.0050.94
Moyer, Joy,2842234.890.000.000.0034.89
Rodriguez, Tina,2788822.930.000.000.0022.93
King, Kaylee, T,1289121.980.000.000.0021.98
Ross, Ana, T,1289996.460.000.000.0096.46
Rodriguez, José,1252786.960.000.000.0086.96
Phillips, Evan, J,262863308.170.002049.100.001259.07
Wood, Eduardo, E,291384374.610.003578.270.00796.34
Robinson, Brianna,244462447.050.000.000.002447.05
Romero, Pedro,17123562.960.000.000.00562.96
Kumar, Leonard,219321158.460.000.000.001158.46
Lin, Micah,192922518.970.000.00782.991735.98
Guo, Jeffery, C,209261120.490.000.000.001120.49
Moreno, Cheryl, A,25596539.990.000.000.00539.99
She, Alan, A,25597539.990.000.000.00539.99
Alonso, Beth, R,135045923.230.003578.270.002344.96
Walker, Olivia,1988778.980.000.000.0078.98
Price, Destiny,1898394.480.000.000.0094.48
Hall, Timothy, M,1347675.970.000.000.0075.97
Brooks, Abigail, C,118115898.260.003578.270.002319.99
Cox, Destiny, M,134474533.520.000.002181.562351.96
Howard, Amanda,134534576.530.000.002181.562394.97
Jai, Kyle,254002469.050.000.000.002469.05
Raji, Ricardo,2733539.980.000.000.0039.98
Lal, Casey, C,2888839.980.000.000.0039.98
Yang, Cameron,12117159.990.000.000.00159.99
Suri, Heidi,184802329.990.000.000.002329.99
Johnson, Ryan,24232553.970.000.000.00553.97
Goel, Kelvin,24286575.710.000.000.00575.71
Alexander, Connor, G,214351170.480.000.000.001170.48
Patel, Mayra, R,177843891.540.000.002181.561709.98
Garcia, John, M,164324633.900.000.002181.562452.34
Butler, Ashley, A,2611835.230.000.000.0035.23
Patel, Dominique,13781109.960.000.000.00109.96
Clark, Christian, H,1369535.000.000.000.0035.00
Prasad, Whitney, C,2006438.980.000.000.0038.98
Kennedy, Sheena,2549539.980.000.000.0039.98
Barnes, Stephanie, J,19698726.270.000.000.00726.27
Rodriguez, Andrew, N,118125900.550.003578.270.002322.28
Hughes, Vanessa, S,290386.280.000.000.006.28
Ramirez, Caitlin,2791260.470.000.000.0060.47
Gonzales, Lauren,2612264.970.000.000.0064.97
Jai, Leonard, R,26282123.950.000.000.00123.95
Malhotra, Deanna, M,1625863.970.000.000.0063.97
Hernandez, Kathleen,2414738.980.000.000.0038.98
Lal, Luis,155381595.410.000.00782.99812.42
Xie, Karl, V,202811179.970.000.000.001179.97
Xu, Drew,208312012.950.000.00782.991229.96
Sanz, Robyn,22440553.970.000.000.00553.97
Madan, Manuel,138393242.830.002443.350.00799.48
Long, Tristan,2756627.770.000.000.0027.77
Jenkins, Ryan, C,1597139.980.000.000.0039.98
Lewis, Anna,263043263.950.002049.100.001214.85
Jenkins, Jackson,262803298.940.002049.100.001249.84
Kumar, Melvin, M,249972438.060.000.000.002438.06
Perez, Lydia,25589539.990.000.000.00539.99
Anderson, Jacob, V,194521611.460.000.00782.99828.47
Fernandez, Veronica,245602404.970.000.000.002404.97
She, Leonard, S,227972309.970.000.000.002309.97
Martin, Emily, T,134874533.520.000.002181.562351.96
Jai, Ashlee,119255968.230.003578.270.002389.96
Vazquez, Gerald,26941777.340.000.000.00777.34
Ramirez, Timothy, R,203101149.470.000.000.001149.47
Shen, Alicia, D,135759458.180.002181.560.007276.62
Torres, Anna, P,2857129.480.000.000.0029.48
Griffin, Marissa,2529138.880.000.000.0038.88
Jones, Ian,2451571.580.000.000.0071.58
Vazquez, Reginald,24406195.590.000.000.00195.59
Moore, Katherine, L,2304329.990.000.000.0029.99
Alexander, Jeremy, D,1923978.980.000.000.0078.98
Bailey, Christina, A,168534.990.000.000.004.99
Phillips, Edward,1637415.230.000.000.0015.23
Rai, Drew, D,14690128.970.000.000.00128.97
Deng, Cassie, L,2838571.580.000.000.0071.58
Serrano, Desiree,1989827.280.000.000.0027.28
Huang, Stacey,254431750.980.000.000.001750.98
Price, Julian,2035769.990.000.000.0069.99
Zhou, Aimee, M,2072977.960.000.000.0077.96
Taylor, Rachel, M,138864536.540.000.002181.562354.98
Wu, Tamara,174051725.480.000.000.001725.48
Rodriguez, Tyler,12085108.460.000.000.00108.46
Mehta, Terrance,2717825.480.000.000.0025.48
Morgan, Connie,1277845.950.000.000.0045.95
Carlson, Beth, J,140231575.420.001000.440.00574.98
Garcia, Lydia, P,281946114.810.003578.270.002536.54
Chen, Omar, J,11734135.780.000.000.00135.78

Generated 2025-11-06 17:32:56.356 UTC