Dynamic Report and Alternate State

[dana]

Hi,

I have a request for a comparative analysis with dynamic reports.

So I created 2 groups of filters with alternate states, and two tables.

Each table is linked to a state.

I would like to have the list of dimensions and measures that the user selects, to serve both tables.

I guess I have to modify the show column condition, but not sure how to do it. 

This is an example of a dimension condition:

=SubStringCount(Concat( DISTINCT '|' &[_DimNo_CA_1] & '|'), '|5|') and GetSelectedCount([_Dim_CA_1]) >0

Any idea how to do it?

Thanks!