Hi,

You need to Refresh the pivot table by clicking the '!' button on the pivot
table toolbar. This will help to display the new item.

-Biman.

"Samad" wrote:

I want to get item wise balance in Pivot Table, I tried to enter formula in
pivot table and it works but whenever the new item inserted it does not
show,
and I have to copy formula for each item,
can anyone help me

Thanks