Specifying a Value/Value Reference for Characteristics 
Specifying a Value/Value Reference for Characteristics
Prerequisites
A characteristic value or the cell reference of a characteristic value has not yet been specified, for example if you manually inserted the characteristic into your matrix.
Procedure when Using Detailed Menu
1. Choose Consolidation
® Data matrix ® Change.2. On the tab strip in the following dialog box, choose Optional characteristics and select the appropriate characteristic.
3. Enter one of the following in the Value/Value reference field.
– A single value
If the ID of the single value is identical to a possible cell coordinate, for example a transaction type with the ID B10, you need to enter the value preceded by an apostrophe, for example, B10 .
– A cell reference, for example, B3
– A cell reference, by clicking on the button to the right of the entry field
A dialog box appears. When you drag the cursor over the appropriate matrix area on the worksheet, its coordinates appear in the dialog box field. Use the function button next to the co-ordinate field in order to confirm your entry.
4. Choose Confirm, to complete your selection.
5. Once you have specified all values and value references, choose OK.
If a required characteristic has not yet been defined, a warning message appears. In this case, choose Consolidation ® Data matrix ® Change and define the appropriate characteristics on the Reqd char. tab strip. Then choose OK.
Procedure when Using Context Menu
Result
Cell Reference
An assignment is created between a characteristic on the worksheet and a characteristic preset in Interactive Excel. The cell reference of a characteristic is automatically adjusted if you move the characteristic to a different location on the sheet.
Single Value
The characteristic is invisible on the sheet, as is the case for all constants.