KNOWLEDGE BASE

Aggregation Result is Different When Change [Only This Worksheet] Filter From Secondary Data Source Field to [All Using Related Data Sources]


Published: 04 Jun 2020
Last Modified Date: 05 Jun 2020

Issue

Aggregation Result is Different When Change [Only This Worksheet] Filter From Secondary Data Source Field to [All Using Related Data Sources]

User-added image

User-added image

Environment

  • Tableau Desktop

Resolution

Use Data Join or Relationship instead of Data Blend

Cause

Some values in primary data source field are not in related secondary data source field (using as filter).
When [Only This Worksheet] option is selected, those values are displayed as NULL in filter, but when [All Using Related Data Sources] option is used, only items in secondary data source field are displayed.
Did this article resolve the issue?