Hi,
I would like to know whether it is at all possible to run one Pivot
table from data contained within 2 worksheets?
Worksheet 1 contains a repository of Insurance claims payments
Worksheet 2 contains a repository of Insurance premiums received
An example of what I would like to achieve is: -
Mr Smith has paid us £1000 in Insurance Premiums and has made £500
worth of claims. I would like to anaylse this data in one pivot table
and maybe produce some pivot charts showing Mr Smiths claims as a
percentage of premium paid by Mr Smith.
Any help would be gratefully received.
Regards
--
Emyn
------------------------------------------------------------------------
Emyn's Profile:
http://www.excelforum.com/member.php...o&userid=16148
View this thread:
http://www.excelforum.com/showthread...hreadid=485835