When i change from 10 to 20, the top 10 value changes.
for example when i have the condition <=10 the values are
700
650
....
when I change it to <=20 it changes to
800
799
... etc
which should have been the case with my top 10 itself. Can't understand this behaviour.
This is my expression.
=if(aggr(rank(fabs(aggr(sum({<iss_crr={'EUR'}, fld1={'xx'}, fld3-={'cc1'}>} val1), ac_dec))),ac_dec)<=10, ac_dec)
Want to take the ac_dec with the top 10 values for the absolute sum of values of field 'val1' per ac_dec grouping. This is what i want to achieve.
Thanks
Ram
