[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Bailey, Alexa,27475 | 33.43 | 0.00 | 0.00 | 0.00 | 33.43 | 0.00 |
| Diaz, Marcus, H,26330 | 2821.72 | 0.00 | 0.00 | 2071.42 | 750.30 | 0.00 |
| Gutierrez, Beth, C,11395 | 5729.97 | 0.00 | 3399.99 | 0.00 | 2329.98 | 0.00 |
| Cox, Jasmine,25086 | 1308.31 | 0.00 | 0.00 | 1308.31 | 0.00 | 0.00 |
| Gill, Arthur,26689 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 | 0.00 |
| Xie, Kenneth, J,13842 | 826.46 | 0.00 | 0.00 | 0.00 | 826.46 | 0.00 |
| Brown, Jessica, L,11671 | 5970.23 | 0.00 | 3578.27 | 0.00 | 2391.96 | 0.00 |
| Baker, Savannah, C,11081 | 104.26 | 0.00 | 0.00 | 0.00 | 104.26 | 0.00 |
| Garcia, Hannah,28105 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Yang, Alvin,28497 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 | 0.00 |
| Ruiz, Arthur,23920 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Flores, Jacqueline,23560 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
Generated 2026-01-04 05:39:28.270 UTC