Splitting up data in a pivot table

[Brooks Barlow]

Ok so I am trying to create a pivot table with commission amounts and the producer totals. Some of the commissions are split between two producers. They are entered in in the format name1/name 2. How could I get the pivot table to add half of the total to each name?

 

[Alex Plantema]

Brooks Barlow schreef in

Ok so I am trying to create a pivot table with commission amounts and
the producer totals. Some of the commissions are split between two
producers. They are entered in in the format name1/name 2. How could
I get the pivot table to add half of the total to each name?

That's not possible. You will have to split these lines before creating a pivot table.