1 of 1 people found this helpful
Since a table calculation is being used, using a filter will not work--because it filters out data in the table that needs to be used in the table calculation. However, if only one month/year needs to be shown at a time, a parameter could be used. I have attached a sample workbook showing how to do this.
Hope it helps!
Thanks a lot for this. It helps even though it doesn't give me the ultimate solution.