[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 971 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Theodore,24186 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gill, Danny, L,22320 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Teresa, L,16946 | 3071.03 | 0.00 | 0.00 | 2181.56 | 889.47 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Mehta, Cynthia,14175 | 108.96 | 0.00 | 0.00 | 0.00 | 108.96 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 2049.10 | 4743.01 |
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
Generated 2025-12-23 11:47:18.586 UTC