Jul 04 2020 08:12 PM
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!!
Jul 04 2020 08:45 PM
Solution@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:
Jul 05 2020 11:24 AM
@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
Jul 04 2020 08:45 PM
Solution@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: