Remove zeros from a Pivot table

Hi,

I have a data set of sales results that may show for some customers zero for the month. When I put this data set into a Pivottable, it lists all the customers including those with zero as the value, just as $0.00. Is there some way in a Pivottable I can exclude any lines that have zero as the value in the selection made?

Cheers
Bill

A quick example would let us give you a quick answer. On first thought I'd filter out the customers that had zero. I'd have to see your table to be sure that would work.