Newcomer

Cube View - Excel Column Headings

Forum|Forum|2 years ago
July 11, 2023
2 replies
0 views

Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column.

Excelvs. pdf

F

Federmann

Newcomer

Actually that sort of behaviour would also be great for the direct cubeview representation, e.g. in a dashboard, not only the export.

J

JamesKirkby

Newcomer

Could you use conditional formatting to make the Excel text blue in the first and last column, while white in the middle with Excel wrap text false? I don't think there is a way to do this using header format default settings. the border settings might need a slight adjustment as well.

J