1 Reply Latest reply: May 10, 2017 2:41 PM by Sunny Talwar RSS

    Sum of measure from latest date

    s Walter

      Hi,

       

      in this thread i asked How to get the latest date of existing data

       

      Now i want to get the sum of a measure, but only from the data with the latest date.

       

      I try this, but get the sum from all data with older dates, too.

       

      Sum({<myDate = {"=Max({<someMeasure = {'*'}>}myDate)"}>}Sales)
      
      

       

      How can i get the sum only from the data with the latest date?


      regards,

      sam