![]() In the Create PivotTable dialog, choose the box for Add This Data to the Data Model. Make sure that the option for My Table Has Headers is selected. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |