[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Serrano, Melinda,25681 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Zhang, Aaron, A,22768 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 | 0.00 |
| Gill, Lee, L,27694 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Tang, Bethany,28492 | 3374.99 | 0.00 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Madan, Ross, C,27929 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Murphy, Cindy, M,19655 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 | 0.00 |
| Diaz, Lauren, A,13331 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 | 0.00 |
| Lopez, Katherine,17161 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Bennett, Fernando, M,27174 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Weber, Lydia,23926 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 | 0.00 |
| Fernandez, Carla,26855 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 | 0.00 |
| Bradley, Melanie, G,13343 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 | 0.00 |
| Allen, Thomas, J,13485 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 | 0.00 |
| Coleman, Kelly,15769 | 3159.95 | 0.00 | 0.00 | 782.99 | 2376.96 | 0.00 |
Generated 2026-01-04 04:50:32.936 UTC