[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 61 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Morgan, Lauren,24217 | 1209.47 | 0.00 | 0.00 | 0.00 | 1209.47 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Sharma, Ricardo,16512 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| He, Alan, A,12210 | 6825.45 | 0.00 | 0.00 | 2071.42 | 4754.03 |
| Andersen, Damien, K,29402 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
Generated 2025-12-24 06:40:11.212 UTC