could you please help me in below thing:
how to incorporate following filter using prompt macro:(because my report is based on sql. I have added this filter in the query for it is taking long time to produce the results. so I want to put this filter in the sql only using prompt macro and see how long it will take. I am sure prompt macro does not take longer time)
(?dateRange?='P' and
[Data Item1] = _add_days(current_date, -1))
or
(?dateRange?='P3' and
[Data Item1] between( _add_days(current_date, -3)) and ( _add_days(current_date, -1)))
or
(?dateRange?='P4' and
[Data Item1] between( _add_days(current_date, -4)) and ( _add_days(current_date, -1)))
or
(?dateRange?='PW' and
[Data Item1] between( _add_days(current_date, -7)) and ( _add_days(current_date, -1)))
can I get any help please..