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.






      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!