Need help for Reporting

Dear all,

This my team's first time working with BPC 10, we are trying to make some reports where users need to calculate the unit amount of different concepts (All P&L concepts/Sales Volume). Below the report image that user provided as requirement:

We would like to keep the calculation of unit amount with worksheet logic due we don't need to save the data as result of calculation. But it looks like it's not working as we expect: If we choose another hierarchy of Account dimension, everything is refreshed and text =#REF! is displayed in cells. As we can see in image below:

Do you have any suggestion for setting this calculation succesfully?

Thanks a lot for you help & Regards