exclude one more vaules on condition

[#1]

Hello Expert,

Lets say I have inline data on following format.

Field1	Field2	Field3
367	1@1.com	Op
258	2@2.com	Op
452	3@3.com	Se
367	1@1.com	Op Ou
258	2@2.com	Se
258	2@2.com	Op Ou

I am creating straight table chart by using

Dimension: if(Field3='Op',Field2)

Expression: count(Field1)

Result: which are fine based on above conditions.

Field2	Count
1@1.com	1
2@2.com	1

But i would like to add another condition to exclude "Op Ou" as well from above result.

Fianl result would be

2@2.com as it doesn't have any values of "Op" and "Op Ou".

Thanks,

Dinesh

[its_anandrjs]

Hi,

When you select Dimension: if(Field3='Op',Field2) this condition by this you check where ever a value equal to "Op" will display but you want to exclude a "Op Ou" if so you have to write

Dimension: If( Field3 = 'Op' and  Field3 <> 'Op Ou' ,Field2) in dimension part and in expression it will be same

Expression: count(Field1).

Rgds

Anand

[#3]

Hi,

I have already tried above dimension but it still doesn't display correct value as above.

Any other solution?

Regards,

Dinesh