KNOWLEDGE BASE

How to show the last month of filters in the title


Published: 24 Nov 2022
Last Modified Date: 24 Nov 2022

Question

How to show the last month of filters in the title.

Environment

  • Tableau Desktop

Answer

1. Create a calculated field name it [show_MAXmonth_selection]
IF  LAST()=0 THEN MAX(MONTH([Order Date])) END
2. Drag the field to the detail card.
3. Double-click the title to edit the title.
4. Insert the field below into the title.

<AGG(show_MAXmonth_selection)>
User-added image

See the attached file.
Did this article resolve the issue?