Hi vasu,
i think you can activate "cell restriction" and there you can do the modifications according to ur requirement.
Just go throw the below decription to creat the cell.
In the Query Designer, choose View ® Cells from the menu bar to reach the functions of the cell definition. The Cells screen area is displayed.
New selection
...
1. Select a cell in the Cell screen area and choose New Selection with the secondary mouse button. The new selection that is not yet defined appears in the cell.
2. Select the new selection and choose Edit from the context menu. The Change Selection Cells dialog box appears. Make the basic settings on the General tab page.
3. Use Drag&Drop to define your required selection by dragging a key figure and the characteristic values by which you want to restrict the key figure to the right-hand area of the Details of the Selection dialog box. See Defining Selections.
You can use characteristic value variables instead of fixed characteristic values.
- If you want to change an existing variable, select the variable and choose Edit from the context menu. The variables editor appears and you can change the settings.
- If you want to define a new variable, select the characteristic value and choose New Variable from the context menu. The new variable is displayed. Choose Edit from the context menu of the new variable. The variables editor appears and you can define the settings.
For more information, see Defining Variables.
4. Enter a description for the selection.
You can use text variables in the description.
5. Make any necessary settings for the properties of the selection on the other tab pages. See Selection/Formula Properties.
6. Choose OK. The cell contains the description of the selection. The symbol shows you that a selection exists for this exception cell.
New formula
...
1. Select a cell in the Cell Definition dialog box and, using the secondary mouse button, choose New Formula from the context menu. The new formula that is not yet defined appears in the cell.
2. Select the new formula and choose Edit from the context menu. The Change Formula Cell dialog box appears. Make the basic settings on the General tab page.
3. Define your formula using the operands and functions available. See Defining Formulas.
4. Enter a description of the formula.
You can use text variables in the description.
5. Make any necessary settings for the properties of the formula in the other tab pages. See Selection/Formula Properties.
6. Choose OK. The cell contains the description of the formula. The symbol shows you that a formula exists for this exception cell.
New cell reference
You can use any cell that you define in a formula. If you want to reuse the value from the implicit, generic cell definition that is automatically created at the intersection of the two structural components of a query, select this cell in the Cell screen area and, using the secondary mouse button, choose New Cell Reference. A description taken from the two structural components now automatically appears in the cell. The symbol shows you that a cell reference exists for this exception cell. Now you can reference this cell. You can continue to use the implicit cell definition and do not have to manually generate this value using a new selection.
Functions of explicitly defined cells:
Select a defined cell and choose the required function from the context menu (secondary mouse button).
● Edit
● Cut
● Copy
● Paste
● Remove
● Where-Used List
Before you delete a cell, you can check for the formulas in which the defined cell is used in the where-used list.
You reach the properties of a defined cell by selecting the defined cell. In the Properties screen area you can also make changes such as:
● Changing the description of the cell
● Changing the highlighting of the cell
● Hiding the cell ( if you do not want to see the values of the cell)
Help cells
In the Help Cells area you can define additional cells for help selections or help formulas. You can use the functions New Selection and New Formula in the context menu to define help cells that are not displayed in the query to serve only as objects for help selections and help formulas.
For example, you can define an invoice in a help cell and use this in a “real” cell to calculate a duplicated invoice.
...
a. Using the secondary mouse button, click on the empty cell next to Help Cells to reach the context menu. From here, choose New Selection.
b. Use Drag&Drop to drag the Invoice key figure into the right-hand Details of the Selection area.
c. Enter a description.
d. Choose OK. The cell contains the description of the selection. The symbol shows you that a selection exists for this exception cell.
e. Now choose New Formula from the context menu of the required cell of the query. The new formula that is not yet defined appears in the cell.
f. Select the new formula and choose Edit from the context menu.
g. Use Drag&Drop to drag the cell you have just defined, which you can find in the Available Operands window under Cells, into the Detail View window. Click on the button twice.
h. Enter a description.
i. Choose OK. The cell contains the description of the formula. The symbol shows you that a formula exists for this exception cell.
Result
You have defined one or more exception cells for a query.
Regards,
Shailaja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.