Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables..how to change multiple information in rows ...
HI - I want to change Sum of... to Average (example) but I want to change it
in multile fields all at the same time --- can this be done? Thanks, BJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables..how to change multiple information in rows ...
There's no manual setting that lets you change all the data fields at
the same time. You could make the change with a macro though. There's a free add-in here that lets you change them all to Average (or any of the other functions): http://www.contextures.com/xlPivotAddIn.html BJ wrote: HI - I want to change Sum of... to Average (example) but I want to change it in multile fields all at the same time --- can this be done? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Pivot Table Row Value on Multiple Tables | Excel Discussion (Misc queries) | |||
pivot tables using same heading to show multiple data information | Charts and Charting in Excel | |||
Change Multiple Page Fields in two independent Pivot Tables | Excel Worksheet Functions | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |