Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have this pivot table with few dimensions... one of the dimension values are shown horizontally and there is a sub partial column (Total) - I am trying to get the data sorted by Total values.. i do not care for other dimensions i just want the data to be sorted in descending order based on the sub partial column which is TOTAL
attached some sample data - thanks for any suggestion/ideas
Did you try the sorting by y value?
Reha, did Sunny's suggestion work out? If so, do not forget to close the loop on the thread by using the Accept as Solution button on his post to mark it giving him credit for the help and letting other Community Members know it did work for you. If you are still working on things, leave an update on where you are and what you need.
Regards,
Brett