BEx Exception Aggregation

[Former Member]

Dear All,

We have a set of data as shown given below.

We are performing reporting on Sales order header level, there is no item level  reporting.

Result should be displayed as given below.

We have tried with Average exception aggregation,, it didn't work with reference to Order Number.

We have tried with max value exception aggregation,, it didn't work with reference to Order Number.

Is there any other work around to get the proper result as shown in the second screen shot.

[Former Member · Accepted solution]

Hi,

Try average exception aggregation with reference to Order Item.

Thumb rule in exception agg: the exception aggregation has no effect when the reference characteristic is in the drilldown. When you do exception agg with Order Number as the ref, and also keep Order Number in the drilldown, the exception agg is ignored except in the "Result" total rows.

Regards,

Suhas