Skip to Content
avatar image
Former Member

Aggregated Values in Report

Hi Experts,

I have a BEx query on top of infoset. A DSO is assigned to the infoset, what i want in the output is i need total gross margin based on sales order number, i tried with exception aggregation on sales order number it is giving me the values on line item wise which i don't need , i need the gross margin values at the total sales order number level.

Example:

Sales Order Number line item value Gross margin at sales order level

123 10 70 41.1%

123 20 100 58.8%

But it is displaying like below when i give exception aggregation.

Sales Order Number line item value Gross margin at sales order level

123 10 70 70

123 20 100 100

Any inputs are highly appreciated.

Thanks,

C.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 27, 2017 at 09:08 AM

    Hi,

    could you try this

    formula: % CT 'KeyFigure'

    worked for me

    Add comment
    10|10000 characters needed characters exceeded