How to calculate rolling Avg over month in a Pivot Table with multiple dimensions along with time dimension as well
Hi All ,
I have a pivot table with 4 dim along with time dimension as well and expression showing sum of sales. I need to add another expression in the table against the latest /current month only which shows rolling Avg of sales including current month from the start of year ie Jan. I have tries rangeavg but that is not giving me desired result.Request you all to please help asap.I have attached the screenshot of the the Table where i need to insert the required column at the last showing the rolling avg. Please let me know if i need to put any further information in this.