[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Raul, B,12857 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 0.00 | 114.55 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| She, Ramon,18000 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
Generated 2025-12-23 14:29:32.470 UTC