Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Error creating Pivot Table formula

    I get this error message whne I try to create a new pivot table formula: References to multiple item names per field cannot be included in pivot table formulas.

    Here's a screenshot of the pivot table structure and the Insert Calculated Item wizard
    PivotTableError.jpg

    I can't see why this formula doesn't work. Any clues?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Sure. I got it.

    I must have been asleep at the wheel. I placed items in the Row Labels instead of the Values.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Do not sleep at the wheel.
    Take a break.

    zeddy

Posting Permissions

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