Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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.
@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)
@Saurabh07 uncheck below option
@kaushiknsolanki Great, it worked! Thank you!
@Kushal_Chawda @Taoufiq_Zarra @kaushiknsolanki @Lisa_P Thank you guys, each of your solutions work in specific case. Thank you so much!!