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?