Issue with data display in WEBI report?

Hi,

I have an issue with data display in my WEBI report.

Presenlty data displaying in my report:

Sales Order Distribute channel Qty Amount S001 DS1 10 100 S001 DS2 20 200 S001 DS2 30 300 S002 DS3 40 400 S002 DS3 50 500 S003 DS3 60 600

in sales order above table "S001" is coming in three cells but it should come in one cell and also same "S002" is coming in two cells but it should come in one cell it should not duplicate in all the cells according to the number of records.