[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 10 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Andersen, Shawna, C,19556 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lopez, Sergio, L,15123 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
Generated 2025-12-23 09:11:04.742 UTC