Hello!
I'm new to the forum but not new to Excel It's not so much a problem that I have, so much as something I'm hoping to streamline. I'm simplifying what I do to make it easier to explain, but basically:
I work on a spreadsheet that has multiple worksheets, each one containing a pivot table and one which contains the source data (in a table). When I'm working I have to filter one of the fields on the pivot table to look for something, I then need to have a look at all the pivot tables filtered in the same way. I used to manually filter each pivot table but then someone showed me how to use a slicer (such a time saver!), so now when I apply the filter, it filters ALL the pivots. This is great and I'm very happy with this, BUT... even though it filters everything, it doesn't filter the table which contains the source data, so I have this extra step of needing to remember to go filter the table as well. Is there any way you have the filtering on the table match the filtering on the pivots? When I click on report connection I don't have the option to add the table.
I have created a very simple example which I've attached - You can see how changing either of the pivots also changes the other because of the slicer - however I would like the table to also be filtered to match if possible. Any help on this would be greatly appreciated as it would make my working life a bit better
Thanks everyone!
Richard
Bookmarks