8 Replies Latest reply: Apr 25, 2018 1:08 PM by Mart�n Caruso RSS

    Show the amount of the maximum date if you have not selected

    Mart�n Caruso

      Hello good afternoon.

      I have a table whose main fields are the following:

       

      ACCOUNTAMOUNTYEARQUARTER
      1102017Q1
      1152017Q2
      1222017Q3
      1502017Q4
      2342018Q1
      2452018Q2
      3302017Q1
      352017Q2
      3122017Q3
      3282017Q4


      I need that when I have not selected the year or quarter, the indicator that I care about the maximum date (in this case, according to the data in the table, which should show the amount for the year 2018 and Q2). Then, it should show according to the selection you have.


      Of course, I appreciate any kind of help you can give me.

      Regards,

      Martin.