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