Text format in pivot table

[Anonymous]

Hi,

I want to change the text format in a pivot table into bold.  What I see is that the text only turns into bold when there is data in the first line under the text. Any idea as to what might be causing this ?

[sunny_talwar]

Can you try unchecking 'Suppress Zero Values' on the presentation tab?

[Anonymous]

Hi Sunny,

Thanks for your reply.

This is something I have tested before, but I want to avoid it, because the end users want to see only rows where there is at least one value that is greater than zero.  The rest is just overhead.

[Anonymous]

Hi Filip,

You can do it with cell format.

1. Show design grid
2. Right clic on object and select custom format cell

Regards!

[sunny_talwar]

Would you be able to share a sample to play around with?

[Anonymous]

Hi Sunny,

I have attached an example.

Regards,

Filip

[sunny_talwar · Accepted solution]

Try this expression:

=If(Sum(TOTAL <Operation> LocationInv) > 0 and Sum(TOTAL <ProductNr> LocationInv) > 0, Dual(Alt(If(Sum(LocationInv) > 0, Sum(LocationInv)), '- -'), If(Sum(LocationInv) = 0, 0.01, Sum(LocationInv))))

[Anonymous]

Hi Sunny,

Works perfectly.  Thanks for your help.

Regards,

Filip

[sunny_talwar]

Not a problem my friend