How to display the last month sales of an item by selecting date as today

[manideep1]

@Jesse

ifelse(dateDiff({order_date},now(),“MM”) = 1, sales, 0)

If i use the above logic for last month, and when i use the date filter the value gets 0,
but it shouldn’t change