Sorting a calculated field column in a Pivot Table

Question

_{Tuesday, September 11, 2012 1:04 PM | 1 vote}

I have multiple columns in my pivot table and one of them is a calculated field.  In Excel 2003 I could select a cell in that column and click on sort (asending or desending) and it would sort the column I have a cell selected in.  That is not working in excel 2007.  How can I do this? 

All replies (4)

_{Wednesday, September 12, 2012 3:21 AM ✅Answered}

Hi,

Based on my research and test, here’s an example to explain the issue:

Jaynet Zhang

TechNet Community Support

_{Thursday, September 13, 2012 5:47 PM}

check this video this may give you some idea

http://www.youtube.com/watch?v=Z62E8tuMDPc

_{Sunday, April 28, 2013 6:52 PM}

You can sort on a calculated field by selecting the entire column and using the "Sort & Filter" section of the Data tab in the Ribbon Menu.

more info: http://aaron-hoffman.blogspot.com/2013/04/microsoft-excel-2013-sort-pivot-table.html

_{Tuesday, August 13, 2019 5:35 AM}

I have a pivot table with count of returns vs. sold

Using the same data, I displayed it as a percentage of the row.

I wish to sort the data based on the % of row. Please help.

I am able to sort by value 52,46,45,45,27...

But I want to sort by % - 100%,100%,87% and so on..