pivot table format change
 

I have a pivot table that is pulling data from several worksheets and can get
everything set like I like, but have one problem. One column needs to be a
running count and all the other columns need to be averaged. I can not figure
out a way to change just the one column or if its even possible.

When you create a pivot table from multiple consolidation ranges, all
columns use the same summary function. You could create another pivot
table based on the first one, and show the average there.

mhutch71 wrote:
I have a pivot table that is pulling data from several worksheets and can get
everything set like I like, but have one problem. One column needs to be a
running count and all the other columns need to be averaged. I can not figure
out a way to change just the one column or if its even possible.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html