I have a field called 'Unknown' and I would like it to appear at the end when I am ranking the other fields in the table.
For example, there are 10 types of car manufacturers that I would like to ran as top 5 based on their sales and I have an unknown among them. I want the 'Unknown' to always appear at the 5th or the 6th position.
Re: Always display a value at the end of the ranking
Say a data load like below:
INLINE [Manufacturer Sales
I want to rank them. I don't want to include the unknown in the ranking because it is just a wildcard name for the manufacturers I don't know the name for. But, I want to display it as the last in my top_5 ranking. Is it clearer now?