[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 7 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Alisha,17972 | 2791.53 | 0.00 | 0.00 | 2181.56 | 609.97 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Patel, Dominic,29366 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Goel, Christy,26409 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-12-22 02:22:38.331 UTC