View Single Post
 
Old 11-15-2022, 04:03 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 674
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

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.
Attached Files
File Type: xlsx msofficeforums49985Book12b.xlsx (27.7 KB, 3 views)
Reply With Quote