How to Hide Data in pivot table

Right-click the table or column you'd like to hide and select Hide from Client Tools. In Power Pivot, hiding a column does not remove it from the model. A hidden column can still be used as a sort column in a table. It can also be referenced in formulas that define calculated columns or calculated fields.