How to format a Pivot Table column based on a dimension

[#1]

Hi there,

Anybody know how to set a bold format to a text in a pivot table column based on a dimension. I'm traying to do it using a expression but I haven't found out yet how I could do it.

Thanks for your help.

r.m.

[johnw]

For the text format for your dimension, enter something like this:

=if(Employee='Bob','<b>')

[#3]

Thank you John.

I have another question. How could you set format (to the background or to the text) to a column header based on a expression and a dimension.

Thanks again.

[johnw]

If I understand the question, I don't think you can do it. The column header picks up the formatting from the first row of the table when you use expressions to control formatting. I consider that a poor design decision on the part of the developers, but that's what we're stuck with for now.