Forum Discussion
Solved
Keep the row numbers in pivot table when you sort on field
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 wh...
kennethsorsdalbirno right. This way it is never going to work. Excel doesn't "know" the data you put next to a pivot table needs to stay with a certain row of the pivot table. You need to create a separate table for the comments which has all the unique items which are your current pivot table rows. Then use a lookup formula to fetch the information from that table next to your pivot table.
The first picture you see the table when i have not used the filter. You can see the comments at each row.
In this picture i have used the filter 100. You can see that the comments do not follow the row they where written to
kennethsorsdalbirno right. This way it is never going to work. Excel doesn't "know" the data you put next to a pivot table needs to stay with a certain row of the pivot table. You need to create a separate table for the comments which has all the unique items which are your current pivot table rows. Then use a lookup formula to fetch the information from that table next to your pivot table.