I have a year column which has entries from 1986 to 2012. i want the prompt to display all the previous years but not the current year and next years.
It means that "01/01/2011 -31/12/2011" will appear from 01/01/2012.
"you will only be able to select a year for the report once that year is completed. 2011 data only available once 31/12/2011 has passed".
Please let me know the steps to do this.
Hi its simple.
go to your prompt query , using query explore. here add filter on the year column as per ur requirement.
Thanks,
I got it....Thanks a lot :)