5 Replies Latest reply on May 16, 2018 12:43 PM by Bryce Larsen

    Most recent date an event in a category?

    Alexander Chelminsky

      Hello, I'm trying to find out the most recent date event occurred:

       

      I have a number of categories (say, types of clothing) and want to know the date of the most recent sale of a particular item:

       

      Say:

       

      Item     Cost          Sale Date

      Shirt     10.0          3/30/2018

      Pants     20.0         4/5/2018

      Shirt     13.0           5/11/2018

       

      I need a Calculated field that will return the date for the most recent sale of a shirt (5/11/2018)

       

      Any suggestions?