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 :
I don't think so is there any need of Pivot Table 1 then 2 and in the end 3 ....... calculations can be done by creating Calculated Fields ....
See below link to get exact idea about it .....
http://office.microsoft.com/en-us/ex...CH010004401033
http://office.microsoft.com/en-us/ex...CH010004401033
Last edited by mubashir aziz; 06-03-2009 at 08:17 AM.
If this post helps, Please don't 4get to add to My reputation by clicking BluScale Icon in the Top Right Corner of Blue Bar of my Post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks