This content has been marked as final. Show 5 replies
Note possible, better try to Dashboard Prompt user Check box/Choice List option.
Thanks for the reply. But the client requirement is to do using radio button. Is that ok to suggest the client to use
multi - select ???
Is the 3year 2000, 2001 and 2002 always static for will it change.
What will be the solution for static and what is the solution for dynamic values???? any solution may help me a lot...
Hi Tinku,1 person found this helpful
In case of static this can be achieved as given below:
Add a new column with formula:
case when time.year in (2003,2004,2005) then '2003, 2004, 2005' when time.year in (2006,2007,2008) then '2006, 2007, 2008' else null end
and make this as an is Prompted filter.
Add a new column prompt with the column formula (case when "Gl Time Period"."Time Period Yr Dt" in (2003,2004,2005) then '2003, 2004, 2005' when "Gl Time Period"."Time Period Yr Dt" in (2006,2007,2008) then '2006, 2007, 2008' else null end)
Hope this helps.