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.
One or more filters on different levels might be ignored.
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.
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%’.