Skip to Content

How to resolve Sorting Issue with Blank values?

Hi All,

We have created one table in the webi report. We have several Measures and Dimensions.

Some measures have blank values in it. When I try to sort on that Measure by descending, it first shows blank values and after that Higher to Lower values. But I want blank values below lower values.

I have tried converting the blank value to Zero, but it's not working.

How to do this?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 08, 2017 at 02:53 PM

    add 0 in the measure and then sort.

    =[measure object]+0

    or if you do not want to show 0 in the column and create dimension variable=[measure object]+0

    drag this variable in the report & apply sort.later irght click and hide the column.

    Add comment
    10|10000 characters needed characters exceeded