Sum Same value in same pivot

[pgalvezt]

Hello,

I am creating several subgroups of sellers .. with if statements ... but when I put the same seller in another subgroup only considers me one ... apparently QlikView takes the seller repeated and shows only 1 time ... There is a way tells QlikView that adds the same seller 2 times in the same pivot table?

Salesman 1 (Only 1 sales man)

Salesman 2 (4 Salesman ... Salesman1 plus another 3)

Finally

Qlikview shows me this:

Salesman1 = 58.054.886 (OK)

Salesman2 = 42.429.607 (not Ok should be 100.484.493) Here salesman1 dissapear.

Total sum 158.539.379 (What I want)

Total sum 100.484.493 (I get this in qlikview)

I attached a qvw file and excel with what I want.

Hope you undertand the problem...

Thanks!!

[pgalvezt]

So,

If I want to add another line. I would have to concatenate another load with differents names, right?

Thank you for your help Michael...

[Anonymous]

In general - yes, but there is no need to reload all every time.  See another example, a little cleaner...