Split same value into the sum

[pgalvezt]

Hello,

I have many salesman,

How could sum the same salesman in 2 groups separately.

If(Vendor1='a','a',

If(Vendor1='a','b',

If(Vendor2='b','b',

If(Vendor3='c','b',

If(Vendor4='d','b',

When I do the statement vendor 1 dissapear

I want that my pivot show

The total in b

and the total a

Final Result

158.539.379

Thanks!

[pgalvezt]

Gave the same result that pivot table...