Set Analysis Issues

[ajithsachin]

HI All,

     I have a table like this.

Branch	Itemcode	Stock	Sales
1	001	10	0
2	001	4	3
3	001	1	10

if i select branch 1,i need to know item which is having stock and there is no sales and in second column need to show in which branch

that item is selling more and what is the sales qty.

my result chart should be like this

Itemcode	Stock	Branch which is having most sales	Sales
001	10	3	10

can anybody help please..

Regards,

Ajith

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[jagan]

Hi Ajith,

Please find attached file for solution.

Regards,

Jagan.

[sushil353]

Hi Ajith,

Please find attached qvw file..

HTH

Sushil