[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moore, Anna, A,12744 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Raje, Brad, E,21547 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Tang, Carly, A,22470 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Henderson, Hunter, C,14812 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gutierrez, Audrey,17829 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
Generated 2025-12-23 12:08:45.865 UTC