• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Wizard- Create a pivot table from multiple sheets

Well, with such a generic question, it's impossible to give you help.

If you have specific issue while following one of the tutorials/links that come up in the search. Ask and someone will help you.
 
@Shay A

Take a look at the attached example

When creating the pivot table select add to data model and you should end up with a pivot table with two tabs up top (on the field list to the right) one for active and other for all... selecting all gives you all the ranges/tables you added to the data model. For them to work in conjunction, you just need to make sure there is a common field in both (in the example i used Key column to link both tables)
When dropping the fields into the pivot table, as soon as you add fields from both tables, it will prompt you to make the connection (you have an option to do this automatically or manually)

Hope this is somewhat usefull
 

Attachments

Thanks but most of the time I use 2007 version so data model is not an option. Just pivot table from multiple sheets.
Are there any does and donts? Do all of the tables have to be with the same field and thev same structure? All of the sheets hase tobin the form of Excel Table?

Ty
 
You must log in or register to reply here.
Back
Top