Wrong Pivot Table Values

[miguelbraga]

Hi community,

I have a new problem in my dashboard, when I enable the "Show Partial Sums" in the Presentation Tab in my Chart Properties, I get a wrong value. In the snapshot bellow you can see it clearly that there is something wrong with the value:

My dimensions are:

• [Zona]
• [CodLocal] labeled as [Cod. Local]
• [CodEmpregado] labeled as [Cod. Funcionário]

My expressions are:

• =sum(CustoReal) -> labeled as [€ Custo Real]
• =sum(CustoReal)*num(sum({$<Zona=, CodLocal=, CodEmpregado=, data= >} DISTINCT Imputacao%)) -> labeled as [Imputação]

The [Imputacao%] values table:

What is the changes that I need to make to get the correct output result (1 316,41 €) for the totals of [Imputação] and (3 949,22 €)?

Can you experts help me? hic‌gwassenaar‌sunindia‌jontydkpi‌ can you help me? Anyone?

If anyone needs further more explanation, please ask it in the comment section bellow.

Regards,

MB

[miguelbraga · Accepted solution]

This was the solution that I could by myself get:

With the expressions be like:

• %Imputação -> =Sum(Imputacao%)
• € Imputação -> =Sum(Aggr(((tempo*1440)/60)*(ValorHora)*(Imputacao%), Zona, CodLocal, [CodEmpregado], [DataHora], [Saída]))
• € Custo Real -> =Sum(Aggr(((tempo*1440)/60)*(ValorHora), Zona, CodLocal, [CodEmpregado], [DataHora], [Saída]))

Hope someone find a similar problem in the future and that this answers may give you a similar solution. Have fun and good job people