Yes -- it's not the most obvious though. And there may be other ways, but this is how I was able to get it to work. The basic idea is to get a field that is limited in granularity to the month / year level without having Tableau define the filter as MY(field) because that won't use or allow any kind of custom sorting.
1. Right click the date field in the Dimensions window and select "Create Custom Date..."
2. Select "Months" (not Month/Year) and make sure "Date Value" (not Date Part) is selected. When you click OK, a new custom date field is created.
3. Right click the new field (default name: "Date (Months)") and select "Default Properties" --> "Sort".
4. Change the sort to descending.
5. Add the new field to the Filters shelf and select "Individual Dates".
6. Right click the field on the Filters shelf and select "Show Quick Filter".
Hope that works for you!
Thank you Joshua. This is what I am looking for.
Great! Glad it worked!
It works as expected. But when I applied condition to show TOP 1 (MAX DATE), data is not showing. It meant condition is not working here. Could you please help me?
- New Field=>Top tab
- Checked By Field
- Top 1 by
- Date field, Maximum
It is working.. Sorry..