Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Ken,
You can replace null with something else. For example, use calculated dimension instead of Dim1
if(isnull(Dim1), 'null', Dim1)
Regards,
Michael
Ken,
You can replace null with something else. For example, use calculated dimension instead of Dim1
if(isnull(Dim1), 'null', Dim1)
Regards,
Michael
This seems to work perfectly. Not sure why I didn't come up with that! Thanks!