I've been trying that. It won't let me group the data - "Because the field
is grouped, you cannot add a calculated item to it.". I've repeatedly
ungrouped, but still get that message.
--
Randy Harris
(tech at promail dot com)
"Debra Dalgleish" wrote in message
...
Instead of using the Month field in the pivot table, use the Date field
in the pivot table. Then, group the date by year and month. There are
instructions he
http://www.contextures.com/xlPivot07.html
Randy Harris wrote:
I'm not very experienced with Excel, in particular with Pivot tables,
and
would appreciate some help. I have an inherited spreadsheet with a
number
of pivot tables in it. The source data for the spreadsheet gets
"refilled"
from an Access database, but the rows in the pivot table don't generally
get
sorted correctly. The data is in the form of "month year" - e.g. Jan
05,
Feb 05, Mar 05, etc.
I tracked down the source of the data in the spreadsheet, it comes from
a
column on another sheet (column V), labeled Month. It's formula seems
to
be:
=INDEX(Months,MONTH(F1),1)&" " &RIGHT(YEAR(F1),2)
The pivot table frequently appears:
Jul 05
Jan 05
Feb 05
Mar 05
Apr 05
May 05
Jun 05
Aug 05
Sep 05
Dec 05
So, it's not in date order, nor alpha order. The data does appear in
the
source worksheet in date order. What would be a practical means of
correcting this so that the pivot table comes up in proper date order?
Or,
what additional information should I post so that you can help me with
this?
Thank you in advance for any suggestions.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html