[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lin, Kelli, A,21392 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lopez, Carla, G,28326 | 2442.54 | 0.00 | 0.00 | 0.00 | 2442.54 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
Generated 2025-12-21 20:43:00.249 UTC