Cant format correctly a Pivottable

Hi,

I'm struggling to format my Pivottable the way I want. Eventually it should look like a quote but the problem is that formatting the subrow header of the table also changes one of the columns.

It's most likely easier to understand with a picture

Here is what I have at the moment : Untitled.png
Here is what I want : Untitled1.png

This is a sample Excel file : Formatting PivotTable.xlsx

It is so simple, I can't believe it is a bug of Excel!

Thanks in advance for the help.

Please check the attached with required formating

Thank you for your answer KrisSquare. It does the trick however I obvisouly forgot to specify an important element

I'm generating the PivotTable "on the fly" via VBA and the size of the table is not fixed.
It is thus not possible to customize it by hand : I need to define a PivotTable style that works all the time (and eases the reading of the table).

Any idea? Even with VBA?

Thanks for the answer.

It should be possible to loop through the rows of the PivotTable and check if the source name is "Area".
If yes, then change the color of the row.

I'm at the moment struggling translating that in VBA. Any help is welcome!

Okay...

Although it is not completely tested, I think I finally found a very simple solution (colors are to be changed) :

Please Login or Register  to view this content.

Thanks for the support!