pivot table multiple consolidation ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I create a pivot table based on data from one excel worksheet, the pivot
table automatically creates one layout field for every column header on the
worksheet; but when I choose the multiple consolidation option and add two
consolidation ranges to my pivot table data, the layout shows only a field
named "Rows" and one named "Columns" - in other words, it doesn't create
fields named after the column headers that I can drag into the respective
pivot layout areas (page, column, row, data).

The column headers in both of the worksheets (consolidation ranges) are
exactly the same, and the datatypes in the respective columns are also
exactly the same in both worksheets.

What am I missing?

Thanks for your help ...

Bill
 
You aren't missing anything -- that's a limitation of Pivot Tables
created from multiple consolidation ranges. There's an example here:

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

If possible, store your data in a database, or on one worksheet, and
you'll have more flexibility in creating the pivot table.
 
Debra,

Thanks for the clarification. I could have spent a long time trying to
figure that one out!

Bill
 
Back
Top