Column sort order based on unique key as attribute to another column value to allow for multiple duplicate values in a dimension

[aaron_berman1]

today, to sort one column based on another, all values must be unique. However, bringing in text dimensions from large databases often have unique keys, but duplicate values that are not necessarily the same. We need the ability to sort these "duplicate values" based on their unique key as we do not want to add key values to the visuals.