2 Replies Latest reply: Dec 10, 2012 9:28 AM by Henry Noh RSS

    Is there a 'Lastsortedvalue' type function?

      I have 3 fields

       

      Client

      Month

      Revenue

       

      I'm trying to pull into a straight table a chart that will list the CLIENTS and show REVENUE for the latest month where the client had revenues.

       

      Some clients don't have revenues in the latest month and instead of showing a blank, I'd like to show the monthly revenue for the latest month where it existed.

       

      firstsortedvalue does the trick for the earliest month, but is there a function for the latest month?

       

      Thanks in advance!