Generate Filter Condition Statement

[#1]

I need to generate two different conditions to filter my dashboard objects.

IF FIELD A = "ACTIVE"

IF FIELD B = "OPEN"

I would like to generate a list box that the user can select one of two values and have the above conditionals passed to the other objects in the scorecard....

Any ideas?

THanks.

[sujeetsingh]

better to go with a flag field  called in script as

if(...) ....flag

this flag will have values as Active and Open