Last Modified Date: 08 Aug 2016
Option 1Create a formula similar to: RANK_UNIQUE(SUM([Measure]))
Option 2Add the field being filtered from the primary data source to the view.
CauseWhen 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 InformationFor more information, see the example workbook available in the attachment section of this article.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials