Comments on a pivot table

[Adam]

Dear All,

How would one add comments to a pivot table? I want to add two comments to items in a pivot table however when I select different items in the filter list, thus changing the range covered in the pivot tables, the comments remain static and just stay on cell D12 for example.

Any items how I can apply a comment to a specific item in the pivot table? Please see pivot layout below:

Invoice Date Range
10-20 21-30
1234 £10.40
5346 £12.50

I want to add a comment to, for example, the cell with £12.50 in however when you filter Invoice the table changes but the comment remains still in that one cell.

Any ideas?

Thanks

Adam

 

[Debra Dalgleish]

You can add comments to cells in the Pivot Table, but these are attached
to the cell, not to the content of the cell. If you pivot the fields, or
change the page field, the comment will not move.