The "Show Report Filter Pages" is grayed out in Excel Pivot Table Analyze . How do I fix it?

Copper Contributor

while i was working on my pivot table i found out that the show report fliter is greyed and i cannot get it to work any help would be appreciated

3 Replies
i have tried all of that but still the same

@Joe_Amr 

Quite strange. If you DO NOT use data model standard behaviour is like

image.png

and PivoTable Fields pane looks like

image.png

If you use data mode, table name(s) are shown in above pane

image.png

How the pane looks in your case?