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.