I am trying to view members that have expired, and I can pull them up in one big group using CNTD. The problem is that our members may have had an expiration in March 2012, then renewed and expired again in January 2013, so when I start looking at the dates of the expirations they are showing up multiple times. How do I make Tableau show me only the LAST expiration date the customer had?
make a calculation filed in which take index() function and then put into the filter then select the bottom 1.
another method I've used Index & Last functions which functions based upon largest and lowest values