23 Replies Latest reply: Aug 31, 2015 2:10 AM by Sunny Talwar RSS

    Sum and FirstSortedvalue issue

      Hi all,

       

      I have a chart that has one dimension called PID.

       

      I have several expressions (5) in total that are of the form

       

      Cost = Firstsortedvalue({<YearMonth = >} Cost, -StartDate)

      Status = Firstsortedvalue({<YearMonth = >} Status, -StartDate)

       

      I would only like to have one row for each PID and the firstsorted value gives me the latest row as expected.

       

      I am trying to do a sum in two textboxes to display the costs for all "Expired" statuses one for all "Active" statuses and I am unable to get it to work.

       

      I have attached my table with some comments to make it easier to understand.

       

      Any ideas please?

       

       

      Thanks