Skip to Content

Sort on multiple columns in WebI report for measure values

Hi,

Any suggestion for sorting on multiple columns in WebI report for measure values.

I should get column values from highest level to lowest level.

I tried all the blogs ,I need to use without using input control.

https://archive.sap.com/discussions/thread/1989324 https://blogs.sap.com/2016/06/13/sorting-data-dynamically-in-a-webi-report/ https://blogs.sap.com/2013/09/27/bi-directional-sorting-in-webi/

Regards,

NK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 17, 2017 at 03:40 PM

    Hi NK,

    You can start the sorting from priority basis which means select each column one by one and apply the sorting according your requirements .

    Please see the below link.

    https://www.tutorialspoint.com/sap_webi/sap_webi_sorts.htm

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2017 at 02:35 PM

    Can you specify your problem, please ?

    Add comment
    10|10000 characters needed characters exceeded

    • hi,

      sorting will always be applied even when data is changing so if you refresh the report, sorting will arrange the data like you have defined it. Note that you have to check the sorting sequence.

      in the screenshot you see that first the extended price descending will be set, then category ascending.

      If you want to swap for instance between ascending/descending dynamically after refresh of your data, you will need to implement something extra, like the blogs you saw, there is no standard feature doing something like that.

      Other way to handle it is to give the users more rights (to change report sorting like a developer) but unable other rights, but this can get complicated

      capture.png (9.0 kB)