Dear All
I have data in table as below
Order Color Size Ratio TotalQuantity
1 Red Med 1 100
1 Green Small 2 200
1 Red Large 1 100
1 Green Large 2 200
I want to display it like
Order Color Small Med Large Total
1 Red 1
1 200
Green 2 2
400
2 Red 1
1 200
Green 2 2
400
please help
Regards
Umair
Thanks and Best Regards Umair