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..
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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?