[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 7 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Alexander, Ethan, A,19664 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Ma, Jon,17605 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Kelly, Cody,23697 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 | 0.00 |
| Rana, Manuel,21075 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 | 0.00 |
Generated 2026-01-04 04:42:55.836 UTC