+ Reply to Thread
Results 1 to 3 of 3

Consolidating data in one Pivot Table.

  1. #1
    Registered User
    Join Date
    06-15-2009
    Location
    Queretaro, Mexico
    MS-Off Ver
    Excel 2003
    Posts
    19

    Question Consolidating data in one Pivot Table.

    Hi everyone, I’m new to the whole pivot tables and have so far fallen in love with their usefulness however I’m trying to figure out a way to visualize loads of information from different files (each customer has one file, and there are 30) in one Pivot Table. The issue is that, even if the information is presented in the same style, the columns fields are not always the same.

    Ultimately the goal if to be able to set one pivot which uses the “page” field as a filter to view the information from each different customer. I know this might be a bit confusing so I’m attaching a file for you guys to take a look and give me your thoughts on it. I mean, is it even possible or will I have to create 30 different Pivot tables. Additionally is there a way to have several Pivots in a file and use a filtering device to view one at a time?

    Thank you all for your time, any help will be extremely appreciated…

    Cheers,
    Kianuz
    Attached Files Attached Files

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Consolidating data in one Pivot Table.

    Hi,

    Take a look at this link on Pivot Tables it may help?

    http://www.datapigtechnologies.com/ExcelMain.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    06-15-2009
    Location
    Queretaro, Mexico
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Consolidating data in one Pivot Table.

    Thnx for the response oldchippy, but I'm afraid I went through all the tutorials (and actually learned a few things) but found nothing referring to what I'm looking for.

    As a matter of fact I've been trying to use the tools I found under "All about Multiple Consolidated Ranges" in the link you posted and I've made some progress. However I'm still facing the problem that Excel only takes the first column on the left as a Row field, and every other one as Data. If I could change that I'd bee done.

    In other words, the first three columns in my files are meant to classify the information, hence they should be set in "Row" not as part of "Data"...Any ideas?
    Last edited by Kianuz; 10-23-2009 at 12:00 PM. Reason: info update

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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