[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Foster, Mary,24112 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rivera, Dalton, E,28366 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-12-22 00:30:56.075 UTC