How to group the field in table box

[#1]

Hi,

I used table box with productname,sales

product name , sales

soap 12

soap 8

powder 5

i need to group this value soap 20

powder 5

what should i have to done to show like this in tablebox.Any option to be checked in the table box properties

pls..help me out.Thanks in advance

[#2]

Hi

First you do script level

Load

Product_Name,

sum(Sales) as Sales

resoident Product group by Product_Name;

Then you call both field in table box.

Regards

Ashish