More Values in Set Analysis

clovati — Wed, 25 Nov 2020 16:16:04 GMT

Hi all!

I have this:

LOAD * INLINE [

Country, Value

USA, 100

FRANCE, 300

ITALY, 500

MILAN0, 50

INDIA, 1000

];

And want this output (ITALY must be ITALY+MILANO and all the other must be 0)

I try with this ... but it's KO .

=If (Country = 'ITALY', Sum({$ <Country ={ITALY,MILANO}>} Value), 0)

Thanks in advance!

Re: More Values in Set Analysis

sunny_talwar — Tue, 24 Oct 2017 14:24:03 GMT

May be try this

=If(Country = 'ITALY', Sum(TOTAL {$ <Country ={'ITALY', 'MILANO'}>} Value), 0)