Pivot pulling Multiple tabs

  • Thread starter Thread starter terri
  • Start date Start date
T

terri

I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs are:

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.
 
Hi,

That is not what the multiple consolidation command is all about
unfortunately. You need to either put all the data into one data area, or
use a complex pivot table operation call UNION query.
 
what is the multiple consolidation command for?

ShaneDevenshire said:
Hi,

That is not what the multiple consolidation command is all about
unfortunately. You need to either put all the data into one data area, or
use a complex pivot table operation call UNION query.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot from multiple sheets 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Subtotal based on a range of data in Pivot Table 5
Pivot tables, IF statements, vlookups? 2
Combine Pivot tables - confused about 'how-to' 7
Getpivotdata references have stopped loading pivot-refreshed value 1
Filtering data from a pivot table to a graph 1
Pivot table from CSV data, problem with percentage of total. 1

Back
Top