want to use a lookup rank for sorting without showing rank column

[db042190]

hi i have a parent customer name lookup with a ranking value that i'd like to use for sorting a table visual.    And i think i see how the ellipsis above the visual allows a choice of asc/desc and column sort by.   but i dont want to show the rank on the table after i select it in the data region for the visual.  how can i do that?

[Anonymous · Accepted solution]

Hi @db042190 ,

If your ranking value is a column, you can try this:
In the Table view:
Choose column parent customer name, and select Sort by column:

Then in the table visual, you just put the column parent customer name into it without column Rank and choose Sort by column parent customer name:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[db042190]

for the moment i've made the color of both the rank value and heading white.   would really like something more elegant though.