Hi
I hope you can help me! An acquaintance of mine has two pivot tables.
Essentially they both analyse the same data. One is in whole numbers (Pivot 1)and the second is in percentages.(Pivot 2) She was wondering if it was possible to multiply these two pivot tables by each other so that she has a third pivot table that shows the figures from Pivot 1 multiplied by the percentages in Pivot 2. At the moment she is using copy and paste special to do that. I was wondering if it could be done in some sort of array way..
I'm not sure that it can be done without some sort of code...
All help appreciated!

Anne :