KNOWLEDGE BASE

Separate Identical Dimension Values


Published: 09 Oct 2018
Last Modified Date: 01 Nov 2018

Question

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

Environment

  • Tableau Desktop

Answer

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?