T Tim May 16, 2005 #1 Hi I can not find how to hide 0 fields in pivot table in office 2003. thanks tim
P Peo Sjoblom May 16, 2005 #2 You can hide blank values but not zero values (at least not built in the pivot table options), you can hide all zero values under tools>options>view and uncheck zero values. Debra Dalgleish has posted code for hiding zero fields http://tinyurl.com/ca7gr
You can hide blank values but not zero values (at least not built in the pivot table options), you can hide all zero values under tools>options>view and uncheck zero values. Debra Dalgleish has posted code for hiding zero fields http://tinyurl.com/ca7gr
