View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wacNTN wacNTN is offline
external usenet poster
 
Posts: 8
Default Not display rows where grand total is 0

I have pivottables that have rows where the grand total is 0. I want to
hide these rows automatically but I can't figure out how to filter them out.
I would even settle for sorting on grand total but that one alludes me too.

Any help will be appreciated!

Walter
--
WAC