HELP: Filter Top 10 Clients into pivot table when there are more than 600,000 rows/clients

Hi,

I have created a pivot table with 3 columns- Client Name, Region, and Credit Amount... The number of rows is over 600,000 as there are over 600,000 clients. I am analyzing clients by volume in a pivot table and would like to retrieve my top 10 or top 50 clients by region (12 regions)... but as I drag the variable into the pivot table, i get an error as there are too many (>600,000). Is there a way that I could use a macro to pre-filter the variable "Client" with the top 10 in the Row Field and create the pivot table that i am looking for?

Any help would be great!!

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?