hi, I have a pivot table as following
I want to remove the column header [Value].
The final expected outcome should be something like this
How could I do it?
This is the setting of pivot-table
I want to remove the column header [Value].
The final expected outcome should be something like this
How could I do it?
This is the setting of pivot-table
Select the pivot table → go to properties → pivot options → toggle single metric
Let me know if this helps.
Dom
My apologies, I didn’t see that you have multiple columns in the value section so single metric wont work. I currently do not know of a way to hide that with multiple fields.
Np. Thanks for your help.
1 Like
When I have only 1 field in the Value section, the pivot table showing exactly what I want to see.
But when I have 2 fields, 1 showed and 1 hidden. The redundant row header showed up.
Any suggestion?
My hidden field in Value section is for serving as conditional format. But I found out I can use conditional format for displayed field with off-visual field. So, I can now add only 1 field in Value section and have the column header removed with the setting for single metric = on
1 Like