Setting the financial mode

Use the hierarchy Financial Mode to activate a financial reporting mode. When you enable the Financial Mode, expanded consolidated cells appear with label at the top and total value at the bottom, after the last child element of the hierarchy. This is supported only on the row axis. You can configure the new Financial Mode in the dimension configuration.

When you move a dimension that is in the financial mode to a column or filter, then the hierarchy mode is set to Standard. When you move the dimension back to a row, then the hierarchy mode does not change to the Financial Mode.

  1. In the Ad-Hoc Report dialog box, select the rows hierarchy.
  2. Click the Elements tab.
  3. In the Selections pane, select Financial Mode.
  4. Click Update report.