You can't, as far as I know: you can export the data but the pivot table view stays behind.
Your best option is to export the data to Excel, and build the pivot there, or just go to Excel and directly build a pivot table with an external data source based on the table / query.
Denis