Formatting pivot table dissapears when collapsed

[#1]

I have this problem with formatting a pivot table, when I collapse a part of the pivot table, the format of the expression values dissapears.

I used the text format property on the dimension ( '<B>')

[rwunderlich · Accepted solution]

Interesting. I never noticed that before. When a group is collapsed, the expression total loses it's bolding. You can work around it by using a conditional Text Format in your expression.

=if(Dimensionality()=1, '<B>')

-Rob

[#3]

It works! Amazing. Thank you very much.