Create multiple reports based on one pivot table

[centprop]

Hi,

I could use some pivot table help please. I cant figure out how to do this automatically.

I have a pivot table set up which lists customer name, and its committed revenue. I also have a report filter that enables me to choose one of 2 customer types, or all customers.

I want to be able to produce a list of top 10 customers, for each customer type, and for all customers. I can do this manually using a value filter for the row lablels, and subsequently selecting which customer type I want which is set up as a report filter at the top of the page. How can I do this automatically please?

Thanks

Chris