Pivot table magic

[bill_ball]

i want to see NA in all cells where data is empty in pivot table. I
possible without vba?

thanks in advanc

 

[trip_to_tokyo]

EXCEL 2007

Right click somewhere inside the Pivot Table and click on PivotTable Options
.. . .

PivotTable Options window should launch

Layout & Format tab / in here there is a box called:-

For empty cells show:

Place NA in the above cell.

I think that the above should give you what you want.

If you agree please hit Yes.

Thanks.