3 Replies Latest reply on Sep 7, 2016 10:44 AM by Doug Stanley

    Selecting the latest filing

    Doug Stanley

      I've read a lot of posts and blogs and haven't quite been able to solve my problem:

       

      • I have a data set with 45,000 rows.
      • For each entity, there should only be one date recording when a particular report was filed.
      • Because of dirty data, however, a relatively small number of entities show multiple filing dates.
      • Here's a snippet:

       

       

      My need: tell Tableau to select only the most recent date for any given entity. I need this calculation to work regardless of level of detail.

       

      I'm able to filter out the unwanted older dates -- but only in limited circumstances -- using this calculation on the filter shelf: Last()=1

       

      Surely there has to be a calculation that will pick the most recent date for each entity, regardless of the level of detail in the pane. Grateful to anyone who can help me out.

       

      Workbook attached.