Pivot table

[Anonymous]

Hi,

I have list of iD (pivot table), where I show TOTAL and if field "TC" has data or no.

I wrote an expression. For some of them works, for other not.

I'd like to show, if empty cell -No (red and bold), if not empty-Yes (black and regular). It should ignore calendar.

Please see attached file.

Thanks,

[#2]

Try:

[#3 · Accepted solution]

Attached example.

[#4]

Also, for the formatting, use:

Text Color:  if(TC = 'No', rgb(255,0,0), rgb(0,0,0))

Text Format:  if(TC = 'No', '<B>')

[Anonymous]

Thanks guys for your help.