[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1875 > < TAKE 125 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 782.99 | 0.00 | 2638.94 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xu, Eugene, A,14208 | 117.43 | 0.00 | 0.00 | 58.47 | 58.96 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 48.97 | 29.98 |
| Rana, Kristina,27847 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
Generated 2025-11-03 18:18:25.866 UTC