how to find one value in a dimension in the chart

[palomaliang]

Hi,  I want to create a chart for one dimension with multiple values, but only check if it with one specific value.

One A with multiple B

A	B
123	1100
123	1200
123	1400
123	1500
456	1100
456	1600

I need a table shown like this

A	with 1200	with 1600
123	Y	N
456	N	Y

[Vegar · Accepted solution]

I've used the expression  below in my With 1200 column

IF(count({<B={'1200'}>}B), 'y', 'n')

See attachment

[Taoufiq_Zarra · Accepted solution]

@palomaliang  are you looking for ?

in dimension A

Measures

with 1200: if(count({<B={1200}>} A)>0,'Y','N')

with 1600:if(count({<B={1600}>} A)>0,'Y','N')

output:

[Kushal_Chawda]

@palomaliang  with A as dimension use below expression

// With 1200
=if(index(Concat(DISTINCT B),'1200'),'Y','N')

// With 1600
=if(index(Concat(DISTINCT B),'1600'),'Y','N')

[palomaliang]

Thank you Vegar, it works. 

[palomaliang]

Thank you Taoufiq_Zarra, it works. 

[palomaliang]

Thank you Kush, but it's not all right.