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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Sanchez, Roy,210351957.470.000.00782.991174.48
Bailey, Abigail, E,275312071.420.000.002071.420.00
Cai, Kristen,165334702.390.000.002181.562520.83
Yang, Jake, L,165474900.680.000.002443.352457.33
Guo, Gilbert, H,171916895.610.000.002181.564714.05
Wright, Nathan, D,159843124.960.000.00782.992341.97
Suarez, Mathew,122792395.960.000.000.002395.96
Subram, Abby,132567494.880.000.002691.884803.00
Edwards, James, K,275082071.420.000.002071.420.00
Butler, Madison,282427.280.000.000.007.28
Price, Blake,2701833.980.000.000.0033.98
Butler, Alyssa, L,2320129.990.000.000.0029.99
Hall, Savannah, K,2193814.980.000.000.0014.98
Zheng, Todd, J,15326172.980.000.000.00172.98
Chen, Dawn, C,165805429.760.000.002443.352986.41
Richardson, Shelby,163597.280.000.000.007.28
Cooper, Evan, J,159523174.950.000.00782.992391.96
Deng, Marshall, L,159543117.960.000.00782.992334.97
Robinson, Jeremy, S,144703382.400.000.001000.442381.96
Li, Ernest, L,236343.990.000.000.003.99
Kawai, Masato,2566394.970.000.000.0094.97
Butler, Jacqueline, L,275404504.460.000.002071.422433.04
Pal, Johnny,199023080.270.000.00782.992297.28
Stewart, Bailey, J,144853312.700.000.001000.442312.26
Martin, Kayla, E,275232049.100.000.002049.100.00
Richardson, Eduardo, E,159903099.960.000.00782.992316.97
Ross, Jackson, A,275462049.100.000.002049.100.00
Nara, Bridget, L,128464460.380.000.002071.422388.96
Xu, Karla, M,115834381.390.000.002071.422309.97
Richardson, Marcus, L,198993127.950.000.00782.992344.96
Martin, Kristi, C,210291934.750.000.00782.991151.76
Green, Katherine, J,159493157.970.000.00782.992374.98
Lin, Martha,206781155.480.000.000.001155.48
Smith, Emmanuel,139764511.540.000.002181.562329.98
Edwards, Lucas, L,175721735.980.000.000.001735.98
Carlson, Walter,199433112.970.000.00782.992329.98
Flores, James, V,132603661.290.000.00751.342909.95
Foster, Gabriel, G,275214462.160.000.002049.102413.06
Cox, Amanda,275562049.100.000.002049.100.00
Watson, Brianna,2881224.990.000.000.0024.99
Chande, Brad, S,224302638.940.000.002638.940.00
Murphy, Riley, J,2371238.980.000.000.0038.98
Sanz, Casey,255344.990.000.000.004.99
Lu, Steve,153513114.940.000.00782.992331.95
Collins, Stephanie,112616650.600.003578.272329.98742.35
Cox, Jasmine,250861308.310.000.001308.310.00
Jenkins, Luke,260845768.050.003374.990.002393.06
Hughes, Abigail, G,247642398.050.000.000.002398.05
Zhou, Suzanne,121307987.910.000.005589.862398.05
Hall, Isaiah,263014484.480.002071.420.002413.06
Romero, Kendra,268261237.820.000.001237.820.00
Ramos, Robin,113454404.090.000.004404.090.00
Diaz, Taylor, E,206611174.480.000.000.001174.48
Phillips, Seth,112925910.220.003578.272331.950.00
Powell, Jacqueline,112576677.380.003578.272297.28801.83
Fernandez, Virginia,29355567.760.000.00567.760.00
Cook, Adrian, S,2739688.980.000.000.0088.98
Perry, Jeremy, C,2655527.280.000.000.0027.28
Coleman, Chloe, A,2474337.930.000.000.0037.93
She, Brad,123079594.920.000.002443.357151.57
Morgan, Caitlin, C,191671120.490.000.001120.490.00
Richardson, Kaylee, L,1756039.980.000.000.0039.98
Lopez, Hailey, M,1547076.960.000.000.0076.96
Raji, Alejandro, E,169444253.810.000.004253.810.00
Cai, Marshall, K,257792479.940.000.002479.940.00
Cooper, Caitlin,207351120.490.000.000.001120.49
Arun, Kristina, V,207163911.290.000.001560.332350.96
Rai, Jaime, M,176671760.470.000.000.001760.47
Lin, Stacey, B,248832487.330.000.002487.330.00
Bryant, Seth, M,2462638.880.000.000.0038.88
Sanchez, Natalie,18958565.210.000.00565.210.00
Romero, Joanna,2152142.930.000.000.0042.93
Kapoor, Geoffrey,1774832.280.000.000.0032.28
Ramos, Deanna, D,113325754.970.003399.992354.980.00
Wright, Jose,12022136.250.000.000.00136.25
She, Randy, H,1141513.980.000.000.0013.98
Wood, Elizabeth, D,263122881.740.002071.42810.320.00
Shan, Julie, M,13789819.480.000.00819.480.00
Alvarez, Alberto,23358561.920.000.000.00561.92
Vazquez, Albert,175761750.980.000.000.001750.98
Diaz, David,112675943.230.003578.272364.960.00
Gray, Isaac, G,123732359.460.000.000.002359.46
Jackson, Emily,250921257.820.000.001257.820.00
Hill, Jan,2358169.970.000.000.0069.97
Allen, Courtney, M,22260563.770.000.00563.770.00
Phillips, Natalie,22415615.470.000.00615.470.00
Jones, Miguel, R,169007.280.000.000.007.28
Hughes, Wyatt, H,2687223.780.000.000.0023.78
Morgan, Haley, A,137412951.050.000.002951.050.00
Edwards, Samuel,1202483.970.000.008.9974.98
Harris, Christopher, A,244172467.020.000.002467.020.00
Mitchell, Noah,25722777.340.000.00777.340.00
Simmons, Dalton,263134487.160.002049.100.002438.06
Walker, Megan, G,111542319.990.000.002319.990.00
Mitchell, Kevin,23352539.990.000.000.00539.99
Shan, Austin,21465574.980.000.00574.980.00
Price, Edward,21438561.480.000.00561.480.00
Martin, Dana, K,162312525.940.000.002525.940.00
Torres, Melanie, L,191711174.480.000.001174.480.00
Gray, Ian, A,1119341.280.000.0035.006.28
Mitchell, Sydney,2902624.990.000.000.0024.99
Sanders, Victoria,2907863.970.000.000.0063.97
Murphy, Angela,110632372.950.000.002372.950.00
Wilson, Sarah, C,2709868.970.000.000.0068.97
Miller, Alexander,263072848.760.002071.42777.340.00
James, Gabrielle,12725127.280.000.000.00127.28
Simmons, Nathan, M,1104347.980.000.000.0047.98
Nara, Deborah, E,1350254.980.000.000.0054.98
Rogers, Morgan, B,1167496.270.000.000.0096.27
Suarez, Erik, W,151943173.940.00782.990.002390.95
Romero, Daisy, M,141988308.590.003578.272433.042297.28
Gutierrez, Ruben, A,208352002.440.000.00782.991219.45
Lee, Brianna, R,192021170.480.000.001170.480.00
Barnes, Hailey,155551371.950.000.001371.950.00
Xie, Terrence,161996917.590.002181.560.004736.03
Campbell, Logan,11695128.970.000.000.00128.97
Rodriguez, Brenda, S,263112822.760.002071.42751.340.00
Allen, Evan,1981169.990.000.000.0069.99
Richardson, Anna, R,155334.990.000.000.004.99
Brooks, Melissa,191981155.480.000.001155.480.00
Carter, James,1425785.480.000.000.0085.48
Torres, Maria,167921735.980.000.001735.980.00
Ruiz, Gary,2109729.480.000.000.0029.48
Rodriguez, Patricia, M,22273574.980.000.00574.980.00
Hill, Morgan, M,1132072.210.000.000.0072.21
Fernandez, Evelyn, R,244272400.340.000.002400.340.00
Hall, Jackson,18949801.770.000.000.00801.77
Long, Grace, J,154923117.450.000.00782.992334.46
Lewis, David,152033211.450.00782.990.002428.46
Simmons, Amanda, M,192131155.480.000.001155.480.00
Romero, Shannon, J,263812520.830.000.002520.830.00
Gonzalez, Adriana, L,123009664.430.000.004891.404773.03
Jordan, Joe, L,151993080.270.00782.990.002297.28
Griffin, Hunter, D,112865954.220.003578.272375.950.00
Price, Brianna, J,176211732.260.000.000.001732.26
Stewart, Danielle, P,207071750.980.000.000.001750.98
Munoz, Rebekah,283961155.480.000.000.001155.48
Alonso, Clinton,237592475.950.000.002475.950.00
Liang, Erica, C,223232443.350.000.002443.350.00
Cooper, Jessica,16015574.980.000.00574.980.00
Nath, Kelvin, M,2679125.480.000.000.0025.48
Jimenez, Theresa, W,192401155.480.000.001155.480.00
Rubio, Gerald, A,257692514.930.000.002514.930.00
Wang, Luis,111756710.550.003578.272341.97790.31
Flores, Alyssa,18612119.980.000.000.00119.98
Rubio, Latasha,1124610575.330.003374.992329.984870.36
Shan, April, L,115661006.830.000.00335.78671.05
Andersen, Alvin, C,137442959.000.000.002959.000.00
Madan, Janelle, E,137463250.110.000.003250.110.00
Jimenez, Gerald, E,2396368.970.000.000.0068.97
Price, Marcus, R,244202393.060.000.002393.060.00
Bailey, Sydney,18948806.760.000.000.00806.76
Suri, Deanna,28507777.340.000.000.00777.34
Morris, Melanie,25081777.340.000.000.00777.34
Morgan, Riley, R,265304468.160.000.002049.102419.06
Collins, Jack, J,258874673.313399.990.000.001273.32
Diaz, Sarah,175971723.960.000.000.001723.96
Chander, Tasha,150734143.260.003578.270.00564.99
Suarez, Lori,124844441.040.000.002049.102391.94
Sanchez, Kaitlin,122612394.970.000.000.002394.97
Cox, Jessica, B,2881627.280.000.000.0027.28
Watson, Zoe, W,2651589.460.000.000.0089.46
Edwards, Timothy, D,26104114.960.000.000.00114.96
Ramirez, Carlos, M,2132214.980.000.000.0014.98
Rai, Terry, A,260895798.040.003399.990.002398.05
Zhou, Susan,156787223.340.000.002443.354779.99
Griffin, Gavin,2619629.980.000.000.0029.98
Guo, Todd, K,1273214.980.000.000.0014.98
King, Joan, E,153893152.960.000.00782.992369.97
Sanchez, Riley, J,264914469.440.000.002049.102420.34
White, Richard,23018607.960.000.000.00607.96
Yang, Rafael, A,23900539.990.000.000.00539.99
Vazquez, Roberto, A,168266953.580.000.002181.564772.02
Bryant, Katherine, A,11517101.760.000.000.00101.76
Bryant, Miguel,2934838.980.000.000.0038.98
Hernandez, Micheal,2516838.880.000.000.0038.88
Wright, Luis,1876113.980.000.000.0013.98
Flores, Marcus,1691313.980.000.000.0013.98
Rogers, Katelyn,1347975.970.000.000.0075.97
Jackson, Hunter,1216872.880.000.007.9564.93
King, Katherine, A,207501184.460.000.000.001184.46
Peterson, Devin, M,2921027.280.000.000.0027.28
Smith, Rachel,2296769.970.000.000.0069.97
Green, Nathan, C,174877.280.000.000.007.28
Rodriguez, Tyler,12085108.460.000.000.00108.46
Robinson, Tyler, A,263254478.460.002071.420.002407.04
Martin, Gary, L,207931205.470.000.000.001205.47
Stone, Karl, L,164514632.860.000.002181.562451.30
Peterson, Adrian, J,2123677.920.000.000.0077.92
Ma, Kelvin, E,1382537.290.000.000.0037.29
Flores, Kyle,18650561.480.000.000.00561.48
Lopez, Timothy, O,2927363.470.000.000.0063.47
Powell, Tristan, G,282804.990.000.000.004.99
Torres, Andrea, L,22441597.950.000.00597.950.00
Martinez, Chelsea, S,149274190.230.003578.27611.960.00
Lopez, Mackenzie,18957589.260.000.00589.260.00
Williams, David,191991134.470.000.001134.470.00
Lee, Anna,192111120.490.000.001120.490.00
Robinson, Marcus, J,193261903.480.000.001903.480.00
Serrano, Kellie, L,207222378.800.000.001602.47776.33
Lewis, Tyler, C,155521426.460.000.001426.460.00
Hernandez, Edward,111442399.970.000.002399.970.00
Bryant, Arianna,191691170.480.000.001170.480.00
Jackson, John,154317.280.000.000.007.28
Russell, Amanda,1409421.980.000.000.0021.98
Munoz, Lance, L,2109531.730.000.000.0031.73
Lewis, Destiny,203762475.950.000.000.002475.95
Butler, Caroline,116905904.230.003578.270.002325.96
Nara, Raul, T,164046002.160.000.002443.353558.81
Rubio, Diane,248182438.060.000.000.002438.06
Jai, Bethany, B,248341744.970.000.000.001744.97
Bradley, Richard,2917327.280.000.000.0027.28
Rivera, Kaylee, L,2441971.580.000.000.0071.58
King, Chloe, W,152697.280.000.000.007.28
Ross, Benjamin,137422988.320.000.002988.320.00
Rubio, Lori,1788378.960.000.000.0078.96
Holt, Kyle, J,263062800.440.002049.10751.340.00
Jackson, Megan,1279421.980.000.000.0021.98
Henderson, Samuel, L,154843179.950.000.00782.992396.96
Jai, Bradley,12204119.930.000.0022.9796.96
Rubio, Erik, C,150642992.330.000.002443.35548.98
Raheem, Kurt,161967237.360.002443.350.004794.01
Jenkins, Paige, M,182252349.960.000.000.002349.96
Long, Eric, S,23860548.980.000.000.00548.98
Evans, Jason, P,23584574.980.000.000.00574.98
Lopez, Sara, A,215991170.480.000.000.001170.48
Hernandez, Theodore, R,2297978.960.000.000.0078.96
Jackson, Miguel, S,2327568.970.000.000.0068.97
Sanchez, Bailey,19115148.470.000.000.00148.47
Brooks, Alex,1425171.970.000.000.0071.97
Srini, Troy,156276943.580.002181.560.004762.02
Martinez, Zachary,165877063.560.000.002181.564882.00
Gray, Dalton,1162750.230.000.000.0050.23
Wang, Caleb, P,2822760.470.000.000.0060.47
Hughes, Seth,2591437.930.000.000.0037.93
Becker, Lindsey, J,2584164.970.000.000.0064.97
Taylor, Nicholas,153864.990.000.000.004.99
Zhou, Dawn,2249923.780.000.000.0023.78
Wilson, Natalie, C,153943134.950.000.00782.992351.96
Ortega, Brandi, M,1487085.950.000.0085.950.00
Walker, Jose,22330608.960.000.00608.960.00
Sanz, Kristy,22284600.460.000.00600.460.00
Sharma, Hunter, A,286077.950.000.007.950.00
Alexander, Benjamin, A,2658433.980.000.0033.980.00
Gill, Raquel, T,1721780.960.000.000.0080.96
Tang, Donna, S,2055434.980.000.000.0034.98
Sanchez, Savannah,12927108.460.000.000.00108.46
Scott, Lucas, L,1186642.950.000.007.9535.00
Bryant, Vanessa,129294820.310.002443.350.002376.96
Perry, Stephanie,285997.950.000.000.007.95

Generated 2025-11-02 13:39:27.777 UTC