[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1109 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Chandra, Brenda,15100 | 6952.58 | 0.00 | 2181.56 | 0.00 | 4771.02 | 0.00 |
| Roberts, Kyle,12217 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Phillips, Samuel,26128 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Williams, Isabella,23790 | 46.83 | 0.00 | 0.00 | 0.00 | 46.83 | 0.00 |
| Watson, Alex, B,25966 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 | 0.00 |
| Campbell, Jada, F,24643 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 | 0.00 |
| Washington, Brandon, E,20477 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
Generated 2026-01-04 05:48:23.306 UTC