How to show top 20 negative values in a table

[srikanth1994]

Hi Qlik Lerner's,

How to show top 20 negative values in table 

Expression is: 

 if((Sum({<Year={2022},[CM-Calc-1-Revenue]={1}>}ALLOCATED_OPEX_COST) + Sum({<Year={2022},[CM-Calc-1-Costs]={1}>}ALLOCATED_OPEX_COST))<0,Sum({<Year={2022},[CM-Calc-1-Revenue]={1}>}ALLOCATED_OPEX_COST) + Sum({<Year={2022},[CM-Calc-1-Costs]={1}>}ALLOCATED_OPEX_COST))

Dimension is :

PARENT OCN

[Aditya_Chitale]

there's an option under dimensions:

 this will be applied on 1st measure column after dimension columns.

Regards,

aditya