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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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