Howdy. Yes, that can be done, but it takes a little to do this and moving elements around. Will you be doing this frequently? The reason I ask is that this can be done much more efficiently using VBA to construct the Pivot tables, and then you have much greater flexibility in working with the data as well as formatting. And if changes need to be made, they can be made faster using this approach. Check out Chapter 12 of the book VBA and Macros for MS Excel by Bill Jelen (Mr Excel) and Tracy Syrstad. Superb book, and they give actual code to accomplish most of the difficult work.
old, slow, and confused
but at least I'm inconsistent!