Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below data...
Customer Name | Customer Country | Customer Total | Supplier Name | Supplier Country | Product | Supplier Total | Profit | % Profit |
CUST001 | Germany | 100 | SUPP001 | France | OIL | 90 | 10 | 10.00% |
CUST003 | France | 300 | SUPP001 | France | OIL | 250 | 50 | 16.67% |
CUST002 | Germany | 200 | SUPP002 | Germany | SOAP | 150 | 50 | 25.00% |
CUST004 | USA | 400 | SUPP003 | Italy | EGGS | 380 | 20 | 5.00% |
CUST005 | Australia | 100 | SUPP004 | Spain | RADIO | 80 | 20 | 20.00% |
CUST008 | France | 400 | SUPP004 | Spain | RADIO | 300 | 100 | 25.00% |
CUST006 | Italy | 200 | SUPP005 | USA | TV | 175 | 25 | 12.50% |
CUST010 | Australia | 600 | SUPP005 | USA | TV | 540 | 60 | 10.00% |
CUST007 | Germany | 300 | SUPP006 | India | PHONE | 270 | 30 | 10.00% |
CUST009 | USA | 500 | SUPP006 | India | PHONE | 460 | 40 | 8.00% |
I need to show a profit table based on different selection. But want to make only one table.
My table should be displayed with below two columns.
Selection & PROFIT%....
where Selection could be any one from below which can be displayed as either list box, table box or multi box.
Customer Name
Customer Country
Supplier Name
Supplier Country
Product
Please help...
Regards,
Manish
It's working perfectly. Thanks to all for your help.