[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 252 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 0.00 | 1000.44 | 1151.76 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 0.00 | 3587.11 |
| Hu, Kristen, C,19788 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| She, Jaime, D,28482 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Carlson, Lawrence, L,22064 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Blanco, Robyn, R,24179 | 3052.31 | 0.00 | 0.00 | 2443.35 | 608.96 |
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Liu, Christy,19784 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 2443.35 | 1143.46 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 0.00 | 118.74 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Raman, Dominique, D,13023 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-23 04:59:47.305 UTC