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.
If it is handled that way for every December then you can handle it in scripting. May be by creating another dimensional value so you will still have the original dimension if you need to use it for other purposes.