How to write in dimension for the below query ?

[suvechha_b]

Hi All ,

How to write in dimension .

  select distinct dealgroup_id from deal where dealstate_id in (34)

[jyothish8807]

Hi ,

Try this;

if(dealstate_id='34',dealgroup_id)

Br,

KC

[suvechha_b]

Hi ,

Actually , my requirement is -

I got

dealgroup_id,dealstate_id

4642862          3

4642862           38

4642862           34

4642862            33

So , if dealstate is 33 then don't show dealgroup_id but if all of them is 34 then show.

[vishsaggi]

So what is the issue with Jyothish If expr? Did you try that? You want to show ID whose dealstate is 34 right? Based on your data only 34 dealstate and dealgroup will be visible.