KNOWLEDGE BASE

Incorrect Sorting While Using Secondary Data Source Filters


Published: 24 Nov 2015
Last Modified Date: 08 Aug 2016

Issue

When you filter a view by a field from a secondary data source, the sorting in your view might appear to be incorrect. 

Environment

Tableau Desktop

Resolution

Option 1

Create a formula similar to: RANK_UNIQUE(SUM([Measure]))

Option 2

Add the field being filtered from the primary data source to the view.

Cause

When filtering on a field from a secondary data source, the data is hidden, rather than filtered out. Because the sort is based on the underlying data in the primary data source, the resulting values in the view appear to sort incorrectly.

Additional Information

For more information, see the example workbook available in the attachment section of this article. 
Did this article resolve the issue?