How to sort by calculated item

[amuguet]

Hello Everyone,

I am having a slight problem with a pivot table and was hoping you could help me. I am trying to compare data between two production plan to determine the changes that have been made from one week to another. I have the data for both versions and have created a calcualted field to show me the difference between those versions.

Where I am having an issue is that I would now like to sort by that calcuated field, to identify the biggest changes to the production plan, but I am unable to do so.

Here's what the table looks like:
http://www.flickr.com/photos/amuguet/6210207619/in/photostream

Thanks for any help you give me!

Cheers,

 

[Saagar]

See if this helps:
http://office.microsoft.com/en-us/excel-help/sort-a-pivottable-or-pivotchart-report-HP005202971.aspx