Background color for null values in pivot table

[dineshraj]

Hi all,

I need to give specific color for null values in pivot table. I tried all methods given in previous queries none on them is working.

I have two dimensions in rows one dimension in column and one measure.

can anyone suggest new idea?

Thanks in advance

[poojask123]

Hi Dinesh,

Did you find a solution for this ? I am stuck with a similar requirement. Please help.

Thanks

[d44973694]

Did you try replacing null values of the measure with 0 ? you can do it by alt(measure,0).