Element reference modifiers

Both visible and hidden elements are included.

This is the default visibility filter.

Only elements on the same hierarchy levels in the dimensions as the current element are included.

This is the default hierarchy filter.

If an integer >= 0 immediately follows this filter name, e.g. ‘l2’, then only the values in level 2 are included, with level zero being the grand total.

Only elements that are nested inside the current element are included.  Please note that only data references can be used with this filter.

Example: This filter can be used with an if-then-else operator for making subtotals that only include the visible elements, when some elements have been hidden by a Visibility Agent:

if allcount(0,d1:d-1(c),m1) > 0 then sum(0,d1:d-1(v,c),m1) else sum(0,0,m1)

This filter is useful e.g. for making an accumulation which follows the current expansion of single elements:

Like with the ‘level’ filter, an integer >= 0 can follow this filter name, e.g. ‘r0’.  In ragged filter, however, this value is somewhat more complicated to explain:

Level zero are the leaf elements, i.e. the elements that have no children.  Level one are their parents.  In the example above, only 2001 is on level one.  Level two are the elements that have level 1 children (grand total above), etc.

Relative and data references are indexed according to the current sorting of the grid.

This is the default order filter.