[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 105.45 | 0.00 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Malhotra, Cynthia,11358 | 5034.78 | 0.00 | 3374.99 | 0.00 | 1659.79 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Kumar, Luke,24161 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 2294.99 | 2442.54 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Martha, G,22210 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Sun, Franklin,19615 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Deng, Clayton, G,17285 | 6093.20 | 3578.27 | 0.00 | 0.00 | 2514.93 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 6.28 | 56.76 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 32.60 | 29.99 |
Generated 2024-11-10 06:53:32.908 UTC