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...