Forum Discussion

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

excel

training

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:

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

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