+ Reply to Thread
Results 1 to 3 of 3

Pivot Table

  1. #1
    Registered User
    Join Date
    11-05-2004
    Posts
    17

    Pivot Table

    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

  2. #2
    topola
    Guest

    Re: Pivot Table

    2 worksheets - no problem. Data>Pivot Table>Multiple consolidation
    ranges. Pivot shape will depend on the way your data is organized in
    the tables.
    --
    Tomek


  3. #3
    Registered User
    Join Date
    11-05-2004
    Posts
    17
    Thnx Topola

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1