[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 10 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Maurice,14821 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Luo, Christy,16277 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Rai, Kristin, C,12569 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hernandez, Joanna,19360 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
Generated 2025-12-22 02:07:22.944 UTC