[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, Benjamin,16975 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Andersen, Gregory,28510 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Beck, Dawn, L,17415 | 2297.28 | 0.00 | 0.00 | 0.00 | 2297.28 |
| Perez, Marcus,20786 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Shen, Maurice, L,26938 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
Generated 2025-12-23 04:58:39.719 UTC