chart calculation

[mambi]

Hi,

Please have a look at the qvw and xlsx files.

in the 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 ?

[isingh30]

Can you share data in excel sheet?

Thank you

[mambi]

here's

[shiveshsingh]

May be this?

[isingh30]

Can you share code & output ?

Thank you!