Group label for pivot table expressions

[#1]

My need :

I have a pivot table with many many expressions.

Those expressions could be grouped by big categories.

I would like to set a label for each categories on top of each expression label.

It would look like this :

	group 1		group 2
	expr 1	expr 2	expr 3	expr 4
Dimension 1	value	value	value	value
Dimension 2	value	value	value	value
Dimension 3	value	value	value	value

I nedd that presentation in an Excel export based on this pivot table.

I haven't find any evident solution, so if someone as THE killer trick for that, i would be very grateful !

[#2]

I'm not sure there is any easy way to do this

Extending pivot table sub-total labels over several columns

[ashfaq_haseeb · Accepted solution]

Hi,

This is not possible directly.

there can be work around to play with text objects.

Regards

ASHFAQ