Results 1 to 2 of 2

Thread: Join info from 2 Pivot Tables

  1. #1

    Join info from 2 Pivot Tables

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I have two separate tables, each of them generating pivot tables to summarize data.
    The first table concerns to sales, and is quite about this structure: Store; Month; year; Country; Amount of Sales; and the second table is about the number of people entered the stores, with structure as Stores; Month; year; Country; Traffic People.

    I have this info in separate sheets since it comes from different sources.

    Until now i had to analyse it separately, meaning, amount of sales for the year, total of people entering the store .My question is that i need now to evaluate crossing data, meaning, a ratio between people and sales, and to evaluate trends during time frame analysed.

    Without merging the tables, is there any options of picking information from the two supporting pivot tables from each sheet, cross information and obtain these ratios to the minimal disclosure, ie, by line of each table?
    What do you recommend me?

    PS: I'm using Excel 2010.

    Many thanks in advance.

  2. #2
    Excel 2010 with free PowerPivot Add-In.
    Share file.

Tags for this Thread

Posting Permissions

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