Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.