Hi Guys,
I have a query and i need to sort a keyfigure column in descending order. We are into BW 3.5 Analyzer. I checked in the forum, which suggested to use condition - All Charactersetic Independently with Keyfigure value Top % to 100.
I used that it works while first executing the query. Once i swap the Row with any characterstic in Drilldown or Free characterstic, the condition doesn't work. It only works for characterstics in Rows but not for Free characterstics.
For Free characterstic, I have to uncheck the condition and check it again and then it sorts the column.
Can you please suggest how the condition is valid for all the characterstics regardless whether in Free characterstics or rows.
I also used Query view but it works only initially whicl execution, again by drilldown the condition doesnt work.
Regards