Lets say, i want to list top 5 products for previous three months.(Similar example to your case).
1. Bring Order date to filter shelf, select Relative Dates.
2. Click on Last 3 Months.
3.Change your Anchor Relative to the date from which you want consider the Previous Months,
4. Now, Bring Product Name to Filter Shelf
5. Select Top 5 as per desired measure.
6. Add Order date to Context. (Right click and then Add to Context)
Refer the attached workbook.
Let me know if it helps.
111.twbx 1.2 MB
It works like a charm!
Thanks a lot for your help.
I am glad it worked
If it helped, please mark my answer correct so as to close the thread.