Common Column Header for multiple columns

Ranvir06
New Contributor II

Dear Community,

Can we have common column header for multiple columns. For example, we have same entity name for different columns, and we want to merge and center those column headers for multiple columns. Below is the attached cube view and desired output image.

Ranvir06_0-1689146861844.png

Desired Output:

Ranvir06_1-1689146944803.png

Any solution to this will be very helpful and thankful.

1 REPLY 1

JackLacava
Community Manager
Community Manager

In PDF Reports this works like you want, as long as you have one column with two nested dimensions, e.g.

JackLacava_0-1689153905191.png

In Data Explorer, on the Entity header you will get two separate cells but only one of them will contain text.

In Excel unfortunately you will get full separate headers.

This is unfortunately a common issue. You might want to upvote (kudo) this IdeaStream post:

https://community.onestreamsoftware.com/t5/Productivity/Ability-to-Merge-and-Center-Headings-across-...

See also:

https://community.onestreamsoftware.com/t5/Reporting/Cube-View-Excel-Column-Headings/td-p/21819

 https://community.onestreamsoftware.com/t5/Platform/Option-to-center-CubeViewData-Explorer-Column-He...