In that case we can use invoke code activity and insert vb code to create pivot table and also we can perform sum values for multiple column and also format the data. Please have view on below my post it is having sample vb code to create pivot table in excel. I hope it might helpful for your requirement. Thanks.