Customize reports

You can try out some options for report result configuration in the report results toolbar - maximize report area [1], undo & redo buttons [2] as well as adding report description [3], and hide empty rows and columns without values [4]. You can add the bottom row and far-right column with the aggregated Total value [5].

Undo and redo changes

While editing the report, do not be afraid to make changes. Before saving, you can undo or reduce the last changes before saving the report.

Total and sub-total

You can use the Total [1] feature to quickly get the aggregated results of rows and columns at the bottom (for rows) and in the last column (for columns). In most cases, this will do the job. However, some measures are more complex and represent calculated values (like average, max, conditional statements, or specific properties), so you might need to force the Total row behavior with annotation in the formula editor to calculate the sum of results.

If you expect other functions but Sum, we recommend using hierarchy levels or calculated members to get total or sub-total values [2] for the particular calculation. You can expand [3] the hierarchy levels and see results calculated at each row.

Change row dimension headers

You may add or change a header on columns containing row dimension members [1]. Choose to display the dimension name as a header, or edit and enter a custom display text. 

Headers of measures can't be changed from the report view [2]. You may change the name of the measure itself (it would affect all reports where the measure is used) or create a new measure (or calculated member for other dimensions) with the needed name and then use it instead of originally selected.

Vertical column headers

It is possible to change the table report to show the column headers vertically. The option of the vertical header will appear automatically when the report width exceeds the size of the report design dashboard area, and the horizontal scrollbar will show up.

The “Vertical header” button will show up, and you can turn on the report to show the lowest level column headers vertically.

Table header formatting

By default, column widths are set to Auto, automatically adjusting to fit the table within the screen. But you can specify the table header look if needed.

Change the column width

You can resize column width by dragging the right border of the column header [1].

• Hold Shift while resizing to apply the same width to all headers in the same dimension
• Double-click the right border to restore the default width

When multiple column dimensions are used, changing the width of a lower-level header [2] restores the higher-level header width to the default.

When you hover over the header, a wider right border highlights that the column width has been changed [3].

Header formatting and color

You can specify the text positioning, formatting, and color for column and row headers. Click on the column header or any member name on the report rows to open the header formatting window.

In the header formatting window, you can set formatting for all members, like all Measures on report columns [1], or customize an individual member, specifically the one you click on [2]. 

Available options:

• Set the width in pixels – for row dimensions, the header width can be set only for all members; changing individual member width is not supported.
• Change the text and background color
• Align text to the left or center 
• Apply bold formatting – if bold is set for all members, you cannot set an individual member back to regular text
• Clear all formatting to restore the default options