To eliminate entries where sum of values is 0

[Saurabh07]

Hello Gurus,

I have the mentioned data set,

Country	Value
Algeria	10
Andorra	1
Angola	0
Anguilla	0
Algeria	2
Andorra	9
Angola	0
Anguilla	0
Algeria	7
Andorra	3
Angola	2
Anguilla	0
Algeria	3
Andorra	6
Angola	5
Anguilla	0

Now I am trying to eliminate the country 'Andorra' and all other countries whose sum of Values is 0. I have successfully eliminated 'Andorra' from my pivot table with mentioned expression:

sum({<Country -= {'Andorra'}>}Value), but struggling to achieve the second condition. So my desired output in pivot form has to be;

Country	Sum of Value
Algeria	22
Angola	7

Can anyone please help me out here?

[Saurabh07]

@Lisa_P  Thank you for the suggestion. But I am afraid this might not be the solution I am looking for, as I am already limiting the data for some other measure. I mean in the same pivot, I am already limiting the countries greater than 80% of another measure. 

[Taoufiq_Zarra · Accepted solution]

@Saurabh07its a sample table

or you can always do :

in Country dimension use :

if(aggr(sum(Value),Country)>0,Country) and uncheck include null value

and in measure sum({<Country -= {'Andorra'}>}Value)

[Kushal_Chawda · Accepted solution]

@Saurabh07  uncheck below option

[Saurabh07]

@kaushiknsolanki Great, it worked! Thank you!

[Saurabh07]

@Kushal_Chawda  @Taoufiq_Zarra @kaushiknsolanki  @Lisa_P  Thank you guys, each of your solutions work in specific case. Thank you so much!!