Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
gf
Creator III
Creator III

Text format on pivot table doesn't work

Hello all, 

I have a strange problem. I have a pivot table where I want to display some cells bold.

The problem is, it doesn't matter if i try it with a condition ( IF(myColumn='xxx','<B>') ) or with all the values (='<B'>) in a column.

The columns where I want to set cells bold come from a LOAD where i use a CONCATENATE.

Did I miss to set a specific option or something?

The strange thing is, in the same project, different tab, I have a pivot table where I use a conditional format text like =IF(Wildmatch(myColumn,'*xxx*'),'<I>') and this works perfectly.

Thanks in advance!

 

Regards 

Gf

Labels (1)
14 Replies
gf
Creator III
Creator III
Author

or is it possible to format text to bold inLOAD?
gf
Creator III
Creator III
Author

i still could not find a solution for this problem... is it a bug or something?
Surya
Creator II
Creator II

PFA

gf
Creator III
Creator III
Author

Still no changes....bold111.PNG

gf
Creator III
Creator III
Author

I changed the diagram to straight table, know it works....
I don't know why but it works.