| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculated fields - change field settings
Hi!
on a calculated field I've just created, the SUM settings appears by default. As I wish to calculate AVERAGE, how can I change from SUM to AVERAGE? From the context menu of my calculated field column I select FIEL SETTINGS, and a small dialog box opens with several options: SUM, COUNT, AVERAGE, etc. But I can't change/choose none. Is there a way to change from SUM to AVERAGE? Thanks. FN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Calculated Items on Calculated Fields. | Excel Worksheet Functions | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
| Permanent change of Field Settings in Pivot Table | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
| How can I change the default settings for Comment fields in Excel. | Excel Discussion (Misc queries) | |||
Threaded Mode
