lock down chart to only show data for a specific field value

[#1]

Hi all,

I have a traffic light chart that i only want to show for a certain field value and nothing else, so ignoring any other selection.

this is the current expression

=

IF($(vListing_Ratio)<=0.7,0,

IF($(vListing_Ratio)<1,0.5,1)) +

IF($(vVolume_Ratio)<=0.7,0,

IF($(vVolume_Ratio)<1,0.5,1))

and i want to include the logic for it to only report on the value 'ACCELERATE ABSOLUT; from the field 'it_objective_name'

Any help woulf be appreciated.

Thanks

[#2]

Managed to do it. i had to create new varaibles for each chart with the set analysis in the variables. i was hoping to use the set analysis on each chart instead and use the same variable. but this works so no need.

thanks