Hi

When you insert a pivot table tick the box to add it to the Data Model. In the pivot table field list chose all. This will make all your tables available. You will need to link these tables by a unique (Primary) field. It is like a database with a one to many relationship.

Look under the Analyse tab and you will see relationships. This is where you link the fields.

Eg. if you have a job number list, the job number is a unique number. Many people will work on any of these jobs so the primary field is the job number in the job number list and the linked job number is in the workers list.

I hope this helps.

TabH