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

Custom sorting characteristic values in Reports

Hi Experts,

I have a requirement to sort the values of a characteristic in the client's desired way.

In the above report,I have moved the characteristic Analysis Phase to Columns and sorted the characteristic values using Sort By Description in ascending order.

But the client wants the values to be in the ascending order of "%" given along with the value.

That is, they want the values in the following order

Identify opportunity - 10% Analyze Opp. - 30% Present Opp. - 70% Close - 100%

I tried sorting by Description and sorting by ID in both ascending and descending order.But both didn't serve the purpose.

So I was just wondering whether we can do some custom sort,so that the characteristic values come up in the desired order.

Please let me know whether any custom sort is possible or please suggest some work around for it.

Thanks in advance,

Vishnu Prasad

Customsort.png (8.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 15, 2016 at 06:55 AM


    If you have only few Analysis Phases then Just create Restricted Key figures for each Phase ( one for Value and one for Count) and arrange Restricted key figures as per your requirement.



    Add a comment
    10|10000 characters needed characters exceeded

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.