View Single Post
 
Old 11-25-2013, 06:37 PM
New Daddy New Daddy is offline Windows Vista Office 2003
Advanced Beginner
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Question 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.
Reply With Quote