[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Chloe, L,23361 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Vazquez, Derrick,14966 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Collins, Ian,25904 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Jenkins, Ian, M,11013 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Edwards, Kaitlyn,20372 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Simmons, Jennifer,11262 | 1126.82 | 0.00 | 0.00 | 0.00 | 1126.82 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
Generated 2025-12-23 07:13:27.980 UTC