Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Combine several pivot tables into one (Excel 2003 / SP1)

    I have 2 separate sheets that are data sources. On a total report sheet, I have pivot tables showing the results of each sheet. I want to combine the pivot tables into a "total" pivot table. I've tried the source data as both "mutiple consolidation ranges" and "another pivot table report." I just can't seem to get there. What am I missing?
    thanks
    christine

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Combine several pivot tables into one (Excel 2003 / SP1)

    I think it would help if you posted an example of the 2 sources and what you want the results to look like.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Combine several pivot tables into one (Excel 2003 / SP1)

    The highlighted yellow section is the totaled area. Those are the combo tables that I'm looking for.
    thanks
    christine

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combine several pivot tables into one (Excel 2003 / SP1)

    Steve asked if you could post the source data.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Combine several pivot tables into one (Excel 2003 / SP1)

    If you want to just combine the 2 pivots you just need to set the 2 pivot table ranges as the consolidation ranges

    For the first table the 2 consol ranges are:
    Sheet1!$A$9:$B$10
    Sheet1!$D$9:$E$10

    Make sure you uncheck under options "Grand totals for row" then the pivot wil be like the output in G/H

    The second is done similarly with the ranges:
    Sheet1!$A$22:$B$25
    Sheet1!$D$22:$E$24

    Am I missing something?

    If you want something based on the "raw data" I would have to see how they are setup to give any suggestions.
    Steve

Posting Permissions

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