Forum Discussion

LisaS's avatar
LisaS
New Contributor III
2 years ago

Cube View - Excel Column Headings

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 c...
Cube View
Federmann's avatar
Federmann
New Contributor III

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

JamesKirkby's avatar
JamesKirkby
New Contributor III
2 years ago

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.