[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Davis, Benjamin, C,13672 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Jones, Daniel, J,14721 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Megan,23896 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Zhao, Franklin,20134 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Romero, Kathleen,14019 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Edwards, Savannah,13367 | 4516.53 | 0.00 | 0.00 | 2181.56 | 2334.97 |
| Sanders, Ian, N,17275 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-21 17:01:39.089 UTC