[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1178 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| King, Noah,25876 | 4629.07 | 0.00 | 3374.99 | 0.00 | 1254.08 | 0.00 |
| Munoz, Reginald, C,25889 | 4651.11 | 0.00 | 3399.99 | 0.00 | 1251.12 | 0.00 |
| Flores, Isabella,25161 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 | 0.00 |
| Parker, Jesse,23032 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Nara, Andres, A,12332 | 7211.26 | 0.00 | 0.00 | 0.00 | 7211.26 | 0.00 |
| Ye, Tiffany, K,23326 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 | 0.00 |
| Hughes, Alexandra,20440 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 | 0.00 |
Generated 2026-01-04 05:49:01.311 UTC