Hi,

I have a pivot table created with 750 company names and the items numbers of the purchases these companies have made. The pivot table shows me the totals of all items purchased by each company.

What I am trying to do:

I would like a way to pull the top 25 customers based on the amount spent into another excel sheet.
I am trying to show the top 25 companies which spent the most, the item numbers of all of their purchases and the total amount spent.

I am using excel 2007. Is there an easy way to do this?