[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1048 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stewart, Evan, M,27426 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Foster, Arianna, L,18313 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wright, Carlos, K,15515 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stone, Dawn, T,28558 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Dominguez, Marc, J,12539 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Jenkins, Abigail,15473 | 1552.48 | 0.00 | 0.00 | 782.99 | 769.49 |
| Martin, Eduardo,11264 | 3182.27 | 0.00 | 0.00 | 2375.95 | 806.32 |
Generated 2025-12-24 06:26:05.326 UTC