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.
I think you should look into As of Table for this: The As-Of Table
Retrieving data ...