PivotTable data sorting

Occasional Contributor

Hi all,


I am trying to complete an assignment where I am asked to run a Scenario Manager to compare three different things and produce a (small) PivotTable report... after creating report, which I know I have done correctly, the second instruction is to remove the filter field from the PivotTable as a whole, on the finalized picture, which I can reference, there are no filters, but for some reason, I am unable to remove the filter via any method... either individually via the data -> sort&filters -> clear filters.... or as a collective after right clicking on the PivotTable and going into options, WOULD LOVE SOME HELP!!

2 Replies
Best Response confirmed by gltech (Occasional Contributor)

@gltech , are you referring to the Pivot Table filters? 


You can get to it by clicking on the "Field List" button on the PivotTable Analyze Ribbon:




@TheAntony Yes! Thank you for your help... when I was trying to hide or remove the filters it would alter all the data, when I deselected the singular filter from the field list it changed the look of the table but not the data and I was able to finish everything else, appreciate the help