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.