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

EDIT: now available for all modes in version 8.2

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 and Excel, it will also work from version 8.2.

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...