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
Bookmarks