| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields in Pivot Tables
I have just used the Calculated Field function in a Pivot Table in
order to give me the value of one field divided by another field. Although I have the new Calculated Field in my Pivot Table it assumes that I want the Sum of this field, but I actually want the Average instead... How can I get averages instead of sums? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
| Calculated fields in pivot tables | Excel Worksheet Functions | |||
| Pivot tables - calculated fields | Excel Worksheet Functions | |||
| pivot tables - calculated fields | Excel Worksheet Functions | |||
| Pivot Tables, calculated fields | Excel Discussion (Misc queries) | |||
Threaded Mode
