[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 287 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 1000.44 | 2492.32 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
Generated 2025-12-23 14:15:05.105 UTC