My data looks very much same as above and i want to filter it according to BeginDate and EndDate at the same time i want these dates to be picked from a calender something as below.
It would be great if someone can help. Thanks a lot.
Of course, Mohd.
First you need to create 2 date parameter, BeginDate and EndDate. then create 2 calculated filter: Date>=BeginDate ; Date<=EndDate. drop those filter on to worksheet you want filter, and make sure your filter=TRUE.
This could apply to single data source also multiple-data sources
Hope this help you out
Wendy
Hi Mohd.
If I'm not wrong, this functionality came in version 8.1
If you are still on 8.0 you might not see the datepickers
Regards,
Angad