Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table (XP)

    OK,

    I really have no idea whats going wrong here. I have a table with dates and times for which we have built a Pivot Table to sort the data by grouping months. when only the filled out rows are used to build the pivot chart I can group the months but as soon as I extend the data used to build the pivot chart to include the empty rows the grouping auto comes off and I can not group

    why
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (XP)

    Pivot table grouping by data can be prblematic if all the data field are not of a date type.
    You will receive an 'cannot group' message, or the group option will be unavailable.

    This can be a real pain wher you need to include some blank rows to allow for growth.

    The workaround I use, is to define the data area used by the pivot table as a dynamic range.
    This link may be of help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •