How To Create A Hierarchy In Excel?
Follow these steps: Open the Power Pivot window. Click Home > View > Diagram View. In Diagram View, select one or more columns in the same table that you want to place in a hierarchy. Right-click one of the columns you’ve chosen. Click Create Hierarchy to create a parent hierarchy level at the bottom of […]