Pivot Table Group Months Year

[tlchan]

I set up a data input and report for consolidation of data by every staff , I unable to perform pivot table sheet (Sumreport) with grouping of month & year:

File attached

Can anyone rectify the problem for me ?

Thanks

:(

[Bob Phillips]

You didn't include a file, but this (http://www.xldynamic.com/tutorials/pivot%20table%20grouping/Pivot%20table%20grouping.htm)may help you with pivot table grouping