[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| She, Karla, T,12215 | 6890.73 | 0.00 | 0.00 | 2071.42 | 4819.31 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Gill, Danny, L,22320 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
Generated 2025-12-23 04:01:46.665 UTC