can two filters be linked?

[zazzz]

Please see attached pic. The top is a summary of the bottom. I was able to use two filters on the same page by making the first set a table. I don't actually care much for the table so if there's another way to do 2 sets of filters please let me know. But that's a different matter.

Anyway so I was wondering if there's a way to link these 2 filters so that filtering for a store in one automatically filters for that store in the other? At the moment I have to do it myself each time. Which is fine when its just one but when I have to go back and forth multiple times it gets a bit much.

[newdoverman]

Can you please post an Excel file rather than a picture. I can see the picture but it is too small to read and no one can work with just a picture.
Thank you.

[zazzz]

OK done. Please see here:
https://www.dropbox.com/s/cnufj6dqnv...tion.xlsx?dl=0

Sorry about the formatting. I tried attaching it here but I kept being told the file is too big. So I kept removing more and more stuff, including formatting, to get it down to 1 MB. Still couldn't do so so I've used Dropbox, but in the process of trying to attach it here I made it much less prettier.

[FDibbins]

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

[zazzz]

OK but how do I make it smaller then? Apparently at 1.2 MB its too large and I've removed all the irrelevant things.

[protonLeah]

You must compress/zip it. In windows explorer, select the file, right click and choose send to compressed (zipped) folder.