Skip to Content
Former Member
Jul 30, 2007 at 02:52 AM

BEX Query Formatting Question


Hi All,

I have a requirement to create a report. I almost finished creating the report. But the user wants to see the characterstics on rows in seperate columns.

I have 2 chars in Rows and 1 structure for columns and 2 free chars for drilldown. In Rows I have 'Customer Number' and 'Service Type' chars. When I execute the query the customer no and service type are displaying under single column with hierarchy structure.

Eg: Customer Number

> Servie Type

Customer number

> Service Type

But the user wants to see the results in seperate coulmns (with group by), like

Customer Number | Service type | Columns structure etc...

Evne if i select any free char for drilldown, that should come in a seperate column.

Can any one help me how can i achieve this.

Thanks in advance