Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
iam not using direct fields, A Column is mixed calculation of 2 different fields.
similarly other columns are also using the same fields
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
measures which not relevant to headers are getting blank values and im unable to hide them