4 Replies Latest reply: Jun 9, 2014 12:43 PM by UPALI WIJERATNE RSS

    Expression

    UPALI WIJERATNE

      In my pivot table I have following expression label which is working well

      ='Introduced' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),'MMM-YY')

       

      But this expression label is not working

      ='Introduced' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)-1),'M-YYYY'),'MMM-YY')

       

      pls some one advise me what is wrong with 2nd label