Hello Everyone,
I have a case where I am calculating monthly % on front end. Once it is calculated in the same chart I need to calculate the average of last 5 months including current month.
I am using rangeavg and above to do this but it's not working for the cases untill I get 4 months above that month. Till that case it only calculates whichever month available.
For example my table contains data from Jan-2017 to Jan-2018 it starts calculating correctly after May-2017, but desired output is to calculate for Jan-2017 by considering Sep-16 to Jan -17 instead of considering only Jan-17.
Sample data is attached.
Regards,
Ajay Rai
