[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1218 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Patterson, Aidan, B,23044 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 | 0.00 |
| Liang, Jaclyn,21632 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Simmons, Austin, L,20290 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 | 0.00 |
| Hernandez, Sara,15167 | 3180.94 | 0.00 | 782.99 | 0.00 | 2397.95 | 0.00 |
| Munoz, Randall, J,16824 | 6938.59 | 0.00 | 0.00 | 2181.56 | 4757.03 | 0.00 |
| Simmons, Vanessa, J,28659 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 | 0.00 |
| Lewis, Miguel,26120 | 3335.24 | 0.00 | 2071.42 | 0.00 | 1263.82 | 0.00 |
Generated 2026-01-04 05:25:18.267 UTC