Thanks for your reply but I'm sorry to report that doesn't work.
My rows do not contain values.
The only value is in the sum values area.

I even tried to make my values a row and filter on that. But that doesn't
work because it is not the detail I want to hide it is the subtotal.

In other words I may have 15 lines of detail in the sum value area for one
customer number that are both positive and negative but the subtotal is zero.
I want to hide all of it if the subtotal is zero.

Any other ideas would be appreciated.


Shane Devenshire wrote:
Hi,

Open a filter in the Row Labels area and choose Value Filters, Does Not
Equal and enter 0. See if that does what you want.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1