I would put the comments with the source data, then include the comments in the pivot. See attached. The comments will remain associated (move) with the data on refreshing.
re:"Also I have formula below that table that Total Value Less Diff Value, So this will stay as it is or I have to Add when refresh data?"
I see no Diff Value anywhere! Attach a file where we can see this calculation. It's likely, that if the Diff Value is in the source data, it too can also be included in the pivot table.
|