Displaying 0% as blank in pivot table?
I'm displaying a column as % of row total, and some are showing up as 0%. Can I just make Excel show them as blank? I do NOT want to hide them with filter. I want these data to take space in the pivot table, but with blank rather than with "0%". I couldn't find any solution on Google.
|