Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table
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 -- chrisnelsonusa1 ------------------------------------------------------------------------ chrisnelsonusa1's Profile: http://www.excelforum.com/member.php...o&userid=29526 View this thread: http://www.excelforum.com/showthread...hreadid=557902 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table
On Mon, 03 Jul 2006 14:12:14 -0500, chrisnelsonusa1 wrote:
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |