Sorting by Characteristic Result Rows

[Former Member]

in my query I got 3 characteristics and 3 key figures. Is it possible to sort kfg by RESULT ROWS of one of the characteristics?

Edited by: Gediminas Berzanskis on Aug 6, 2008 8:45 AM

[Former Member]

Hi,

Try this:

make a Top N condition on the key figure, using the characteristic that is 1 level higher than the characteristic you want the result rows sorted in.

Udo

[Former Member]

But what should I do if characteristic I want to sort is in the highest level?

[Former Member]

Hmmm, ...

The characteristic of the highest level has only 1 result row (grand total)?

So that seems easy to sort.

And the next level is again the condition assignment on the first column / charactersitic of your report.

(I just tried it myself and it seems to work)

Udo

[Former Member]

I guess u didn't understand me.

I got three characteristics in my query:

1. Organization

2. Date

3. Planning Level

And three key figures

1. Planned amount

2. Actual amount

3. Deviation % (Actual/Planned) (calculated)

I need to know best planning organizations. So I need sort Organization by

Also I need Date and planning Level characteristics involved in query, because they taken in Deviation formula.

So, then I use condition (Top 100%) by Organization the query doesn't sort Organisations by Deviation properly