Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw
Hi Ajith,
Please find attached file for solution.
Regards,
Jagan.
Hi Ajith,
Please find attached qvw file..
HTH
Sushil