Forum Discussion
Sort non unique values by another column
Dear all, I have a table of this kind: ID Name FamilyID SortingNumber 1 Robert 1 101 2 Mary 1 102 3 Paul ...
Ok, but I was hoping thare was a trick...
For example sort (unique) ID by SortingNumber but "display" Name instead of ID.
pimo Here's a trick I've found works (and for the benefit of anyone else ending up here with the same problem):
Add a new calculated column:
NameExtended = [Name] & REPT(" ",[Sorting Number])
Set the sort order of this column to your Sorting Number column and use it, rather than [Name], in your slicers.
The spaces added to the end of the name won't show in the slicer, but they effectively make each name instance unique.
Job done!