[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1311 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
Generated 2025-12-24 05:58:34.464 UTC