Attached is a workbook with monthly sales figures.
The sheet entitled 'pivot table' is slightly dated as it doesn't include the June figures.
I am basically trying to add the June figures to the pivot table so it continues in the exact same format as for the previous months.
I have added the June data to the source data (FY2014) for the pivot however when I try to up date the pivot table I am not getting the desired result.
Can someone help?