I found there are some properties in expression of the pivot table:Background Color,Text Color, Text Format and so on.
I know how to set color like Red(), but how to make the Text be bold? Which function I should use?
As mentioned by Anita, you can use '<b> <i> <u>' for Bold, Italic and Underlined. You need to specify these settings under Text Format option under the expression. This can be conditional and you can control the format for specific cells. I am attaching the screenshot for you reference.
Also, you can use the Custom Format for Pivot Table by right clicking on the Pivot Table. You can control the formatting here. But you need enable the Custom formatting from User Preference Settings. I have attached the screenshot for you reference.
I hope this helps!
Cheers - DV
I don't think it support all the HTML tags. Which chart object are you using? Have you considered using "Alignment" under "Presentation" tab? If you need format a specific field value then you use something as below :
Repeat(CHR(32), 10) & COUNT(CustomerKey) & Repeat(CHR(32), 10)
This is not a clean solution but it still works. Please provide sample app if this doesn't help.
This also doesnt work . i have a combo chart wit bar and line . Bar represent the months and line is mapped to dates.
There is no alignment option under presentation tab and month is an expression which has 'plot values inside segmnets' ticked. if u can see the months are left aligned