Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Pivot Table with Calculated Item

    I have a pivot table that compares budgeted sales to actual sales. In this pivot table I have a "product class" field in the "PAGE" function, and I have a "product name" field in the "ROW" function.
    For example, "Milk Products" is in the "PAGE" function, and "Cheese", "Yogurt", and "Ice Cream" would show up in the "ROW".
    My problem stems from inserting a calculated item for the "Source" field (source being "actual" and "budget") in order to calculate the variance.
    When I use the "PAGE" function to select "Milk Products", it doesn't filter properly. For example, all product names, under all product classes show up on the report, however those product classes and product names that do not fall under the "Milk Products" category show up with a zero value. In other words, the words show up, but the numbers don't, so technically the numbers are right, but I don't want to see all the extra words.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table with Calculated Item

    Thats wierd. I never had that happen when I use the calculated field option. One way around this would be to block the product names that are non dairy by double clicking on the products field and cliking (shading out each non-dairy item). But then you would have to create a different copy of the table for each class of products. Can you use the Calculated Field Option?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table with Calculated Item

    See the response I sent in a few minutes ago to "Re: Pivot Tables, Calculated". I think it might be of some help to you. Basically, if you double click on the Product Field and select Advanced, you can limit the display to the top rows (those with non-zero values).

Posting Permissions

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