Options

The Options section allows you to control the display of items with no data in the snippet. There are two checkboxes available:

• Display items with no data in rows: If selected, rows without data will still be shown in the report.

• Display items with no data in columns: Similarly, this checkbox determines whether columns without data will be displayed.

• Allow Input to Parent Members: This option is only available for Input Sheet. By default, data entry is restricted to leaf members. This option, when enabled, allows data to be inserted at a parent level. When data is inserted at the parent level, it is automatically allocated to the leaf members based on their existing proportions. If the leaf members have no existing values, the allocation is done equally among them.