Bold Text format for dim & Exp not working for null or zero values

[poojask123]

Hi,

I have a Pivot table with 4 dimensions and one measure.

For both these, i have provided text format to display as bold '<B>' with the condition -

if(Region= 'Total','<B>')

But wherever the expression value is zero or Null, the bold does not work, and it shows in normal font.

I am expecting a result like this, but the result i am getting is - For Column A, wherever there is 0 or null, the value is not bold but normal format.

Thanks

[poojask123]

Hi Ronald,

Its an application on my client machine. n i do not have access to copy it to any different environment

[Anil_Babu_Samineni]

In fact, Your information is not good enough because as per your Data set it's working good. So finally, I would ask you to create sample data which is same where not working. Si that we can look the same

[poojask123]

Thanks Ronald. I decided to go by your suggestion to achieve what I am trying. Restricted the dimension values using match() and named the total column as "Gross $$$"