| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Pivot Table
Hi all,
I have a pivot table where I created a calculated field that averages three of the fields in the pivot table. My problem is that it averages the "blank" (which are created from blank fields in the source data) fields instead of ignoring them. How can I average the fields in a Pivot Table and not include the blanks in the average? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Export Pivot Table Data to Excel Table | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
![Jeff[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
