Thread: Piviot calculated sum - Hide all but zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
  
Posts: 287
Default Piviot calculated sum - Hide all but zero
I am working with a formula in a Pivot Table

It is suppose to display only the 0 value of the calculated sum

=IF(('Week 1'+'Week 2')=0,"visible","hidden")

what I get is this " #VALUE! "


Any suggestions...
Reply With QuoteReply With Quote