Pivot table question

B

Bart Joseph

I have a workbook with multiple worksheets. One for each month of exactly
the same data. I know you can use multiple ranges in a pivot table, but I
am having issues that I can not figure out. The out put has row references
and the field names are across the top.

Any suggestions?

Bart
 
S

Shane Devenshire

Hi,

It's not clear what you want, but here is an idea:

There is a way to do this using a very sophisticated query technique, but
here is a tricky but easy way to do what I think you want:
1. It sounds like you already have creates your pivot table from Multiple
Consolidation Ranges. So on the Pivot table double-click the grand total
cell. This will created a new sheet with a row for each of the original
entries plus an unwanted column with Item numbers.
2. Delete the Item # column
3. Create your pivot table from this data set.
 
Top