cancel
Showing results for 
Search instead for 
Did you mean: 

How to resolve Sorting Issue with Blank values?

former_member354226
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor

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.

former_member354226
Participant
0 Kudos

Thanks, Amit..

It worked... 🙂

Answers (0)