How do I get two pivot table column headers on same row?

[JohnF123]

I have a pivot table that uses custom subtotals to generate YTD and Average to Date columns. The problem is that those column headers are on a different row from the Dates column headers and I'd like to know if there is a way to combine the column headers into one row?
I'm attaching a sample workbook which further illustrates what I'm trying to accomplish.

As always your help is greatly appreciated

John

 

[jeffreyweir]

Hi John. You can't do this without some faking. Your only option is probably to snap four individual rectangle shapes to the grid in cells E9:E10 & J9:J10, make them the same color as your Pivot, and manually write in them the headings you want.

 

[JohnF123]

Hmm...That's what I thought. Thanks Jeffrey, I'll just have to keep it the way it is then.

 

[jeffreyweir]

Here's an example. I made the shape transparent, and made the text in the shape reference the cell above, so it's completely dynamic. Then I hid the extra row.

 

[JohnF123]

Thanks, but unfortunately when I select additional months and the pivot table expands the shape does not move when the table expands

 

[jeffreyweir]

Ah yes, forgot about that. You could address that with some code fairly easily. But if this is just to get around a minor irritation then it's probably not worth it.