Multiple Consolidation Ranges in pivot tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve S - 18 Oct 2006 08:03 GMT

I have a workbook with two sheets of about 40,000 rows each, when I try to
use the Multiple Consolidation Ranges option I don't see what is expected in
the field list ie. a list of the column/row names. Instead I get "row column
value".

Reply to this Message

Debra Dalgleish - 18 Oct 2006 22:30 GMT

If you create a Pivot Table from multiple consolidation ranges, as you
discovered, you won't get the same pivot table layout that you'd get
from a single range. There's more information here:

http://www.contextures.com/xlPivot08.html

Perhaps you can store the data in a database, and create the pivot table
from that.

> I have a workbook with two sheets of about 40,000 rows each, when I try to
> use the Multiple Consolidation Ranges option I don't see what is expected in
> the field list ie. a list of the column/row names. Instead I get "row column
> value".

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message