[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Chen, Krystal, D,13530 | 186.28 | 0.00 | 0.00 | 0.00 | 186.28 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Diaz, Kathleen, C,28375 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Zhang, Colleen, L,16562 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
Generated 2025-12-22 02:23:24.568 UTC