Exclude zeros in a pivot top 10

I have a pivot grabbing the top 5 deals by dollar value. The problem is, if there are only 2 deals with an actual $ value and a binch of others, 20 of them, with zero dollar value, the sort will pull those top 2 as well as the other 20.

Is there a way to exclude anything with a zero value so my top 5 will show only those 2 deals if the rest are zero? I can't see this option anywhere.

Your help is appreciated!

untick '0' in the pivot field drop down?

HTH

Unfortunately my pivot isn't set up that way, it is summarizing a few lines for the same customer into one so I can't choose the dollar amounts to display or not.

I should also say, that no matter what the number are, I only want to show 5 at all times. So it'll happen that say the 5th largest is the same for 10 customers, the pivot will show those 10 along with the 4 higher, so it's more of a top 14.

I'm really, sorry, I can't imagine a pivot table with a top 10 autoshow where parameters can't be unselected. Could you post an example?