[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 288 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| He, Wesley, I,17849 | 3025.53 | 0.00 | 0.00 | 2181.56 | 843.97 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Vance, Kaitlin,29383 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Tang, Kurt, G,13847 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| He, Warren, L,17192 | 6977.58 | 0.00 | 0.00 | 2181.56 | 4796.02 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
Generated 2025-12-24 06:07:52.546 UTC