Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format in pivot table | Excel Discussion (Misc queries) | |||
Pivot table help | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel | |||
How Do You Permanently Format Fields of a Pivot Table? | Excel Discussion (Misc queries) |