Can i create custom heading in OTBI report?

Omran Zeaiter

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

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.