[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 19 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brooks, Xavier, H,15770 | 3179.93 | 0.00 | 0.00 | 782.99 | 2396.94 |
| Luo, Tara, W,21538 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Allen, Mackenzie,21333 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Bell, Cody, A,12965 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Pal, Edwin, M,13573 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Davis, Alyssa, C,13243 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
Generated 2025-12-22 07:18:11.100 UTC