where clause in expression

[#1]

Hi,

I want to get field value based on filter criteria.

ex: field1value='A',get me field2

Earlier i used set analysis to get count

count({$<Type={'DUPLICATION'}>}ID) 

Now i want just value of other field.if its of type duplication

Regards,

Prajna

[Anonymous]

It should have distinct dimension on which you can show the numbers and in set analysis, you can write Type as Duplication. It would be helpful to analyse if you can attach some sample document.