need help with sorting values(power_cycled_tickets), i tried sorting desc, it didn’t work(could be due to merged “yardcode”)
Hi @kuntakr and welcome to the QuickSight community!
The sorting of pivot tables is a bit different than all other visual types as there are a number of additional factors. Unlike other visuals, pivot table sorting is a bit dependent on which field you setup the sorting on. I would suggest trying to click the 3 dots next to ‘yardcode’ and change the ‘sort by’ to ‘power_code’. This worked for me when testing out but let me know if this provides the desired outcome.