[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ma, Alisha,17972 | 2791.53 | 0.00 | 0.00 | 2181.56 | 609.97 |
Generated 2025-12-23 12:33:58.955 UTC