Look for the Power Pivot tab to the left of Pivot Table Tools in Excel.įirst step - convert your pivot source data set to a table using either Home - Format as Table or Ctrl + T.
(Or, if you just want to try the feature, download the Excel file that I created: Hierarchy.xlsx) If you don't have the Power Pivot tab in your Ribbon, you will have to find a co-worker who has the button in order to create the hierarchy. Look for the Power Pivot tab to the left of PivotTable Tools tabsĪfter some research, there is a way to use them, but you have to use the Data Model and use the Power Pivot diagram view to create a hierarchy. Why are these perpetually greyed out? They take up a lot of space in the Ribbon. Recently, a friend of mine wondered about the Drill-Down and Drill-Up buttons in the Pivot Table Tools tab of the Ribbon.
