Expression

[upaliwije]

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

[swuehl · Accepted solution]

You are subtracting 1 from the field at a time it seems only be having text representation, try

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

[#3]

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

Try the above

[MK_QSL]

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

[upaliwije]

Thanks all