Hi,
I have created a pivot table with % column at the end. However, it is not getting sorted in ascending or descending order, which i believe is most likely due to merged cells in first column. I want to know how to resolve this issue- of sorting and unmerging. Attached image for reference, where we can see merged cell and unsorted % column
Hi @uprt12 and welcome back the Quick Community!
The difficult part with pivot tables as you have noticed is the grouping logic it applies to the fields that you place in the rows field well. So, I think the solution will lie in messing around with the fields that apply the grouping logic to the visual. One thing I can think of is to change the ‘sort by’ field for each of your fields in the rows field well to your percentage column. Refer to the screenshot below on how to change what field is being used to sort by:
In this case, this will sort essentially your whole table by your percentage field, but this will make it so you can give a sorting order to your percentage field.
Hope this helps!
Hi @JacobR ,
Understood.
thank you for assistance.