Using UI Automation you can create pivot by
selecting the data to make pivot using 'select range' activity. Then using send hotkey, pass Alt+N+V+T (Will open the pivot dialog box) Now, select the row,column etc again by using find element or find image and drag and drop to required fields.
The Drag and drop can be done by using a combination of'click up' and 'click down' property in click activity.
Hope this helps