title: Add column with custom text to pivot table
body: <p>I have a large Excel (2016) file that looks like this</p>
  
  <p>ID | Group &nbsp;  &nbsp;&nbsp;&nbsp;&nbsp;| Status&nbsp;&nbsp; &nbsp;&nbsp;  | ...<br/> 
  01 | Yamato &nbsp;&nbsp; | OK  &nbsp;   &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |<br/> 
  02 | Serenity&nbsp;&nbsp;&nbsp;| Delayed&nbsp;&nbsp;  |<br/> 
  03 | Normandy| Failed&nbsp;&nbsp; &nbsp;&nbsp;  |<br/> 
  04 | Normandy| OK   &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   |<br/> 
  05 | Serenity&nbsp;&nbsp;&nbsp;| Idonteven|<br/> </p>
  
  <p>On another sheet there is a pivot table that provides an overview of each group, specifically the status counts, but it's important for us to be able to add a comment for the whole group, e.g.:</p>
  
  <p>Group   &nbsp;&nbsp; | Total | OK  | Failed | Delayed | Idonteven | Comment<br/> 
  Serenity | 154&nbsp;&nbsp;| 120 | 12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| [FFS] Insufficient supplies<br/> </p>
  
  <p>Currently this is done by a dedicated column outside of the actual pivot table, far enough to the right to accommodate the columns that could be needed for all states. HOWEVER groups may be added or removed, and if a group is removed, the string for it is removed from the pivot table and all the rows below shift up, however comment column is not adjusted and the comments end up in the rows for the wrong groups.</p>
  
  <p>So I wanted to check if anyone knows a way to add a column with custom text to a pivot table in a way that would keep the comments attached to the correct string, or another functionality to the same effect.</p>
  
  <p>(Actual comments via the "New comment" button would not work here, as the tags in the comments are used to trigger formatting/formulas further downstream)</p>