1 Reply Latest reply on Apr 16, 2018 1:43 PM by Patrick A Van Der Hyde Branched from an earlier discussion.

    Re: Clear Action highlighter in source sheet from target sheet

    Dev Sharma

      Thanks...Can some one please help me to find out one row from below data:

       

      I wants to show only one record by comparing month1=month2. In below example it should compare and show only 18-Feb record from month2.

       

      Month1IDMonth2
      18-Jan10118-Feb
      18-Feb10118-Mar
        • 1. Re: Clear Action highlighter in source sheet from target sheet
          Patrick A Van Der Hyde

          Dev,

           

          This question does not have much context so i'm not sure if my reply will assist here or not but I would use 

           

          If first()=0 then 'show' else 'hide' end

           

          and put this calculated field on the filters tab.  Select to show only "show".

           

          This assumes that the second row of data does need to be 'in the view' so to speak in order to have the calculation appear and work.

           

          let us know if this works or you need more assistance.

           

          Patrick