Share this content
0
320

Pivot table open filter tables

Open up pages on a pivot filter

Didn't find your answer?

Search AccountingWEB

I wonder if anyone can help? On old Pivot tables, it was possible to right click on the pivot table and open pages for each of the filters. These would be separate worksheets for each filer name and would contain data on the pivot but for that filter name only. I don’t seem to be able to do that with the new pivot tables. Does anyone know I can do this?

Thanks in advance for your help.

Replies

Please login or register to join the discussion.

avatar
By KnowHow
09th Apr 2019 18:52

Hi all,

I have found out how to do this and thought of sharing this with everyone:

Select on pivot table, select pivot tools, select the down arrow on options and select “Show Report Filters Pages”.

Hope this helps.

Thanks (3)
Share this content