Skip to Content

SAP WebIntelligence data sort by measure and a specific value of a dimension


I have a sorting requirement in SAP WebIntelligence 4.1 SP7 on a crosstab based on a BEx Query.

The crosstab consists on dimension A in the columns, dimension B in the rows and one measure to show.

I want to know if there is a way to do a descending sorting based on the third value of the dimension A, to get the data ordered from this:


To this:


Any suggestion for sorting on multiple dimensions in WebI report for measure value?

Thank you,


order1.png (9.5 kB)
order2.png (9.4 kB)
order1.png (9.5 kB)
order2.png (9.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Posted on Sep 23, 2019 at 09:46 AM

    Create a variable to capture all values of third column.You can put all conditions in where clause.

    Add the newly created variable in the column.Sort the values based on the variable and right click and hide.

    Add comment
    10|10000 characters needed characters exceeded