Skip to Content
avatar image
Former Member

Cell editor in Structures

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 20, 2010 at 06:33 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 09:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded