Roll up in essbase ASO

Summary

Roll up in essbase ASO

Content

Hi All,

I am trying this:

YR2014 Actual sales

Jan     100

Feb     200

mar     300

Q1     600

YR2014 Actualx sales

Jan     100

Feb     700

mar     800

Q1     1600

I have created new scenario with below formula/logic

ActualExp

if (year = YR2014 and month mar)

then

ActualX

else

Actual

I am getting the below result

YR2014 ActualExp sales

Jan     100

Feb     200

mar     800

Q1     600

I am not getting the final roll up value for Q1

the required output is this

YR2014 Actual sales

Jan     100

Feb     200

mar     800

Q1     1100

Please help. I have tried aggregating Databse also used solve order for scenarios but still didnt get what is missing.