[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 2500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Xu, Clayton, W,25001 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Sanz, Meghan, L,28352 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 88.46 | 49.99 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 71.58 | 34.98 |
| Alan, Meghan, I,28210 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 62.98 | 69.97 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Raman, Frederick, F,28942 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 48.98 | 0.00 |
| Vazquez, Bruce, P,20417 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Carlson, Krista,28209 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 40.22 | 0.00 |
| Suri, Kaitlin, C,29190 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 105.45 | 0.00 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Lal, Nicolas, D,21212 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-11-06 19:35:23.962 UTC