| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to "blank" pivot table calculated fields if result = 0
would tools options view and untick zero values work? -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=520223 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to "blank" pivot table calculated fields if result = 0
Steve .... you are the "man".
This worked perfectly ! Thank you very much, Joe "steven1001" wrote: would tools options view and untick zero values work? -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=520223 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to "blank" pivot table calculated fields if result = 0
s
"Joe" escreveu na mensagem ... Steve .... you are the "man". This worked perfectly ! Thank you very much, Joe "steven1001" wrote: would tools options view and untick zero values work? -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=520223 |
| Reply |
| 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) | |||
Linear Mode
