[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 39 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Rebekah, H,14825 | 61.45 | 0.00 | 0.00 | 0.00 | 61.45 |
| Martin, Krista, E,14189 | 8317.32 | 0.00 | 3578.27 | 2419.06 | 2319.99 |
| Ramirez, Chase, A,27439 | 4462.16 | 0.00 | 0.00 | 2049.10 | 2413.06 |
| Yang, Leah, J,15186 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Green, Nathan, C,17487 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Alexis,15316 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Abigail,29215 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2025-12-23 07:14:02.048 UTC