Calculation going back 30 days in straight table

[gerrycastellino]

I have a straight table,  it doesn;t have a date dimension.

I'm trying in my expression calculation go back 30 days from the date selected in the dimension filter.

By doing this:

sum({<Activity_Date = {"$(=Date(AddMonths(Only({$} Activity_Date), -1), 'MM/DD/YYYY'))"}  >} SENT_TO_CARRIER_COUNT_UNLAGGED)

What am I doing wrong.

[sunny_talwar]

Are you making selection in Activity_Date field or another date and time related field? If you are making selection somewhere else, you might need to ignore selection in those field/s