Pivot table question

  • Thread starter Thread starter Bart Joseph
  • Start date Start date
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
 
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.
 
Back
Top