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

    Tableau Show Latest Period that has data

    Lian Norliansyah

      Hi,

       

      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:

       

      Wellington.jpg

       

       

      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.