Trouble with sorting Pivot Table with more than one Measures (Column)

[seidydelacruz]

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.

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