BEX sorting one key figure ascending and other key figure descending

[Former Member]

HI Experts,

I have a requirement to to sort one key figure in ascending and other keyfigure descending.

I have tried Condition Top 100% and Bottom 100%.

But the both key figures are either both getting sorted in ascending or both are getting sorted descending.

But i need one key figure to be ascending and other to be sorted descending.

Please advice.

Thanks,

Balaji.

[Former Member]

Hi,

two conditions on multiple key figures wont work properly, try with characteristics assignments

[Former Member]

Hi Jyothi,

I tried characteristics assignments also before with the same key figures and other related characteristics, but didnt work. Have to figure out the way.

Thanks,

Balaji.

[cornelia_lezoch]

Hi Balaji,

the requirement is contradictory.

You can not sort data records by two different key figures id different ways. It is just not possible.

Give us an example, what your values look like, maybe it makes sense to add a calculated key figure and sort by this on.

regards

Cornelia