Skip to Content
0
Former Member
May 07, 2010 at 04:36 PM

Group Sorting incase of ties

14 Views

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?