Sum calculation

[mambi]

Hi,

Please have a look at the qvw and xlsx files.

in the (qvw) summary chart i want to be able to display the sum of quantity when the recommended product was sold (only when flag = 1 )

the final chart (expected result) should be like  the one in Sheet2 (xlsx file)

i tried with set analysis but no result.

any idea ?

[sunny_talwar · Accepted solution]

May be do this using an Island Table approach or Link Table... I created it using Island table in the attached app.

[mambi]

Great work !

that's what i'm looking for,

but is there a way to do it with indirect set analysis only ?

Thanks a lot

[sunny_talwar]

Unfortunately, I don't think so...