Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
='Introduced' & ' '&Date(addmonths(Date#(ONLY(C_YEAR_MONTH),'M-YYYY'),-1),'MMM-YY')
Try the above
='Introduced' & ' '&Date(AddMonths(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),-1),'MMM-YY')
Thanks all