Currently I copy the total into the header section and deselect zero. I'm always thinking there has to be an easy way to just show no zeros.
i.e.
Salesmen Sales $
Bill 100
Bob 0
Charlie 150
Is there a way not to have Bob show up in the pivot?
Thanks
Bookmarks