1 Reply Latest reply: Aug 8, 2018 3:02 AM by Chennaiah Nallani RSS

    If logic help

    Mahitha M

      Hi Experts,


      Can any one please help me on below requirement.

      I have a table with all the dimensions


      In Employee Name dimension I have to show only Max(Year) employees. I have tried like below


      =if(Year =Max(Year), [Employee Name]) but getting invalid dimension in the table.


      Please help me on this.


      Thanks in advance.