Skip to Content
author's profile photo Former Member
Former Member

Sorting by Characteristic Result Rows

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2008 at 07:11 AM


    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.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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 😔

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.