Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping/calculated items in pivot tables (2000)

    Hi all,
    Having inserted a calculated item into a pivot table I find I can't re-group dates in the row field of the table. I've followed the instructions in the Help - ungroup the dates, insert the calculated item, then regroup. When I attempt to regroup I get an error saying "Because this field is grouped you cannot add a calculated item to it." etc etc. But, the field isn't grouped and I already added the calculated item....
    Any ideas as to what I'm doing wrong would be greatly appreciated.

    Graeme

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Grouping/calculated items in pivot tables (2000)

    GrameH

    Sorry but you may not be interpreting the help properly. I am not sure if you can group a field with a calculated item. Check the MSKB and see what they say...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping/calculated items in pivot tables (2000)

    Wassim,
    Thanks for your post. In the help for calculated items step 7 says:

    "If the items were originally grouped and you ungrouped them in step 1, you can group them again or create new groups that include the calculated item, if you want."

    I do want, but I can't! I've also checked the MSKB, which doesn't offer any explanation.

    Thanks again

    Graeme

Posting Permissions

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