Need Help with multiple Value Filter or Advanced Filter

[powerpivotlegal]

Hello,

I have a data set that is updated weekly. Multiple pivot tables/charts are outputted on a separate worksheet showing Top 5 or Top 10 jurisdictions, people, practice groups, etc. with the corresponding fees. The pivot tables/charts are already filtered by one of two main clients. However, when there is not enough data for a client (i.e. there is only 7 timekeepers for a client) then the pivot table/chart will first list the 7 people and then all remaining people who are in the dataset that comprises both clients, but with a value of zero. Effectively, it makes all remaining people tied at zero part of the top 10.

How can I make the value filter actually limit the results to no more than Top 5 or Top 10 with values greater than zero?

Thanks.