10 Replies Latest reply: Sep 21, 2017 12:59 PM by Cassandra Baqir RSS

    Show only Dimension = max(Dimension)

    Cassandra Baqir

      I want to only show rows where PRIMARY_DECISION_AGENDA_DATE = max(PRIMARY_DECISION_AGENDA_DATE)  but this is not working. If I select Suppress Null, nothing shows up at all.

       

      = Aggr(IF(Rank(Date(if(match(PRIMARY_DECISION_AGENDA_DATE,max(PRIMARY_DECISION_AGENDA_DATE)>0,PRIMARY_DECISION_AGENDA_DATE))), 0) = 1,PRIMARY_DECISION_AGENDA_DATE), GOV_DECISION_BODY, REQUEST_REGION, DETECT_BY, CUR_STATUS,DEFECT_ID, PRIMARY_DECISION_AGENDA_DATE)

       

      Thoughts?

       

      9-21-2017 9-27-46 AM.jpg