Have pivot table show blanks instead of 'empty'

Question & Answer
1

I have a pivot table for which many of my fields have no data. Currently, in the fields that have no data the pivot table displays “empty”.

Is there a way to have the pivot table display “” instead of “empty” where there is no data?

2

You would need to make a calculated field for each.

ifelse({field}=''," ",{field})