[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE SKIP 1875
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 801.77 | 742.35 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Russell, Emma, I,21512 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Torres, Rodney, L,22520 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
Generated 2025-11-04 01:31:48.961 UTC