Dummy Header in Pivot Table

[SaiPranathiG]

Hello,

I had a requirement to add dummy headers in Pivot table.

For 1st 2 Columns(A,B) header should be H1, and last for last 3, Header should be H2.

	H1		H2
	A	B	C	D	E
MM	1	6	2	9	10
bb	2	2	5	9	4
cc	3	5	6	8	6
DD	4	8	8	0	1
ee	5	9	3	1	0

How can this be achieved?

TIA

[MayilVahanan]

Hi

You can bring new field for this.

If(Match(Field, 'A', 'B'), 'H1', 'H2') as NewField

And use that new field in the Pivot table.

[SaiPranathiG]

iam not using direct fields, A Column is mixed calculation of 2 different fields.

similarly other columns are also using the same fields

[brunobertels]

creates field with valuelist function 

valuelist('H1','H2')

then add mesures 

A= 

if(valuelist('H1','H2')='H1', mesureA)

B= 

if(valuelist('H1','H2')='H1', mesureB)

C= 

if(valuelist('H1','H2')='H2', mesureC)

etc 

[SaiPranathiG]

measures which not relevant to headers are getting blank values and im unable to hide them