[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 82 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cook, Gabrielle,27637 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gray, Timothy, K,23210 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Beck, Brad,12635 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Clark, Natalie, L,20125 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Zhou, Candice, L,26389 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Walker, Ryan, A,23789 | 1251.12 | 0.00 | 0.00 | 0.00 | 1251.12 |
| Bailey, Faith, D,25846 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
Generated 2025-12-24 07:35:50.362 UTC