Recalculate the KF values in the result column

Hello BW Experts,

I have a score calculated per material.

row: material group, material

column: score (there is a formula)

Result material groupwise: average for the materials present in the materialgroup.

here the score is calculated for each material in the row. But now the user wants to calculate the scores to be calculated in the material group level and not just average values of the scores of the material.

Any suggestions if this possible.?

Any ideas appreciated.

Thanks,

BWer