Set Analysis row level comparison

[samp1]

I have Table as below,  and I am trying row-level comparison with below expression, is it possible.

Load * Inline [
Country, poplation
Ind,200
Ind,200
USA, 300
USA, 300
Can, 500
Can, 500
Chn, 400
Chn, 400
GER, 300
GER, 300
Asia,0
Asia,0
NAMR,0
NAMR,0
];

My Expression: 

if (Country='Asia', Sum({<Country={'Ind','Chn'}>}poplation),
if (Country='NAMR', Sum({<Country={'USA','Can'}>}poplation),
Sum(poplation)))

I am expecting for Asia=1200 and NAMR=1600 in the same below chart.

[chrismarlow · Accepted solution]

Hi,

You would need to put TOTAL in, so something like (not tested);

if (Country='Asia', Sum(TOTAL {<Country={'Ind','Chn'}>}poplation),
if (Country='NAMR', Sum(TOTAL {<Country={'USA','Can'}>}poplation),
Sum(poplation)))

Cheers,

Chris.