Need bottom 20 results

[MIKIEMILLER]

I have an expression:

Sum([Net Cash])

I need to only show the lowest 20 results of this expression in a table based on the dimension [ID].  I tried this expression, but it brought in the lowest 20 IDs.  I want it to sort by ID based on the 20 lowest Net Cash values.

if(aggr(rank(Sum([Net Cash])),[ID])<=20,[ID])

[sunny_talwar]

May be try this

Aggr(If(Rank(-Sum([Net Cash])) < 21, [ID]), [ID])

[MIKIEMILLER]

Thanks Sunny but that still shows the value as the ID # not the Net Cash Value

[sunny_talwar]

May be try this

Aggr(If(Rank(-Sum([Net Cash])) < 21, Sum([Net Cash])), [ID])

[isingh30]

May be this -

= only({<Net < {439}>}ID)

OR

= IF(Net < 439,'ID','Net')

[MIKIEMILLER]

Ishtdeep,

Thanks for the reply, but the data is always going to be updated.  So those values are only good as of today.  Tomorrow they will change.

[MIKIEMILLER]

Sunny,

Both expressions are giving me null answers when in actuality there sum(net cash)  is on the right.

[sunny_talwar]

Would you be able to attach your qvf file?

[MIKIEMILLER]

Unfortunately I cannot.

[sunny_talwar]

Mocked up data to show the issue?