Rows to column

[kichu1]

Hi Every one,

I need to display from the Following format

Customer_GP Cust_Type Sales
---------- --------- -----
A100 A 200
A100 B 100
A100 C 50
B100 A 50
B100 X 150

To the Below Format

Customer_GP Cust_Type Sales
---------- --------- -----
A100 A/B/C 350
B100 A/X 150

Could any one please give an idea how to convert from Rows to Columns.

Regards
Kichu

 

[skrandel]

This is not possible. You're trying to display multiple rows within a single column. There really is not functionality to do this.

Steve Krandel
VERITAS Software

 

[dbomrrsm]

Ask your backend developer to help they should be able to help as what you want is possible with SQL.

[blue]DBomrrsm[/blue]