A
arun
Hi All,
I have a pivot table, whose data is coming from static table.
in source table, there are 12 month date(jan -Dec) for every manager.
So in pivot table, all dates are coming which are present in table.
My need is that, in pivot table the date column should show like this
Sep-08(Month should be current but date should 2009-1 i.e 2008)
Oct-08
Nov-08
.....
.....
.....
Aug-09
up to 12 month.
Wanted to avoid filter manually.
Can we create forumula or need to write VB macro.
I have a pivot table, whose data is coming from static table.
in source table, there are 12 month date(jan -Dec) for every manager.
So in pivot table, all dates are coming which are present in table.
My need is that, in pivot table the date column should show like this
Sep-08(Month should be current but date should 2009-1 i.e 2008)
Oct-08
Nov-08
.....
.....
.....
Aug-09
up to 12 month.
Wanted to avoid filter manually.
Can we create forumula or need to write VB macro.