Bold formatting in table chart

[#1]

I want to make some of the rows bold in my table. I started with one of the dimensions and clicked Text Format and entered my condition:

=if(LINETYPE='HEADER' or LINETYPE='SUM', '<B>')

But only the rows with LINETYPE=SUM shows in bold. I can't understand why this is.

[anbu1984]

May be because of spaces

=if(Trim(LINETYPE)='HEADER' or LINETYPE='SUM', '<B>')

[#3]

Still no change

[its_anandrjs]

Try this also

=if(Match( LINETYPE, 'HEADER','SUM') , '<B>')

[anbu1984]

Is your data (LINETYPE='HEADER') is in upper case?

Try this

=if(Index(LINETYPE,'HEADER') or LINETYPE='SUM', '<B>')

[#6]

None of these seem to work. At first i thought it was because these lines have the value 0 in the expression so I created another expression which gave a value other than 0. But that didn't help.

[ashfaq_haseeb]

Hi,

Can you post sample app to look over?

Regards

ASHFAQ

[#8]

there's a lot of company sensitive data so I can't. I'm sorry.

[its_anandrjs]

If possible any sort line sample test data is Ok to find out the problem you can change names and hide any sensitive data from others.

Regards

Anand

[ashfaq_haseeb]

Check this

Preparing examples for Upload - Reduction and Data Scrambling

Regards

ASHFAQ