1 Reply Latest reply: Oct 27, 2017 7:14 AM by Sunny Talwar RSS

    Derive a Dimension on Selected Date Range ,Or Calendar(Year,Month,Quarter)

    gaurav gopale

      Hi All

       

      I the following table

       

      IDDatePaymentTerms
      101/01/2017FOR
      102/03/2107Exworks
      203/05/2017Exworks
      205/10/2017FOR
      304/09/2017Exworks
      406/06/2017FOR

       

       

      on selection of date range

       

      I want PaymentTerm by ID by Max Date

       

      This calculation should be done on fly (in presentation layer)

       

      Want to use it as dimension

       

       

       

      Thanks in advance