Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
AVINASH22
Contributor II
Contributor II

how to find out Current year previous month expression

write an expression to calculate current year previous month sales?

field available:Month(MMMYY formate),year,sales

2 Replies
sivakumar1994
Contributor III
Contributor III

sort the chart by year-month and use above (month field) in expression

rubenmarin

For use outside dimensions, like in a text box, it can be:
Sum({<Month={'$(=Date(AddMonths(Today(), -1), 'MMMYY'))'}>} sales)