hierarchy

The relationship of formulas within other formulas. For example, a formula for pizza sauce is within the formula for pizza. The pizza sauce formula, which is a subformula, is within the hierarchy of the pizza formula. Hierarchy can be viewed using the data navigator or in the Formula Hierarchy dialog. Both show the relationship of formulas to their subformulas.