[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Tang, Jerry,27765 | 742.35 | 0.00 | 0.00 | 742.35 | 0.00 |
| Butler, Julian, L,23328 | 2442.54 | 0.00 | 0.00 | 0.00 | 2442.54 |
| Rogers, Lucas,25085 | 1228.83 | 0.00 | 0.00 | 1228.83 | 0.00 |
| Wang, Heather, R,12499 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Sanchez, Megan, J,11042 | 3112.33 | 0.00 | 0.00 | 2319.99 | 792.34 |
| Chen, Adam,22274 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Wang, Luis,11175 | 6710.55 | 0.00 | 3578.27 | 2341.97 | 790.31 |
Generated 2025-12-23 04:00:46.232 UTC