Pivot Table

  • Thread starter Thread starter chrisnelsonusa1
  • Start date Start date
C

chrisnelsonusa1

We run a pivot table based off of data that is broken down by shipments,
the problem we run into when doing this is that the shipment count
exceeds the maximum number of lines in a worksheet so we often have to
create one pivot table per quarter.

We are looking for a way to merge data from two separate worksheets in
the same book into one pivot table. Is this possible?

Chris Nelson
 
We run a pivot table based off of data that is broken down by shipments,
the problem we run into when doing this is that the shipment count
exceeds the maximum number of lines in a worksheet so we often have to
create one pivot table per quarter.

We are looking for a way to merge data from two separate worksheets in
the same book into one pivot table. Is this possible?

Chris Nelson
Click to expand...

Yes, there are several ways to handle this.

Easiest is to base the pivot table on multiple consolidation ranges.

Another method is to not have your database in an Excel worksheet but as a
sseparate text file. You will need to query that file using the text
driver in query.
 
Back
Top