How to Apply Background Color for Empty Fields in Pivot Table

[hariprasadqv]

Hi All,

How can we Apply Background color for Empty Cells in Pivot Table. cell's may contain Text or Numaric value.

Thanks in Advance

[sunny_talwar]

May be using this kind of logic:

If(Len(Trim(YourExpression)) = 0, BackGroundColor, OtherColorWhereThereIsValue)

[jsingh71]

if you want to do like below :

then see the attached qvw.

[Anonymous]

Hi Hari,

Please have a look:

Pivot table background color in cells with no data

Hope it helps!!

[kkkumar82]

Hi,

Hi for the expression in the expressions tab (properties) click ' + ' and you get a tree , there you select the background

and a condition if(isnull(expression), rgb1(n1,n2,n3),rgb1(n1,n2,n3))

Thanks

Kiran Kumar

[kkkumar82]

Hi,

Sorry for forgetting the same you can find for Dimensions also.

Thanks

Kiran Kumar