Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a Pivot table... wherever there is a zero I want to replace it with blank.
Is it possible and if yes then how??
Regards
Hi Rohita,
This is possible. If you want to replace zeros by a null(blank spaces are known as null), you just need to write a chart expression. The expression is like this.
if(field=0,' ',fieldvalue)
in this expression field represents that field which you want to check where there are any 0's in it. if you give this expression in your chart then I hope your problem will be solved. hope this helps you...
Thanks and regards
Joseph
Thanks a lot Joseph 🙂
It worked!!