Sheet Details: Options

The Options section allows you to control data entry and the display of items with no data.

• Allow Input to Parent Members: By default, data entry is confined to leaf/base members. However, when this option is enabled, it permits data to be inputted at a non-base level. When data is entered at a level above leaf members, it is automatically allocated to the leaf members in accordance with their existing proportions. If the leaf members have no pre-existing values, the allocation is distributed equally among them.
• Display items with no data in rows/columns: When checked, rows/columns without data will still be shown. If unchecked, only rows/columns containing data will be displayed.