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