Hi Mates, How to calculate Avg based on Levels, But Analysis server is doing normal avg. But I want Avg on Avg. for example I have an Employee Hieararchiye by Levels (CTO, PM, PL, TL, TM) I have daily data of lunch time taken by each employee. Note: Lunch Hrs and Day Present are Different Measures. DayPresent Measure is created by No of Rows Formula Fact Table Design Date EmployeeId LunchHrs LEVEL 5 TM1 = Feb Hrs / Days Present in Feb TM2 = Feb Hrs / Days Present in Feb TM3 = Feb Hrs / Days Present in Feb (if this value is =NULL, should not be considered in Level 4) LEVEL 4 When I calculate Avg Lunch Time taken By TL1 in February TL1 = Feb Hrs / Days Present in Feb TL1 = (TL1 + TM1 + TM2) /3 (TM values should be from Level 5) Note: TM3 not considered here, since value is NULL LEVEL 3 PL in February = PL1 = Feb Hrs / Days Present in Feb PL1 = (PL1 + TL1 + TL2) / 3 (TL values should be from Level 4) ... up to LEVE 1 How to resolve this issue. I am just a beginner in Analysis service. Thanks in Advance.