Sorting Null Values in a Chart

[#1]

See the attached document for an example.

In my example I have a chart where the first dimension is null in one case.  When sorting by Dim1 the values sort in alphabetical order, but the null value is always at the bottom.

Is there a way I can get rows that have a null Dim1 to sort to the top on a certain order?  It needs to be one of ascending or descending, but which one doesn't matter.

Thanks!

[Anonymous · Accepted solution]

Ken,

You can replace null with something else.  For example, use calculated dimension instead of Dim1

if(isnull(Dim1), 'null', Dim1)

Regards,

Michael

[#3]

This seems to work perfectly.  Not sure why I didn't come up with that!  Thanks!