[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Stewart, Kaitlyn, A,20663 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Bryant, Morgan, C,21522 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 | 0.00 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 | 0.00 |
| Li, Mandy, L,17224 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 | 0.00 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Zhou, Ramon, D,20057 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 | 0.00 |
| Sharma, Terry,14000 | 84.92 | 0.00 | 0.00 | 0.00 | 84.92 | 0.00 |
Generated 2026-01-04 04:37:22.116 UTC