how to create a report for comparing dimension values

[aheavy95]

Hi all, looking for help regarding a report I wish to create

So in my project, there is a "Store" field,  all the stores are part of a branch.

There are a few property fields for the stores (For example whether store has parking, whether its inside a mall, etc..)

In the report, I want to let the user select a value of the 'Store ID' field and select a few properties.

In a pivot table  ( ad hoc table),  only Stores with matching values in the property fields selected will appear.

For example, if the user selects Store ID '1'  from the Stores filter, and from the properties filter- 'has_parking, 'is_in_mall',

assuming that Store 1 has parking and its inside a mall - all Stores will be shown.

I was thinking of using alternate states.

Hope I am clear