I have created a bar chart based on the dimension Enrollment Status. There are only 3 values to this dimension. Employee, Spouse and Children. I would like this to be the sort order so I created the formula below in the sort expression box.
Everything works great until the spouse dimension value is null. I can choose show all values in the dimension properties and it shows up at the end of my chart. I have a corresponding straight table that I use as well and I get the same incorrect result. Since children has a covered live, value it is not null. I use covered lives as a first expression in the bar chart, but I am not displaying it.
I have tried using a calculated dimension and I still can't get it to display properly
How can I ALWAYS display all of my dimensions values in the order I want, regardless of nulls.