how to use conditional dimension to filter data

[pashok75]

Dear all,

I have 4 cities A,B,C,D in the dimension.

CITY	PRODUCTION
A	1000
B	2000
C	1000
D	2000

I need to filter on A,B through calculated dimension. How can use the following functions.

1. =

2. <>

3. Like

4. Not Like

Ashok

[pashok75]

NOT inputing the expression in the statement.

[pashok75]

Dear Shoham,

Once I made it calculated dimension the data filters. Thank you so much.

[Or]

Glad to help.

What I would recommend in this case is to create a filtered dimension in your script (with the same syntax) and then use it as a chart dimension. It's "healthier" than using a calculated dimension in charts and should also be quicker / less resource intensive.