Calculate score on the fly for each month and then carry forward the score to next month

[mugdhaojha]

Hi,

I would like to achieve the below -

In the above example, I have 2 pivot tables for months- Jan and Feb, dimension - Factory and KPI, and for measure delta percentage between actuals and forecast a score is assigned based in which range the delta value lies.

This value is then to be summed up in the Overview table.

For Feb month, the overview table will sum up the score from both Jan and Feb tables.

Any ideas how this can be implemented?