hi all

I have 2 sets of data that i want to bring together in one pivot table.

Some of the data is compatible, i would like to create one pivot table the user can use.

Can you merge two pivots together, or would you have to do lookups etc on data first before you create one pivot table?

Can anyone help me with this?

Thanks
Cd