Modify only the label of the expression in a Pivot Table

[Black_Hole]

Hello all,

I use an expression in a pivot table.

The result of the expression is displayed in the header of the pivot table. I like this displaying and I would like to keep it.

I would like to modify the label of the column with the expression.

But, when I try to modify the label automatically I lose the result of my expression which was displayed in the header of my table.

Please could you tell me if I can keep the displaying of my header on one side and on the other side to modify only the name of the column with the expression.

Below a screenshot to illustrate my pivot table:

Thank you in advance for your help.

[marcus_sommer · Accepted solution]

You could put both within the label, like:

= 'MyLabel' & chr(10) & '=MyExpression'

If I need to supply some info over the used expression or to provide a bit more context I use usually the comment-area of the expression/dimension. This keeps the labels neatly and if a user want to know more he/she could hoover on the label to see this extra information.

- Marcus

[Black_Hole]

Hello @marcus_sommer ,

I tried your solution and this gives me the display expected.

Thanks a lot for your help!!