Showing results for 
Search instead for 
Did you mean: 

BEX Query Formatting Question

Former Member
0 Kudos

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



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I solved this problem,

I just did right click on "Rows" and unchecked the "dispaly as hierarchy " option.