1 Reply Latest reply: Mar 5, 2013 3:56 AM by Gysbert Wassenaar RSS

    Get Latest Year for Sales

      Hi everyone,

       

      I have a date dimension which has years 2000 up to 2025.

      I need to get the latest year that has sales (in this case 2013), and need to display this value in a simple text object.

       

      Can anybody provide some pointers to write this expression?

       

      Thanks,

      J