Hi Bernie,

Thanks for the recommendation... the only problem is that I extract the data from a database directly (not excel) and form the pivot table. I need this "master pivot table" to do other things which is why i dont pre-filter it in the database. Is there a macro that I can do which will pre-arrange my pivot table to filterthe Row Field with the Top 10 Clients?

example: I can manually filter the Row Field by selecting the filter... and ask for the top 10 Clients when there are few clients in the database.

I would like to replicate this pre-filtered pivot table using a macro when there are many clients. Do you think it is possible?