Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
As a guess try
only({[State A] * [State B]} EndYear)
Hi, thanks for trying, it returns 'Invalid Dimension'...
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?
using
EndYear = $::EndYear
You mean, as filter on the measures in the graph?
OK, I found it:
Sum({[State B]<EndYear = $::EndYear>})
and
Sum({[State A]<EndYear = $::EndYear>})
Thanks
Your welcome