Hello Ravi, I am not too sure if this will work for you but still try the following
Go to your datasheet highlight the last row that has data and insert a new row above the last row of Pivot Table Data. Enter the values in this new row go back to your Pivot table and refresh i think you will get to see what you want to see.
Let me know if thats what you wanted.
Thanks/VKS