Hi,
I have a Group Called "Products", I report List of Top 20 Products based on the "count of claims", but If count of claims have ties then sort Product List on "Paid Amount"
Here is the sample of what I got after sorting initially
Product Paid Amount Count
A $100 10
B $150 5
C $100 5
D $ 200 5
How to get these re-arranged to below
Product Paid Amount Count
A $100 10
D $200 5
B $150 5
C $100 5
Do anyone have an idea?