Advanced view

Select a category in a derived variable and enter ‘Advanced View’, which opens up a group of new features:


Either observations defined by the report/hierarchy filter – or – defined by formula.

Ignore Filters:

One or more filters on different levels might be ignored.

Result Display:

For Automated report productions you can exchange the category name with the category names from a Hierarchi filter. If i.e. Hierarchi 2 is ‘Department’, and we actually are producing a report for the H&R department, then we can replace a static name with the name of actual report/department name.

Show difference:

Instead of showing an actual value, we can show the difference to one of the other categories in the variable. If i.e. 2018 shows ‘58%’ and 2017 shows ‘48%’, we can choose to display the difference ‘10%’.