Hello Everybody,
I am having a table and the sample data is as follows :
HTML Code:
ord_no tr_date party itemname fab ref cref col1 col2 col3 col4 size1 pcsize1 size2 pcsize2 size3 pcsize3 size4 pcsize4 size5 pcsize5 size6 pcsize6 rate
1111 6/3/2009 ALBERT JUGNU TOP LONG SLEEFS =XS CAMBRIC 123 12234 HEENA CHOCO BROWN RED S-Small 10 M-Medium 20 L-Large 30 XL-Extra Large 40 FS-Free Size 50 FS-Free Size 60 120
1111 6/3/2009 ALBERT KAMAL HOLE TOP M=S HANDLOOM 123 12 HEENA CHOCO BROWN RED S-Small 5 M-Medium 20 L-Large 30 XL-Extra Large 40 FS-Free Size 50 FS-Free Size 60 120
The desired output is like :
eg.
HTML Code:
Fabric color Nos
CAMBRIC HEENA (SUM OF ALL PCSIZE1-6 FIELDS)
CAMBRIC CHOCO (SUM OF ALL PCSIZE1-6 FIELDS)
CAMBRIC BROWN (SUM OF ALL PCSIZE1-6 FIELDS)
HANDLOOM HEENA (SUM OF ALL PCSIZE1-6 FIELDS)
HANDLOOM RED (SUM OF ALL PCSIZE1-6 FIELDS)
Pl. Help me to find a solution to this query.
Thanks and Regards
Neeraj