Neither of the current connectors have this capability out-of-the-box. It is possible to do with a C# script though. It would certainly require some programming experience though. You can search for "C# Excel interop pivot table" and find some helpful code examples. You could use the Script component to write that code and have your automation call it.