Pivot - Help in aging report

[Krishnab4u]

Dear All,
I am working on aging report of vehicle stock. When some vehicles are received only today, then aging will be Zero. Formula is used is Today()-Received Date. Similarly number of days range from Zero till 300 days.
When I make pivot table, i am not able find Zero number of days in the column.
Please help.

Thank You.

 

[sandy666]

maybe look at Options - Advanced - (Display options for this worksheet) - Show a zero in cells that have zero value (checked)