Thanks for reply. when I am adding the expression like below
'Date range from '& date(addMonths(max(Date(WeekEndingCY)),-1))& ' to '&Date(max(Date(WeekEndingCY)))
Ex: I select date 1/7/2017. So, date range last 4 weeks based on selection.
It has to show 1/7/2017 to 3/6/2017(Last 4 weeks)