Pivot Table - More than 1 Data Source

[kentk]

Can a pivot table have more than one data source?

I have a database with both open and closed jobs... I'd like to move the closed jobs to anohter worksheet to keep things clean. I need to analyze both open and closed jobs together and use a pivot table for this analysis.

 

[Dan Waterloo]

In Step 1 of the Pivot Table Wizard there is the option to pick multiple consolidation ranges as the source for the pivot table. I haven't actually used this feature, but you could read up on it.

However, I would recommend against splitting the data into two groups: open and closed. It's far simpler to keep the data in one large list and then view it (and analyze it) by using pivot tables. One of your Page drop-down lists could be Status (Open or Closed) and you could immediately see all the open jobs or all of the closed jobs.