| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to "blank" pivot table calculated fields if result = 0
I have a pivot table that works wonderful.
However I have three calculated fields in the data area of the pivot table. If those calculated fields have nothing to calculate they return 0. Is there a way to "blank" all those unnessary zeroes when obviously there is no dependent data to calculate. I've got the setting correct to show " " when the dependent data is blank. I'm just stuck on the calculated fields. Thank you in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Fields in Pivot | Excel Discussion (Misc queries) | |||
| Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
