Pivot table- multi page problem

[jonik95b]

Hello and thanks for reading this

I have a pivot table made with 93,000 lines over 2 sheets. (Excel 2010)
The pivot table works EXCEPT in the “choose fields to add to report” section the individual columns are not listed.

The only options are “rows, column, and value”.
This creates the problem I am having. In the value section of the pivot table field list I cannot change individual attributes. So I can have the sum, or count but I have to have the same option for all columns. I can’t have an average in one, and a sum in the next.

When I created a pivot table for just 1 sheet all worked well.


Thanks for any help you can provide

Jon

[Izandol]

This is limitation of pivot table made from consolidation ranges. May you not combine the data into one sheet?