Hi,

I have a query table that is built from the 'union' of 5 other tables.

Store 1 sales

Store 2 sales

Store 3 sales

Store 4 sales

Store 5 sales

Each of these tables is the sales data from a store, made into a 'big' table that has all of the data.

How can I create a selectable filter in the 'big' (combined) table so that I can select a store and see only it's data?