Pivot tables - cannot suppress No Value results

[TheSincereyo]

Hello,

I have a large pivot report and with calculated items.
The values of the calculated items go in the columns section.
If I have one row this works well.
But when I add additional rows the No Data cells appear and I cannot suppress them.
I cannot access the "Show items with no data on rows" and "Show items with no data on columns" on the Pivot Table Options>Display tab - they are grayed out; they are also unselected.
Additionally, I cannot access the "Display item labels when no fields are in the values area" box - this is also grayed out but selected.
I've also tried by unselecting the show empty cells-but this also does not work.

Any advice on how to remove these fields would be great.

Not sure if this matters - I'm using Excel 2013.

Thanks!

 

[AFPathfinder]

The formula is showing an error on the additional rows? If so, you want the whole field to be removed when errors are present?

 

[TheSincereyo]

There are just blank rows where data doesn't exist. But the calculated item shows zero because it's just null - null. I tried to adjust the calculated item formula and got an error for that and the grand and sub totals. I cannot suppress the errors either.