Question about filtering 2 alternate states with one dimension

[Remco]

Hi all!

I have one simple plain dataset, I have filter A with State A and filter B with State B

In table A I have State A select and a simple measure sum gives me the correct sum for each filter set in Filter A and

for table B the same goes, all perfect. In a graph I compare Result A with Result B using Sum({[State A]}RESULT) and for the result for B the same, Sum({[State B]}RESULT). Also this works well.

In the graph there is a dimension, EndYear, that splits up the results per year. Now I come the question:

1) How can I  create a filterpane that 1) only shows those EndYears that are in filtered set A and B and 2) make the graph filter on that dimension?

 Thanks!

[ogster1974]

As a guess try

only({[State A] * [State B]} EndYear)

[Remco]

Hi, thanks for trying, it returns 'Invalid Dimension'...

[Remco]

I managed to get the table for filtering correctly filled, partly with your hint. It works with:

=aggr(only({[State A] + [State B]} [EndYear]),[EndYear])

But now how to apply the filter on the graph with the selected value out of that table?

[ogster1974 · Accepted solution]

using 

EndYear = $::EndYear

[Remco]

You mean, as filter on the measures in the graph?

[Remco]

OK, I found it:

Sum({[State B]<EndYear = $::EndYear>})

and

Sum({[State A]<EndYear = $::EndYear>})

Thanks

[ogster1974]

Your welcome