View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Wheeler
 
Posts: n/a
Default Suppressing zero value for calculated items

Hi, has anyone figured out how to suppress zero results for calculated items
in a pivot? I have tried to use an "IF zero then NULL" formula but this does
not work - I assume item calculations do not allow the use of standard Excel
function?

Thanks

Tim