Is it possible to proivde a sample workbook and explain the expected result?
Thanks for responding, the data table above is the expected solution.
I work with Insurance firm thus largely working on two data sets - Sales & Claims
Calculated Fields as under -
Frequency - Claims/Sales
Severity - Claim Cost per Policy/Revenue per Policy
Loss Ratio - Claim Cost/Revenue
This data is maintained on weekly/monthly/yearly basis
Each of the parameter has some target that needs to incorporated in the table even if the months move to latest, target needs to be frozen
Frequency 42% 40% 43% 45% 42% 50% Severity 7% 9% 5% 4% 8% 3% Loss Ratio 80% 100% 120% 115% 123% 98%
Hope I am able to paraphrase this.