How to use set analysis? Cost per hour consultant

[#1]

Hi,

I need to calculate the cost per hour for an consultant.

The cost per hour will be: (Total Cost / Total worked hours)

But I also need the cost per client A:

The cost for cliente A: (Total Cost / Total worked hours) * Total worked hours for client A

I have in total 10 clients, but when I try to calculate for 1 client the cost per client is incorrect.

I will aprecciate if someone can help me.

Best regards!

[#2]

May be a straight table can be used.

Dimension - Client

Expression - (Total Sum(Cost)/ Total sum(Worked Hours))* sum(Worked Hours)