P
Peter-Jan
Hello,
I have used a "if formula" in a pivot table. To my great worries the totals
of the colums and the subtotals are not correctly computed. In the totals the
pivot table calculates with the original values. So it is no use to use the
formula here. You better filter aftewrwards.
Be careful, I hope Mircosoft corrects this error asap, because this is very
dangerous.
Regards,
Peter-Jan
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...598fae4&dg=microsoft.public.excel.crashesgpfs
I have used a "if formula" in a pivot table. To my great worries the totals
of the colums and the subtotals are not correctly computed. In the totals the
pivot table calculates with the original values. So it is no use to use the
formula here. You better filter aftewrwards.
Be careful, I hope Mircosoft corrects this error asap, because this is very
dangerous.
Regards,
Peter-Jan
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...598fae4&dg=microsoft.public.excel.crashesgpfs