Skip to Content

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

Hi,

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:

order1.png

To this:

order2.png

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

Thank you,

Regards

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
    Sep 23 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