cannot rank on sum

[former_member1054754]

Hi, I have figures per product, which I have summarized by product code. Now  I want to rank the list based on the sum of each product code. I can only rank the product code.

Many thanks.

[former_member205840 · Accepted solution]

Hi Henriette,

Create a group on product code and insert summary, now go in Reports -- Group sort expert--select All for sort -- select product summary and select Ascending order and click ok.

This will sort  the records based on summary, now drag and drop record number in front of product group to know the ranking.

Thanks,

sastry

[former_member1054754]

Dear Sastry, this has done it! Many thanks.

[Former Member]

Hi,

Please see if below doc can help you.

Regards

Niraj