Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Grouping in Pivot Tables?

Discussion in 'Information Technology' started by Jim, Jul 28, 2006.

  1. Jim

    Expand Collapse

    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
  2. Loading...

    Similar Threads Forum Date
    Sikh News 'Pivotal' point: Punjab not worried (Hindustan Times via Yahoo! India News) Breaking News Dec 26, 2007

Share This Page