Author: Joyce Zhou
It’s simple to reverse the hierarchy display in a Form. You only need to check the Reverse option in the Layout tab in the Form. It would take more work to get this job done in an Excel PivotTable.
Create your PivotTable first. If you want to display the whole hierarchy in the reverse order, you will need to explicitly expand all hierarchy members. We only expanded a few in this example for simplicity. When you are done with the row/column label display, select Create Set Based on Row Items option in the ANALYZE tab.
In the New Set window, you’ll see all the displayed members from the row/column. You’ll need to use the Up and Down button to re-order the set to reach the final result you want to get.
When finished reordering, you also need to un-check the Display Items from different levels in separate fields option on the bottom left. Click OK to finish.
The PivotTable will use the set you just created. However, you will lose the expand/collapse capability. Also, you will need to indent the row/column labels manually.