Hi all

PLease see accompanying snippet of pivot table of PAYE data.

My question is, as the data grows i.e. as we enter in the month of July, is there a way to allow the user option to collapse the June data titled 'June' summarising all of June with corresponding grand totals for each category; whilst still enabling expansion at the click of a button.

Thanks for any assistance.

excel.JPG