You basically need to add:
   pt.DataPivotField.Orientation = xlColumnField
after adding the data fields.