Here you go.
Create four calculated fields
when "Year" then [Header_Year]
when "Quarter" then [Header_Quarter]
when "Month" then [Header_Month]
Date_param_9.0.twbx 6.1 KB
Thanks a lot for your reply.
It's working as per the expectation.
I have 2 questions -
If I make it to day level then the dropdown list will become huge ,is there any way can we separate in 4 different filters and enable/disable the filter based on first parameter choosing.
say I will have 4 filters year , month and quarter and days additional to YQM
when I will select year in YQM then only my year filter will be enabled and rest 3 will be disabled
When I will select month in YQM then only my year and month filter will be enabled and the rest 2 will be disabled
Also We are taking dates based on the order date ,say for a particular month there is not order so that month wont appear in my filter.
Is the any way can I fill those missing dates in the filters ?
Thanks again for your help.