[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 219 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Colin,12138 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Harris, Hannah, S,26606 | 2890.41 | 0.00 | 0.00 | 2049.10 | 841.31 |
| Gutierrez, Krista, R,15071 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Rivera, Cole, R,13736 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Harris, Jasmine,26635 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Thompson, Charles, J,13724 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Gonzalez, Haley, J,20706 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
Generated 2025-12-24 06:16:39.433 UTC