3 Replies Latest reply: May 2, 2016 11:43 AM by Sunny Talwar RSS

    Get the value with filter by variable without (SUM, COUNT, MAX)

    Mathieu Vibert

      Hello Everyone,

       

      I have a table with a month number & month description (used to filter data)

      NoMonths
      1January
      2Februar
      3March
      .....

       

      In a variable I have the number of the month : (no selection = number of th current mont, >1 selection = max number).

      =IF(GetSelectedCount(TIME_DESC)1,Month(Today()),IF(GetSelectedCount(TIME_DESC)>1,Max(TIME_MONTHUM),TIME_MONTHUM))

       

      But I need to have the in a other or same variable the description of the month number

      Something like this : (TIME_MONTHUM=$(=vPeriod),TIME_DESC)

       

      How to get the value with filter (without any SUM, COUNT)

       

      Best regards