I don't think you can do anything outside of NS gracefully with pivot tables. I know that exporting them is one of the top requests, but I've found them to be great in theory, but lacking in execution. "Soon" has been the response for quite a while.