[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Dawn, A,13956 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Cook, Faith,27871 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Turner, Savannah, E,23430 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Sanchez, Francisco, D,21172 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
Generated 2025-12-23 13:05:50.327 UTC