[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 190 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Willie,29304 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Zhao, Kristen,16930 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 0.00 | 140.45 |
| Xu, Glenn,18743 | 67.21 | 0.00 | 0.00 | 0.00 | 67.21 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Gutierrez, Rodney, J,20628 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Munoz, Jimmy, E,21573 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
Generated 2025-12-23 11:47:10.613 UTC