KNOWLEDGE BASE

Filtering Multiple Measure Across Different Dates


Published: 04 Apr 2014
Last Modified Date: 30 Aug 2016

Question

How to filter multiple measures in a single view across different dates.

Environment

Tableau Desktop

Answer

Create a non-aggregate calculated field with a conditional test on the date for each individual measure.

For an example of a non-aggregate calculated field:
  1. Select Analysis > Create Calculated Field to create a calculated field.
  2. In the Calculated Field dialog box that opens, type a name for the field.
  3. Type the following into the Formula field, and then click OK: IF [Date] = 2014 THEN [Sales] END
Did this article resolve the issue?