on 11-08-2017 2:49 PM
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 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.