Implement IFERROR formula for data in Pivot Table?

[Jyggalag]

Hi all,

I have this data sheet:

I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry).

But I have #DIV/0! errors!

Is there a way in which I can implement an IFERROR formula for my entire pivot table that converts these cells to blank cells (without the blank cells impacting the top sum value, because it might think that blank cell = value of 0)?

Thank you!

please ask me for elaboration if you need

BR.
Jyggalag

 

[arthurbr]

Lots of answers on the Web How to Remove Errors in Your Pivot Tables + Video - Excel Campus