This content has been marked as final. Show 3 replies
I am creating a pivot table showing FY 2017 Headcount data. Here i want to merge Dec-2016 values (for a certain Headcount type) in Jan 2017, as my pivot table is for 2017. The result should be a table showing 12 months (Jan 2017- Dec 2017) + Dec 2016 values to be added in Jan 2017.. How do i achieve this. I dont want Dec 2016 to be seen in the table.