Hi all Excel experts,

I have a pivot table with 5 row labels (Incident ID, Summary, Description, Priority and Customer Name). I would like to sort the whole data by the 4th row to show priority ranking. At the moment the only way to achieve this is to move Priority column as being the first column.

For example:
Incident ID Summary Descriptions Priority Customer Name
100758 xyz dsjhjhdsjfh 5 John Doe
...
...
...

When I try to sort the priority smallest to largest it just doesn't change the data. It only changes the way the options are sorted in the drop down box.

Any help would be greatly appreciated.

Cheers.