Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hello @marcus_sommer ,
I tried your solution and this gives me the display expected.
Thanks a lot for your help!!