[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1061 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Fernandez, Deanna,24554 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yang, Kelvin,13404 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
Generated 2026-01-04 05:48:12.325 UTC