connecting structures result

[Former Member]

Hello,

I have a report with a structure in the rows.

I would like to display in the first column the result of the row multiply by 2 and in the second column the result multiply by 3.

How can I do it? I tried to use another structure but I couldn’t find how to connect the two structures.

Please Help,

David

[Former Member · Accepted solution]

Hi David,

It sounds like you need to use cell definitions to complete your requirement. It's useful when using two structures within a query.

SAP Help describes the process.

http://help.sap.com/saphelp_nw04s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Good luck!

[former_member188325]

possible to provide an exapmle?

[Former Member]

For example a query with the following structure:

in the first row I restrict the data for cost center 12345 and key figure amount

in the second row I restrict the data for cost center 98765 and key figure amount.

In the first columns I would like to display the result * 2 and in the second column the result * 3.

For example If the result of the first row is X and the result of the second row is Y I would like to the report:

Row1 2X 3X

Row2 2Y 3Y

[Former Member]

If its always gonna be 1st column x 2 and 2ndcloumnx3.. why dont you use a formula to multiply 1st column with 2 and hide the 1st column.