Hi All
I have made a line chart of loss ratios per month based on the formulae:
sum({<AccidentYear={'2008''}>} Claims) / sum(<AccidentYear={'2008''}>} Premium) as AY 2008
sum({<AccidentYear={'2009''}>} Claims) / sum(<AccidentYear={'2009''}>} Premium) as AY 2009
sum({<AccidentYear={'2010''}>} Claims) / sum(<AccidentYear={'2010''}>} Premium) as AY 2010
sum({<AccidentYear={'2011''}>} Claims) / sum(<AccidentYear={'2011''}>} Premium) as AY 2011
sum({<AccidentYear={'2012''}>} Claims) / sum(<AccidentYear={'2011''}>} Premium) as AY 2012
sum({<AccidentYear={'2013''} >}Claims) / sum(<AccidentYear={'2012''}>} Premium) as AY 2013
sum(Claims) / sum( Premium) as Weighted Average Loss Ratio
Dimension is Accident Month. The chart shows me 7 lines.
I would now like to be able to unselect for example AY 2011 so that on the chart AY 2011 is no longer visible and the Weighted Average Loss Ratio is calculated.
However, when I unselect AccidentYear in the corresponding listbox , only the average is recalculated, the line for AY 2011 is still visible although it is based on data only from AccidentYear 2011 which I have unselected in the list box.
How can I make sure that also the Accident Year line, for example AY 2011, disappears when I unselect it in a listbox?
Many thanks.
Best regards,
Jan
