How to get Rolling 12 month and average YTD total in pivot

[#1]

Hi,

I have a pivot as shown below with 2 dimension Month and year.

what i Need is a total at the end for Average YTD. for eg average untill april for each year, but i don't want the average to display as pivot column, just the total.

[sunny_talwar]

I think you should look into As of Table for this: The As-Of Table