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.