KNOWLEDGE BASE

Hiding Only the Blank Column when Using Difference Table Calculation


Published: 04 Feb 2013
Last Modified Date: 20 Jun 2017

Question

How to hide a blank column when using a Percent Difference or Difference table calculation without hiding the other measures in the view.

Environment

Tableau Desktop

Answer

If there is more than one measure or dimension in the view, the blank column cannot be hidden without also hiding all instances of that Dimension value. For example, hiding one Q1 column will hide the Q1 column for all years. Use option 1 below if there is only measure or dimension in the view. Otherwise, use option 2.

Option 1:
  1. Right-click the blank column header.
  2. Select Hide.
Option 2:
 
  1. Select Analysis > Create Calculated Field to create a calculated field.
  2. In the Calculated Field dialog box, type a name and the following formula, and then click OK:
    index()!=1
  3. Drag one copy of the newly created calculated field to Detail on the Marks card and a second copy to the Filters shelf.
  4. In the Filter dialog box, select True, and then click OK.
Did this article resolve the issue?