Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Ronald,
Its an application on my client machine. n i do not have access to copy it to any different environment
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
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 $$$"