I have a table of three years of school system salaries that I have made sortable and searchable. Two things I would like to fix/improve:
1) Before the sort function was applied, the list of names didn't show the second or third instance of the same name (because some people changed jobs, they are listed on separate rows), so it was clearer that it was the same person -- such as with Abernathy, Connie D and others in the image below. However, that only works if the name is the first pill on Rows, and putting the name back first breaks the sorting function (its pills seem to need to be listed first, otherwise it doesn't work, at least the way I found to do it). Is there a way to get back this presentation while keeping the sorting function? Right now it lists the same name multiple times in the first column.
2) Is there a way when doing a Descending sort on the three salary columns to exclude the fields with NA in the results? That way you would have the highest salary for each year at the top, rather than a massive string of NAs that you have to scroll past to see the actual highest salary? (See example image below sorted for 2015-16.)
I'd appreciate any help! I'm still quite a neophyte at Tableau and was pleased with myself for getting the sorting working, given that sorting is much less straight-forward than one would expect.
I may have posted this too late on Friday for people to see, so I'm going to be exceedingly tacky and bring the post back to the top in hopes of getting some help with this issue. We're trying to make this as user-friendly as possible. Thank you for any help!