Filter values in a dimension.

[#1]

Hello.
I am creating a Pivot Chart. I have a dimension Population_Category. There are 3 distinct types in Population_Category. These are: Rural Population, Urban Population and Total Population.
Could you please help me to filter only two types: Rural and Urban population, in chart properties? Is it possible in Edit Expression?
Thanks in advance!!

[#2 · Accepted solution]

The filtering needs to be done in the dimension level and not in expression. Go to dimension tab -

Include this in the calculated dimension areas...below is an example

=if(pop='urban','urban',if(pop='rural','rural'))

and check Suppress when value is null option.

[#3]

Thanks Siva. It works.