I have made a pivot table and added a column at the end which is called comments. The purpose for that column is off course to make comments to the separate row in the pivot table. This works fine when i look at all the rows in the table, but when i use filter you get a shorter list, and the comments doesn’t follow the rows. You get a renumbering of the rows always starting with 1 and counting 1,2,3,4 and so on, instead that the row numbers stay constant as for the table without filter. Is it possible to keep the row number constant in a pivot table?

​I have made a pivot table and added a column at the end which is called comments. The purpose for that column is off course to make comments to the separate row in the pivot table. This works fine when i look at all the rows in the table, but when i use filter you get a shorter list, and the comments doesn’t follow the rows. You get a renumbering of the rows always starting with 1 and counting 1,2,3,4 and so on, instead that the row numbers stay constant as for the table without filter. Is it possible to keep the row number constant in a pivot table?  Read More

​