[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1064 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Vance, Kaitlin,29383 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Edwards, Edward,14700 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Lu, Brittney, A,12848 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 0.00 | 31.55 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Chander, Sheena, L,16308 | 4551.52 | 0.00 | 0.00 | 2181.56 | 2369.96 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
Generated 2026-01-04 05:38:31.250 UTC