Author: Joyce Zhou
It’s simple to reverse the hierarchy display in a Kepion Form. You just need to check the Reverse option in the Layout tab. If you want to reverse a hierarchy in an Excel PivotTable, it's a bit more complicated. Follow this procedure to learn how to do so.
If you want to display the whole hierarchy in the reverse order, you will need to explicitly expand all hierarchy members. We've only expanded a few in this example for simplicity.
2. Go to PivotTable Analyze > Fields, Items, & Sets > Create Set Based on Row Items.
3. Use the Up and Down buttons to re-order the set.
4. Un-check the Display Items from different levels in separate fields.
5. Click OK to finish.
The PivotTable will use the set you just created. However, you will lose the expand/collapse capability. You will also need to manually indent the row/column labels.