[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1031 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Christian, R,28537 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Kapoor, Phillip,27581 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jenkins, Amanda,15214 | 4490.88 | 0.00 | 0.00 | 2071.42 | 2419.46 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Kumar, Tamara, A,25222 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Taylor, Logan,13522 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Sara, Carmen, W,12582 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Lu, Martha, R,21255 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Lu, Tiffany,22843 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
Generated 2025-11-06 19:58:21.297 UTC