11 Replies Latest reply: Sep 27, 2018 9:49 AM by omar bensalem RSS

    Filter Issue while using ABOVE Function

    Elie Issa

      hi all,

       

      Please i am having problem with the below expression while filtering on a specific business unit

       

      above(FirstSortedValue(distinct [Business Unit],-[Assignment SDate]))

       

      This expression is working fine in case we are not filtering any business unit.

       

      The purpose of my expression is to get the previous business unit.

       

      Any idea how to solve this issue.

       

      Thanks.