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