Grouping in Pivot Tables?

J

Jim

I have a pivot chart in Access that shows sales by the month. If I have more
then one year showing at a time, it puts the years in different colors and
lists the months like this: Jan, Feb, Mar - Jan Feb Mar. I want to be able
to group them so all the months are together, separated by color for the
year, and only have a listing of the months once on the bottom so I can
compare say, Jan04 to Jan05 side by side.



When I try to group them, I get a message that says "You can not group items
that belong to different parent items. The items you selected belong to the
1 and 1 items of the quarters1 field.

Does anyone know how to get around this?

Thanks for any help



Jim
 
M

Michel Walsh

Hi,


You can manually edit the PIVOT, something like:


PIVOT Format(dateTimeField, "mmm") & Format(dateTimeField, "yyyy")


Hoping it may help,
Vanderghast, Access MVP
 
Top