accomulation in pivot table

francis_gr — Fri, 17 Dec 2010 21:50:31 GMT

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

accomulation in pivot table

Fri, 17 Dec 2010 22:18:40 GMT

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.

topic accomulation in pivot table in QlikView

accomulation in pivot table

accomulation in pivot table