[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 110 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Huang, Brent,18220 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 56.97 | 8.99 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Raje, Terrence,18246 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Goel, Misty, M,18245 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Torres, Wendy, A,18269 | 6113.20 | 0.00 | 3578.27 | 0.00 | 2534.93 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 2318.96 | 2418.05 |
Generated 2025-11-06 08:06:17.279 UTC