Problem with totals in table

[#1]

Hi, I have this problem:

I calcule "Sueldo hora" with "Sueldo Mes"/"Total Horas", but I have two "Proyectos" I can filter, P1 and P2. When I filter by a proyect, I have:

In the last column I want to have (10*30)+(15*50)=1050, and I have 1000.

Someone can help me? I send the file attached.

Thanks.

[Frank_Hartmann]

have a look at the attached file,

chart properties-->Expressions-->TotalMode-->sum of rows

cheers

[#3]

Hi,

Since you're using a straight table, you could sum up the rows as Frank suggested.

If you want to use a pivot, you'd need to aggregate by Recurso, just modify your expression as:

sum(aggr(

Sum(Horas)*(sum(Sueldo)/12)*count(distinct(Mes))/Sum({<Proyecto=>}Horas)

, Recurso))