[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 22 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Suarez, Casey,26548 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
Generated 2025-12-22 08:28:29.824 UTC