I would appreciate any advice on how to prevent rows showing within a pivot that have a summary value of zero.
I realize that I can push the Values summary field up into the Filters section, and then remove the checkbox for zero within the filter.
However, I sometimes have 15 separate summary Value columns; which means I would have to push up 15 fields up into the filter and then going into each one for remove the zero checkbox.
Thank you for any assistance.
Bookmarks