I have a chart with a drilldown dimension and I want the reference line (showing the average) to adjust automatically to the second dimension. Take for example the image below. The reference line displays the average sales of all countries. If I select Germany now, I want the reference line to adjust to the sales of German countries, i.e. displaying the average sales above all German cities.
Or is there a possibility to hide the reference line when going into the second dimension?