filter dimension in chart

[#1]

I have a dimension field which has multiple values . I want to restrict this dimension to show only a certain value . Basically dimension is country . I want to filter the dimension to show only India. How can edit the expression to show only India without editing the SQL query behind .

Thanks

[#2]

= Sum( {$<country={India}>} Value)

[#3]

I am not creating an expression field , I needed to create a dimension but that dimension only needs to show a single value. I am looking for something like {<country={India}>} but it is not working for me. Any ideas?

[#4]

For a quick solution create a dimension when loading the script

you can use

Load

country,

if(country = 'India',country) as My_country;

SQL Select * from tblCountry;