Appreciate your time for going thru my post and responding.
Sample data has data from Jan'15-Mar'17.
Thereby expected output should be Apr'16 till Mar'17 when i try for last 12 months.
But its giving me from Jun'16 till Mar'17.
I don't want users to enter 14 months in the dialog for retrieving 12 months of data.
Request to double check the sample .twbx i have previously attached.
I have again attached the same for convenience.
Please let me know if there is any solution for this.
PS: Also attached before (1) and after (2) images for better clarification.
I do see that data is NA.
I wanted relative dates to work NOT on basis of Sysdate – Unfrtntly not possible.
Find my alternative approach based on index() below as reference and stored in attached workbook version 10.1 located in the original thread.
I really thank you for all your time and solution offered.
Your Index filtering method works well but the interface “Relative filter” offers (customized weekly, monthly, yearly views) will be taken out.
Client really wanted the interface retained.
Nonetheless I found another soltn for my case from this post- https://community.tableau.com/docs/DOC-8399
Once again I thank you for your help.