[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 12 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Dustin,23481 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Collins, Noah,21298 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| Long, Vanessa, R,19533 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bryant, Victoria,28636 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Moreno, Lawrence,24798 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Clark, Grace, L,12098 | 83.97 | 0.00 | 0.00 | 8.99 | 74.98 |
Generated 2025-12-23 07:24:32.375 UTC