hi All

I have a power pivot table called PivotTable3 in Sheet1. Is there a way to write a VBA code to add field in the table. I have the fields Name, Surname, Age, gender and I want the code to add Name and surname and remove Age and Gender.

Is this possible?

Thanks for you help in advance