Breaking Time interval into Weeks
I have applied "From Date" and "To Date" at universe level which ask the user to enter the dates before the report refreshses every time.
Is there a way that depending on the user's input value for FROM DATE and TO DATE, i can show the data based on the weeks?
Suppose if the user select the Date interval of one year then the report will show the data based on all 52 weeks and if the user select the interval of one month, then the data should be on basis of 4 weeks?
Please let me know how we can acheive this?
Thanks & Regards