[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Turner, Haley, M,11804 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| Ward, Chloe, L,24425 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Alexander, Dalton,23359 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hughes, Aaron, J,26694 | 4456.14 | 0.00 | 0.00 | 2049.10 | 2407.04 |
| Chen, Justin,26871 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Morris, Andrea,11197 | 207.56 | 0.00 | 0.00 | 0.00 | 207.56 |
| Green, Sierra, L,24222 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
Generated 2025-12-22 02:59:31.626 UTC