Cell editor in Structures

[Former Member]

Hi,

Is there anyway we can combine two cell in the cell editor feature.

For example i have total that iam calculating as a separate formula and the individual values are coming from another key figure.

I want it to display in one row with individual values and the total coming from the formula.

I would really appreciate a solution to this problem.

Thanks

Vrinda

[Former Member]

It is only possible when you use structures in the report, use selections to create both individuals and formula for totals. Then define the key figure to use formula individual and total separately.

[Former Member]

hi Vrinda,

not sure whether it gonna work or not. just try creating a key figure of required type and add it to the infoprovider but don't fill it with anything.

now in the query designer add it to the column or row accordingly and fill it with cell editor as the sum of other column values to get the other key figure values and the total in one row.

let me know if this works.