Sorting A Pivot Table While Applying Value Calculation

When you apply a calculation to the 'Value' area of the pivot Table such as % of row total or % of Column Total, then the way you sort the results in the Pivot table are not obvious and can be frustrating.
This video goes through how to sort such pivot Tables and what pit-falls to look out for when updating the pivot table with new data.