[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 500 < SKIP 3000 > < TAKE 1000
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 62.98 | 0.00 |
| Subram, Cory, B,27599 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Guo, Don,18742 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Kapoor, Cynthia,29457 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Liu, Dawn, C,21960 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Lu, Todd, D,24269 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 32.27 | 38.98 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 35.72 | 0.00 |
| Liang, Damien, M,22150 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Gill, Gerald, A,28487 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Ferrier, Jaime, P,23528 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Gutierrez, Victor, J,27357 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Colin,26428 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Warren, B,25246 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Raje, Karla,28936 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Henderson, Isabella, L,21981 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| She, Alicia, W,17250 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Vazquez, Krista,26164 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| _SUM | 9051988.22 | 569003.83 | 2369837.92 | 2427099.85 | 3686046.62 |
Generated 2025-11-07 04:54:19.292 UTC