Dear Qlik experts,
I’ve this Pivot table sorting fine in descending order with one measure, however when I add another measure it really doesn’t sort accurately in order.
![one measure sorting works.png one measure sorting works.png](https://community.qlik.com/t5/image/serverpage/image-id/20645i3C7EA630ED0897E8/image-size/medium?v=v2&px=400)
![two measures sorting doesnt work.png two measures sorting doesnt work.png](https://community.qlik.com/t5/image/serverpage/image-id/20646iC8611ECF3DCE3FC2/image-size/large?v=v2&px=999)
Settings for sorting :
Prev. Carrier (Ascending)/ Sort by expression: Rank(sum( if(match(product_name, 'DBL'),1,0) ) - sum({<DateType={'FC'}> } canpol_dbl))
DBL Ben. Lev.: Sort numerically - Ascending
Broker ID (Desc)/ Sort by expression: Rank(sum( if(match(product_name, 'DBL'),1,0) ) - sum({<DateType={'FC'}> } canpol_dbl))
Group Size: Sort numerically - Ascending
I sincerely appreciate your effort, time and assistance.
Thanks & regards,
Seidy