I have a master Line Chart linked on a Trellis. Then in the Trellis I have two dimensions, month and the dimension I am filtering.
What I am looking for is to adapt the Trellis Container, so that in each of the graphs shown, the x-axis and y-axis range is adapted by the dimension to be filtered regardless of the month. For example, if the maximum value has been 100 in a dimension, let the maximum value of the y-axis be that value in all charts of that dimension regardless of the month.
To solve this I've tried
=min(total<Month>Value) AND =AGGR(MIN(Value),Dimension)
But neither has worked, is there any possible solution?
