[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Watson, Jan, K,13680 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Torres, Audrey,16571 | 52.92 | 0.00 | 0.00 | 0.00 | 52.92 |
| Arun, Meagan, W,23930 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
Generated 2025-12-22 02:14:28.558 UTC