Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Prasnna,
with the help of set analysis you can achieve anything.like below:
Sum({<MonthYear = {"Dec 2016"}>}Value)
Thanks
Arvind Patil
Just write as dimension in your chart :
=if(MonthYear='12/2016','01/2017', MonthYear)
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.