Aggregated Values in Report

[e_c]

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.

[kohesco]

Hi,

could you try this

formula: % CT 'KeyFigure'

worked for me