Can i create custom heading in OTBI report?

Question

This is an example of what i want to achieve the first image is created in excel, the second is in OTBI can we have Custom Header like in excel.

Regards,

Omran

gclampitt · Answer

Don't thnk there is an easy option.

Could maybe do a Union to return custom headers as a "data row", then format that row.

Select 'heading1' , heading2'…

union

select data1, data2

Other option is if Edit formula for each dim/measure and provide the required "Folder headings" to group them together.

In the table view > Table properties > change "Display folder and column headings" to "As Folder.column"

this then includes the heading you have provided also, albeit in format Heading.Column and not on a 2nd line like you wanted.