I Want to make a KPI which uses the average of the last 6 months for a certain parameter.
So I need to create a virtual variable which should be equal to the avg. of past 6 months and then put in the formula to get desired results.
It should give correct result when viewed on - monthly, quaterly, yearly basis. (in all cases virtual variable should give the avg of last 6 months and then the sum/avg, time consolidation to be applied on KPI)