I don't want to display (blank) in Pivot. How??

Question

Hi Team,

 

when i put Pivot to one table where ever no value there i get (blank), so is there any way to avoid and i dont want to submit by showing like that so is there any general settings which i have to change or any other ways...

 

Please suggest me and thanks in advance..

 

Regards,

 

Chandra sekhar

---

Thanks & Regards, Chandra

Answer 1

Select any cell in Pivot Table->Right Click ->PivotTable Options->For Empty Cells Show->Give the desired string in the box->Ok

This will help if you want it for Value area.

Answer 2

sorry, it is working can u please briefly explain...

---

Thanks & Regards, Chandra