[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 719 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Kapoor, Clifford, A,12535 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Moore, Isabella, B,26632 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 | 0.00 |
| Navarro, Darren, E,19203 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Ross, Richard, J,20877 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Deng, Bonnie, A,24060 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 | 0.00 |
| Washington, Jocelyn,17946 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 | 0.00 |
| Navarro, Alfredo, N,15070 | 2770.82 | 0.00 | 0.00 | 2181.56 | 589.26 | 0.00 |
Generated 2026-01-04 05:19:16.790 UTC