in a pivot table i would like to capture the subtotal of a person based on if the the slicer name is the same as the column name

if the slicer name = column name then retrieve that subtotal of that person.....how can I go about achieving this in vba in a particular cell?

thanks.