1 of 1 people found this helpful
if datetrunc('month',[Order Date])>=dateadd('month',-13,[Parameter 1])
and datetrunc('month',[Order Date])<=[Parameter 1]
then "Show" else "Hide" end
>> Filter >> Show
If you want to show sales from July 2017 - July 2018
Great!! Works fine! Many thanks Joy!
Here is another way to do it using the filters:
1. Add the date filter with the required condition. Ensure that this filter is added to context.
2. Add the MONTH(Order Date) filter to the filter values, change it to discrete type and and then add the Top filter as shown below.
You should have the desired result. Hope it helps.