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
Bookmarks