Top 10 List w/ Multiple Criterias

[Vasweetheart05]

Hello.

I'm hoping to create an automated Top 10 list that will allow users to select "multiple" metrics to base the Top 10 results on. I'm familiar with the Top 10 using ONE pivot criteria but I need to use more criteria. For Example..

Let's say I have three currency field which I'd like the Top 10 to be based on. 1. Current Dollar. 2. Prior Dollar 3. Change Dollar

In addition to this, the data will display different metrics based on the the top 10 selections. So those metrics would be show Company Name, Company Date, Company Product, Company Type, and Company Product. An additional step would be that the user can also filter on Company Type or Company Product which will also impact the Top 10.

Is there any particular coding that I could create this with? I understand I'm limited with Pivots so that's not an option.

Any ideas?

Please let me know if i can do anything to explain this better...

Thank you