KNOWLEDGE BASE

Unexpected Grand Total Values when Using Data Blending


Published: 14 Jul 2016
Last Modified Date: 25 Oct 2016

Question

When a calculated field in the primary data source references a field in the secondary data source, the results returned for the column grand totals do not reflect the sum of the values in the column.

Environment

Tableau Desktop

Answer

  1. Create a calculated field similar to the following: 
    If first()=0 then WINDOW_SUM(<Calculated Field that references Field in Secondary Data Source>) END
  2. Drag the linking field from the secondary data source to Details on the Marks card.
  3. Put the new calculated field on the view, replacing the original field.
  4. Right-click the calculated field and select Edit Table Calculation. 
  5. Select Compute Using: Specific Dimensions, select the linking field from the secondary data source, then click OK. 
  6. Select Analysis > Mark Stacking > Off.
Note: In 9.3 and earlier versions, substitute the following for step 5: 
  1. Select Compute Using: Advanced... 
    In the Advanced dialog box, choose Addressing: <Linking field from secondary data source>, then click OK. 

Note: The calculation must be created in the primary data source, referencing a field in the secondary data source.
Did this article resolve the issue?