Display Minimum and Average values

Hi Guys,

In my scenario, I have a department and sub departments. I need to display the min, max and avg of a particular keyfigure for each of the departments. The keyfigure has a value for each of the sub-depts and I need to take the min of all the values of the sub-depts that fall under the dept.

Greatly appreciate your help.

Doniv