You can create a calculation field to calculate the date after which you want to see the data.
In your case that is 5 weeks. then use this calculated field as a filter in your sheet
1 of 1 people found this helpful
Create a calculated field
filter this calculation compute table across and select true
hope this should solve your problem
Its a wonderful answer.I did not understand "compute table across ". i just dragged that calculated field onto the filter box and selected true.It worked for me.
Thank you very much for your help!
Glad it worked sandeep
anyways the default computation is table across hence you do not have to change anything
Thanks once again Praveen!