[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 19 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Zheng, Jessie, W,18028 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Nelson,25728 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
Generated 2025-12-22 01:08:50.764 UTC