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.

If these are dates the just set the field's sort on ascending. If they
aren't, then add a column to the source table converting to dates, then use
this in the oivot table. you can sort ascending and format the field mmm-yy
as required



"arun" wrote:

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.

Hi Patrick,

In source table, the date column showing dates from Jan-2008 to Dec-2009,
but i wanted to show Sep-8--Aug-2009(Because current month is Sep & starting
year should less then cureent year )

Sep-08
....
....
Aug-09
Total 12 months.


"Patrick Molloy" wrote:

If these are dates the just set the field's sort on ascending. If they
aren't, then add a column to the source table converting to dates, then use
this in the oivot table. you can sort ascending and format the field mmm-yy
as required



"arun" wrote:

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.