Conditionally show the column based on two values

[#1]

Hi

I created  a straight table in that i have few coulumns,want to disaply a coluimn based on another column two values

I have done getfieldselections(COUNTRY)=INDIA ,Its working but i want to give one more value

like getfieldselections(COUNTRY)=INDIA and getfieldselections(COUNTRY)=US

its not working for me it is working for only one value.

Please suggest for this

[vikasmahajan]

try with this =If(Match(GetFieldSelections(COUNTRY),'INDIA','US','JAPAN'), COUNTRY)

Vikas

[Kushal_Chawda]

try

if(match(Country,'India','US'),1,0)

or

if( Country ='India' and Country='US',1,0)

[sunny_talwar]

Not sure if this is truly and requirement where you would make multiple selections in the COUNTRY filter or if this is just an or requirement.

If its INDIA and US, try like this:

SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 and SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1

If its INDIA or US

SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 or SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1

[Anonymous]

If it is your calculated dimension then try like this?

=IF(Country='INDIA' or Country='USA', Country)

If it is your expression then try like this?

=sum({<Country={'INDIA','USA'}>} Sales)

[#6]

Hi Kush,

Its working for India or US  and

i need third scenario like INDIA and US.

Means 1.India

           2.US

           3.INDIA and US

for third scenario waht i need to do?

Please do the needful

[#7]

HI Sunny

Its working for India or US  and

i need third scenario like INDIA and US.

Means 1.India

           2.US

           3.INDIA and US

for third scenario waht i need to do?

Please do the needful

[#8]

Its working for India or US  and

i need third scenario like INDIA and US.

Means 1.India

           2.US

           3.INDIA and US

for third scenario waht i need to do?

Please do the needful

[sunny_talwar]

Which of the two expression worked?

[#10]

if(match(Country,'India','US'),1,0)