[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 4 >
4 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
Generated 2025-12-23 05:11:31.846 UTC