Hide Columns And Tables In Power Pivot. Start Power Pivot in Microsoft Excel add-in and open a Power Pivot window. In pivot table to hide selected items please do as follows.
All of the columns in this pivot table relate to months of the year. If youre working with a regular and you want to hide calculated items that have zero balances youll want to check out Debra Dalgleishs blog post on the subject To start assume that weve got a fairly simple PowerPivot pivot table that looks like this. Repeat this for the Product Master table as well.
Ensure for Table 1 you set Names ID and for Table 2 you set it to Sales ID.
In pivot table to hide selected items please do as follows. The solution is to use a nice little feature of Data Model editor PowerPivot Data Model window. Your PivotTable Field List renamed to PivotTable Fields in Excel 2013 and onwards is now showing. This allows us to display only relevant columns for the current time period project category etc.