LEVELSBETWEEN

Returns the number of steps from the Ancestor specified to the Descendant specified.

js

LEVELSBETWEEN(dimension, ancestor, descendant)

Parameters

dimension - The dimension to source the sequence from.
ancestor - The ancestor to count the amount of steps from.
descendant - The descendant to count the amount of steps to.

Examples

js

LEVELSBETWEEN("Account", "EBITDA", ELEMENT("Account"))