accomulation in pivot table

[francis_gr]

Hi!, In my example I´m trying to calculate total value (sum) from 3 fields (expresions)

two of then ("limite" and "dispuesto") are ok but not for "saldo pasivo"

If you make a selection for "empleado" field, you can see that it is not correct .

For example:

for empleado 1 show 1507 when the real data is 569

for empleado 2 it`s ok.

for empleado 3 show 1389. The correct data is 732 (657+75)

How can i solve the problem?

regards

[#2 · Accepted solution]

Do you want:

SUM(distinct [Saldo Pasivo (*)])

That gets all the answers you are looking for.

I'm sure that's not what you're going for. Why don't you want to count the repeated values in the total? Empleado 3 says 657+657+75. You are probably going to need to use the Aggr() function, but I can't figure out how to use it within your data set.