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...
 
Back
Top