5 Replies Latest reply: Feb 16, 2015 5:07 AM by Mohanraj Subramanian RSS

    Calculated Dimension

    Mohanraj Subramanian


      Dear All,

       

      I have date column  for 4 years and its respective sales.

      Now my requirement is if my date column having values for entire year ie(till 31/12/2014)

      then i need a extra row saying 2014 YTD , it should add all the values till Nov 31st 2014..

      If i dont have values for the entire year then i need a row saying 2014 YTD ,it should add all the values till oct 31st 2014..

       

      Please find the attached Screen shot of the requirement