ExcelBanter - Piviot calculated sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Piviot calculated sum - Hide all but zero (https://www.excelbanter.com/excel-discussion-misc-queries/219511-piviot-calculated-sum-hide-all-but-zero.html)

Adam

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...

All times are GMT +1. The time now is 04:34 PM.