Filters as buttons

[Anonymous]

Hi,

Me and a colleague are trying to create buttons that filters out unwanted data.

An example of our data set is attached. So, for instance, how would I go about creating a filter on the "English Clubs" button that when pressed filters so that only those rows where "England" appears in the "Country of Club" column.

Likewise, how would I go about creating a filter on the "Barca/Real" button that only shows the rows where either "Barcelona" or "Real Madrid" appear in the "Club" column.

Thanks in advance,

Gareth

[oscar_ortiz · Accepted solution]

Gareth,

You can add actions to your macros as follows:

This will take care of your filters as needed.

Good luck!

Oscar

[Anonymous]

Thanks Oscar,

That was simpler than I thought!

Cheers,

Gareth