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
Hi,
Take a look at this link on Pivot Tables it may help?
http://www.datapigtechnologies.com/ExcelMain.htm
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
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 01:00 PM. Reason: info update
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks