Dear all,
This is my first post. Thanks for a great forum that have solved many of my questions. But I cant seems to find the answer for this one. I hope someone is able to help me.
I have classic Pivot table. Each row contains a project and the column a value. I have applied a filter that can sort which team the project remains under.
When I work with the Pivot I need to write some comments about each project(rows). What I need is the Comment to "stick" to the projekt. As an example(attached photo) "comment 1" should stay with project 2015055 no matter how the Pivot changes. Obervisly, because the comment is written outside the Pivot atm, when I change the table, the comment does NOT follow the intended project.
Udklip.PNG
There must be a away to allow me to have some sort of dynamic column, where I can write text that follows the changing Pivot?
If anything is unclear please hit me.
And thanks so much in advance for any help.
Kind Regards
Mads
Bookmarks