[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1041 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 | 0.00 |
| Howard, Charles,13319 | 4647.51 | 0.00 | 0.00 | 2181.56 | 2465.95 | 0.00 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Bennett, Grace, A,28819 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Xu, Jenny, B,28744 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 | 0.00 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 | 0.00 |
| Perez, Isabella, D,28541 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
Generated 2026-01-04 04:42:55.301 UTC