[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1188 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Jenkins, Hunter,21476 | 1197.41 | 0.00 | 0.00 | 0.00 | 1197.41 | 0.00 |
| Harris, Morgan,12942 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 | 0.00 |
| Watson, Dalton, P,26201 | 4498.46 | 0.00 | 2071.42 | 0.00 | 2427.04 | 0.00 |
| Raje, Tracy,24155 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Roberts, Miguel, C,13662 | 3021.04 | 0.00 | 2181.56 | 839.48 | 0.00 | 0.00 |
| Long, Christian,24690 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 | 0.00 |
| Xu, Wayne, M,18014 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 | 0.00 |
| Anand, Shaun,25524 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
| Bryant, Chloe, J,13230 | 4905.32 | 0.00 | 2443.35 | 0.00 | 2461.97 | 0.00 |
| Romero, Hector, E,25299 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Vance, Pedro, A,11499 | 192.21 | 0.00 | 0.00 | 0.00 | 192.21 | 0.00 |
| Andersen, Gregory,28510 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 | 0.00 |
| Lewis, Ashley, L,12960 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 | 0.00 |
| Rubio, Orlando,19910 | 3188.46 | 0.00 | 782.99 | 0.00 | 2405.47 | 0.00 |
| Coleman, Blake,26526 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 | 0.00 |
Generated 2026-01-04 05:47:48.584 UTC