Wanted to show 12 month Date in Pivot table

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.
 
P

Patrick Molloy

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
 
A

arun

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top