4 Replies Latest reply on Jul 12, 2018 11:26 PM by Hernan Lee

    Selecting A Value Based On Recent Year

    Hernan Lee

      I'm trying to select a dimension "Country" based on the most recent "Year" so I can use it as text and have it be dynamic. I don't want to use a filter as I don't want other values affected in the sheet.

       

      In SQL it would be:

       

      SELECT Country

      FROM Table

      ORDER BY Year DESC

      LIMIT 1;

       

      How would I go about implementing this as a Calculated Field?

       

      Screen Shot 2018-07-12 at 10.31.38 PM.png