Forum Discussion

gltech's avatar
gltech
Copper Contributor
Jul 04, 2020
Solved

PivotTable data sorting

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!!

excel
training
  • TheAntony's avatar
    TheAntony
    Jul 04, 2020

    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:

     

     

2 Replies

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Jul 04, 2020

    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:

     

     

    • gltech's avatar
      gltech
      Copper Contributor
      Jul 05, 2020

      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