3 Replies Latest reply: Oct 18, 2015 12:10 PM by Blerta Deliallisi RSS

    Compare current field value vs column max

    Blerta Deliallisi

      Hi guys,


      May seem a very simple question to most of you but I am not getting around this.

      I have a table with columns A, B, C, D and I what to show values only if the value of the current row of C matches the max value of the column C

      so if A, B, C,D

             1, 2, 3, 4

             1, 4, 5, 6

             7,8, 5, 3


      I want to show only the last two rows.