How to get only IND AUS data

[Ramu_i]

Hi All,

I have a data 

Country	Revenu
AUS	1000
IND	2000
UK	3000
US	1000
Japan	3000
Irland	1000
Canada	500
Narway	400
Denmark	400
Nedharland	400
Nepal	3000

Requirement 1:

One chart is there in that need Only AUS and IND data needed.

If select the country filter IND it will display IND data , AUS is AUS data ,

If select the any values in country filter it will display the AUS and IND data in table box.

Requirement 2:

Another chart, Don't want to show IND  data, If select the values in IND it will display the others country data.

Thanks & Regards,

Ram

[Vishal_Gupta]

@Ramu_i it seems like simple set analysis problem

for example to only show IND and AUS you can write sum({<country={'IND','AUS'}>}revenue)

for excluding country you can simple write sum({<country-={'IND'}>}revenue)

[Ramu_i]

Hi Vishal Gupta,

I have written same formula, 

If country filter select the country as IND, I want to display the IND, 

Is selected AUS it will display the AUS,

If select the other country it will display IND and AUS data . This is fine, But when select the IND or AUS it shows IND and AUS Information, I want to need If Select the IND it will display the IND information, If Select the AUS it will display the AUS information.

Thanks ,

Ram

[Ramu_i · Accepted solution]

Hi Vishal Gupta,

sum({<country-={'IND'}>}revenue) - Country filter selection is not working, If country filter select any values here shows the all countries except IND,  According to selection it will display the data.

Thanks,

Ram

[Vishal_Gupta]

@Ramu_i can you elaborate your question with sample data and expected result?