1 Reply Latest reply on Jun 26, 2013 6:58 AM by Brad Llewellyn

    Function to return the 2nd Largest value

    Dan Gerena


      What function would one use to populate a column with the 2nd greatest (most recent) Date from a column with date transactions?

       

      Note I don't think index() = 2 will work as I don't want to filter the data for just that date, but rather my intent is to create a new column with just that date's sales so I can subtract it from other dates' sales columns.