Explain what you want to show in report exactly. please attach the workbook.
Well on the dashboard when I open it, It displays the information for all shops.
When I click on one of the names it then displays only the data for that shop but if I wish to go back(to check figures) to having all shops selected I have to basically reload the dashboard.
So I wish to add an (ALL) selection so I don't have to keep reloading.
When setting up your filter action why don't you just select the option that says 'Clearing the selection will show all values' and put a little message on the dashboard to inform users that's how you show All?
An alternative is to add a grand total and rename it to 'Show All' but this will always be at the bottom of your list.