14 Replies Latest reply: Feb 2, 2016 5:48 AM by Sunny Talwar RSS

    Filter in visualization

    Deepanshu Chamoli

      Kindly help me in the below logic in the measure:

       

      I have the below formula:

       

      SUM(Total_Transfer)

       

      I want the sum of only those whose Transfer date is maximum means MAX(Transfer_date).

       

      Something like that:

       

      SUM({$<Transfer_date = {MAX(Transfer_date)}>}Total_Transfer)..

       

      But it is not working.

       

      Thanks and Regards

      Deepanshu