KNOWLEDGE BASE

Showing Grand Totals with Blended Data


Published: 30 Jan 2013
Last Modified Date: 06 Mar 2017

Question

How to show the grand total when using blended data.

Environment

  • Tableau Desktop
  • Data blending

Answer

  1. Select Analysis > Create Calculated Field.
  2. In the Calculated Field dialog box that opens, do the following and then click OK:
    • Name the calculated field.
    • In the formula field, create a calculated field similar to the following:
      IF (first()==0) then window_max(total(sum([<Measure>])), 0, iif(first()==0, last(), 0)) END
  3. Drag the linking field from the primary data source to Level of Detail.
  4. Drag the new created calculated field to the view.
  5. On the view, right-click the calculated field, and then select Compute Using > <linking field>.
Did this article resolve the issue?