[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 39 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Ronnie,17892 | 2787.51 | 0.00 | 0.00 | 2181.56 | 605.95 |
| Torres, Tanya, L,23986 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 0.00 | 2049.10 | 3788.74 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
Generated 2026-01-04 08:53:11.093 UTC