Help with Rank Expression

[antoniodneto]

Hey Guys,

Could you help me?

I'm trying to create a table with some variables.

Dimensions:  COD, GRUPO,VA,SIT. Measure: RISCO

I want to show the TOP 10, so I created a new Dimension 

[COD]&[GRUPO]&[VA]&[SIT] AS [SORTDIM]; and my expression on table is =Sum({$<SORTDIM= {"=Rank(Sum(RISCO))<=10"}>} RISCO) it works but I need do add some modifiers where SIT is all values except NOP and CART_90 > 0.

So I created my expression =Sum({$<SORTDIM= {"=Rank(Sum(RISCO_TOTAL))<=10"},SIT_CLI_SCAN_MES_REF-={'DNP'},CART_ATRASO_MAIOR_90-={0}>} RISCO_TOTAL) but didn't work.

Any ideas to solve?

Tks a lot!

[Channa · Accepted solution]

=Sum({$<SORTDIM= {"=Rank(SIT_CLI_SCAN_MES_REF-={'DNP'},CART_ATRASO_MAIOR_90-={0}>})<10")RISCO_TOTAL))

basically rank after conditions

[antoniodneto]

Tks Channa!! Now is working!!