Skip to Content
Former Member
Jan 30, 2011 at 03:06 PM

Model with a Static Drop down List



How can i achieve this...any help would be greatly appreciated

I had a Query With Cal Month/Year in rows and Revenue in Columns and Region as Free Chars

Query is restricted to display last 12 Months using offset variables and Region is restricted to fixed list of 10 regions

My Requirement is to develop a VC Dashboard/Model with

Drop down with a static list of 10+1 region (10 for individual region and 1 for all 10 regions)


How can i Create a Static List and

How can i pass the user selected value from drop down to query..

Please help would be greatly appreciated

Thanks in advance