Hello,

How can I tell PowerPivot to make a Pivot Table from 5 different Excel Worksheets. I've added them all into the data model but I'm having a problem joining them. I even created a unique ID for each record but to no avail. I'm trying to make 1 big pivot table from all this data. Please help.

Thanks,