none
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
    Tuesday, November 29, 2011 11:10 AM

Answers

  • 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.

    Wednesday, November 30, 2011 8:03 AM
    Answerer

All replies

  • 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.

    Wednesday, November 30, 2011 8:03 AM
    Answerer
  • sorry, it is working can u please briefly explain...
    Thanks & Regards, Chandra
    Wednesday, December 14, 2011 8:37 AM