4 Replies Latest reply: Dec 10, 2012 9:27 AM by Henry Noh RSS

    Want to retrieve only latest month data in straight table

      Hello all,

       

      I have 3 fields.

       

      CLIENTS

      MONTH

      REVENUE

       

      Not all clients have revenue in all months.

       

      I'd like to show in a straight table, the REVENUE FOR THE LATEST MONTH.

       

      suggestion?  I tried incorporating max(month) into set analysis but doesn't seem to be working.

       

      Thanks in advance!