Repeat leaves data spreading method

The Repeat Leaves method copies a specified value to the leaves (children) of a consolidation. When you apply this method, you can copy the value to all leaves of the consolidation or only to those leaves that already contain non-zero values.

For example, say there are several leaves of Year, Argentina with values.

If you use the Repeat Leaves method to copy the value 400 to the leaves of Year, Argentina currently populated with non-zero values, the value 400 is copied to all leaves that contained non-zero values.

If you initiate the Repeat Leaves method from a cell identified by more than one consolidated member, the specified value is copied to all leaves associated with the cell. For example, in the following view, the selected cell is identified by two consolidated members: Year and S Series Sedan.

If you initiate Repeat Leaves spreading from the highlighted cell, the specified value is copied to all cells identified by the leaves of Year and the leaves of S Series Sedan. For instance, if you use Repeat Leaves to copy the value 25 to all leaves of the highlighted cell, the result is as follows.

LR*25