I have a chart that requires to auto select another value when user selected one value in the filter pane. For example when I select July 2016 in the Date field, I would like that particular chart to treat it as both July 2016 and June 2016 are selected even though the user has only selected July 2016. May I know how should I modify the expression for this chart as shown below:
count({< [Status] = {"Live"},
[Termination Date] = {"$(= (Addmonths(Max([Report Date]),-1))"},
[Report Date] = {"$(= Addmonths(Max([Report Date]), -1))"}>} [Record Count])
