Pivot Table with Calculated Item

Topic

New Reply

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.

Reply | Quote

Replies

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?

Reply | Quote

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).

Reply | Quote