Skip to Content
Former Member
May 10, 2010 at 12:54 PM

sort by result rows


hi all

In my query I got several chars: Organization, Planning Level, Date

And 3 key figures: Planned amount, Actual Amount, Plan/Actual (calculated KF)

My query got results by Organization on Plan/Actual KF (totals are averages).

Now I need to sort up all Organizations by Planning accuracy, in other words I need to sort query results by Plan/Actual KF totals based on Organization Level.

I created Condition TOP 100 % on Plan/Actual KFG with setting "Individual Chars and Char combinations" and assigning Organziation. But it seems it doesn't work.

How can I make this work?