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!