[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 3500
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Marco,27598 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Madan, Cassandra, D,29068 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Guo, Martha, A,28536 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Chander, Andres, E,29460 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Henderson, Dalton,24895 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Prasad, Cory,19748 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Carol, L,24454 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Malhotra, Phillip, J,21977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Subram, Rebekah,26030 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| _SUM | 9051988.22 | 588293.38 | 2369718.48 | 2452674.72 | 3641301.64 |
Generated 2025-11-04 00:52:59.130 UTC