Analysis Settings

The analysis settings are only available if, in the display options, you have selected the "Table view". In the 80/20 analysis and the variance analysis, you can use the following options to filter the field structure and the values:

Field selection

You can choose from a display of all the fields in the structure, the negative (cost) fields only or the positive (revenue) fields only.

Value filter

For the absolute values and the relative values, define an upper and/or a lower threshold. The table will then only display the fields that match the value filters you have set.

Informative rows

For all columns with relative and absolute values, you can display the sum, the average, the maximum and the minimum of all the table values in an extra row. These purely informative rows are always displayed at the bottom of the table.