Separate Identical Dimension Values

Published: 09 Oct 2018
Last Modified Date: 20 Jan 2019


How to separate two identical dimensions members; for example if two customers have the same name.


  • Tableau Desktop


To sort each customer with the same name independently:
  1. Include another field in the view that has a unique value. For example, include the Customer ID.
  2. Add the sort on the field with unique values, which is [Customer ID] in this example. It may also be necessary to move [Customer ID] to the first position on the shelf.
  3. Note, if [Customer ID] should not show in the view, right-click [Customer ID] and uncheck Show Header.
Did this article resolve the issue?