Skip to Content

How to resolve Sorting Issue with Blank values?

Nov 08, 2017 at 02:49 PM


avatar image

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?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks, Amit..

It worked... :)