[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Henderson, Madison, M,21488 | 638.95 | 0.00 | 0.00 | 638.95 | 0.00 |
| Tang, Katrina, K,14186 | 9796.32 | 0.00 | 2443.35 | 0.00 | 7352.97 |
| Mr., Seely, Scott,16603 | 7000.55 | 0.00 | 0.00 | 2181.56 | 4818.99 |
| Martinez, Lauren, L,11272 | 5975.23 | 0.00 | 3578.27 | 2396.96 | 0.00 |
| Sanders, Erin, A,11310 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Reed, Victoria, J,25088 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Gonzalez, Richard, J,19159 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Jai, Cristina, R,29363 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Scott, Fernando, C,22254 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Romero, Daisy, M,14198 | 8308.59 | 0.00 | 3578.27 | 2433.04 | 2297.28 |
| Raje, Drew, D,26831 | 1264.84 | 0.00 | 0.00 | 1264.84 | 0.00 |
| Hayes, Isabel,21908 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Peterson, Marcus, L,16803 | 1759.97 | 0.00 | 0.00 | 1759.97 | 0.00 |
| Torres, Grace, J,21615 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Simmons, Brandon,18946 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Johnson, Eduardo, Q,21852 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Long, Samantha,11128 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Stewart, Victoria, C,11259 | 6770.60 | 0.00 | 3578.27 | 2414.99 | 777.34 |
| Green, Richard, M,11805 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Lee, Brianna, R,19202 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Raji, Roger, M,22436 | 607.96 | 0.00 | 0.00 | 607.96 | 0.00 |
| Garcia, Robert, J,26039 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Rubio, Craig,16937 | 3926.53 | 0.00 | 0.00 | 3926.53 | 0.00 |
| Brooks, Zoe, L,19017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martin, Latasha,16798 | 1764.96 | 0.00 | 0.00 | 1764.96 | 0.00 |
| Jenkins, Jennifer, B,29237 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Cook, Juan,17146 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Albert,16131 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Blue, Riley, M,23042 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Sharma, Alison,21094 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Carlson, Kristi,21055 | 1566.78 | 0.00 | 0.00 | 0.00 | 1566.78 |
Generated 2025-11-06 12:05:20.347 UTC