[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 75 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Wyatt,17194 | 111.45 | 0.00 | 0.00 | 0.00 | 111.45 |
| Yuan, Donna, D,29434 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Rana, George,23504 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Zhou, Candice, L,26389 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Brooks, Jasmine, S,19252 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Hill, Jonathan, E,11171 | 6716.55 | 0.00 | 3578.27 | 2381.95 | 756.33 |
| Wood, Jessica,11863 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 |
Generated 2025-12-21 22:38:15.597 UTC