Assume that someone has created a Pivot Table using the PowerPivot tool. Now one may want to customize the Pivot Table even further by:
1. Shuffling rows in the Pivot Table; and
2. Recomputing subtotals and Grand Totals after reshuffling rows
A Pivot Table created via the PowerPivot tool can be converted into a normal range via CUBE formulas. Once each cell carried an individual formula, one can very easily perform the two tasks mentioned above. You may view my solution in this workbook.
You may watch a short video of my solution here