[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 6 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Jonathon, F,23954 | 1178.45 | 0.00 | 0.00 | 0.00 | 1178.45 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Smith, Jacob, A,22418 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Alonso, Theodore,24186 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Gomez, Beth, C,13254 | 6801.13 | 0.00 | 0.00 | 2049.10 | 4752.03 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2025-12-22 03:17:25.653 UTC