Handling label of labels and sorting of null dimension values

[ali_hijazi]

Hello
got a pivot table in which the expression groups results under null (something  correct)
Handling label of labels and sorting of null dimension values

now what I want is to display the row with null value at the end (bottom of the chart) and give it a label Not Submitted
I want primarily to display the record at the bottom so that the cumulative percentage is well displayed
I tried several ways but couldn't reach a solution
Kindly advise

[vincent_ardiet_]

Are you creating this dimension in the script? 
If you cannot modify the code, you can try to use coalesce(yourfield,'Not submited') as a dimension.

[ali_hijazi]

Hello Vincent
didn't work
you mean I use the coalesce function in the Dimensions on the chart no?

[vincent_ardiet_]

Yes.
But it depends of your datamodel or the expression your are using. Could you modify the loading script? If this is the case, this is better to replace the NULL value there.

[anat]

Try to handle null values in backend

Else use calculated dimension like 

If(isnull(field) or trim(Len(field)) =0, 'Not Assigned', field) 

[ali_hijazi]

The null values come from the result of the expression used

Which contains a union n the set analysis (count expression)

So part of the result comes under the brackets, and the remaining are classified as nulls

Both approaches suggested above (calculated dimension / coalesce) not working