1 Reply Latest reply on Oct 7, 2016 4:28 AM by praveen p

    Tableau Show Latest Period that has data

    Lian Norliansyah



      I would like to create a report to show period which has data.

      I can use { max([Order Date])} to find the latest month in the data set.

      It works if I want to display the report for ALL cities.

      However, when I filter data on selected city, it does not work.


      Here is how the data looks like:


      Show latest month data.jpg

      If Wellington is selected. As the latest data exists in the column in Feb 2015, it should display as follow:





      When Wellington is not selected, it should display Jan 2015 only


      No Wellington.jpg


      How can I achieve that?


      I attached a workbook I use to test the result, any helps would be appreciated.