BEX Query Formatting Question

[Former Member]

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

POPS

null

[Former Member]

I solved this problem,

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