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!!