Changing expresions Style

[#1]

Dear Guru,

I need to change the Labels style in my pivot table based on an expresion. So I put the expresion in the Text Color and Text Format (Grey and Italic) in the popup menu. It work fine, but if the first data line is changed, the labels of the expresion column change also.

How can I do That without affecting the labels of my expresions?

Thanks in advance,

Patrick

[#2 · Accepted solution]

Hi Patrick,

I faced the same issue earlier in my previous assignment and what I did is,

I added a partial sum for the very first dimention and set the option to show total on top.

then modified the expressions to check the dimensionality and calculate accordingly.

You can also try the same. I am sure this will help you.

Thanks & Best Regards,

Kuldeep Tak

[#3]

Thanks Kuldeep, it works. Good tip.

Patrick