[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 875 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Guo, Lacey,16744 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Arthur, Carla,16710 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Lu, Jamie, M,23646 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 556.26 | 0.00 |
| She, Bradley, L,16016 | 117.93 | 0.00 | 0.00 | 0.00 | 117.93 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 24.99 | 17.27 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 63.97 | 74.48 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Xu, Trisha,20282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 845.31 | 0.00 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 13.98 | 30.97 |
| Rubio, Kathleen, A,20820 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
Generated 2025-11-06 21:04:39.483 UTC