Forum Discussion
aref12
May 29, 2023Copper Contributor
heey
Hello, can I add a column to PIVOT so that it is possible to update free text for each row? And that you will be connected to the same line as soon as I make an update to the DATA BASE?
HansVogelaar
MVP
No, pivot tables don't work that way, sorry.
aref12
May 29, 2023Copper Contributor
Hey thanks .
Is there a way to overcome this?
I process data derived from the priority and it is necessary to add comments to the lines
Is there a way to overcome this?
I process data derived from the priority and it is necessary to add comments to the lines
- Detlef_LewinMay 29, 2023Silver Contributor
You could try Power Query.
There is Grouping and Pivoting.
And to add comments you need an extra table with a unique identifier column and a comment column.
The unique identifier must correspond to a column in your "pivot" table.
Then you have to combine "pivot" table with comments table.
- aref12May 30, 2023Copper Contributor
Thanks a lot, I'll try it
- aref12May 30, 2023Copper ContributorIt doesn't exactly help me, I set up a PIVOT according to the account PC number that I receive as a report from the priority system, and refresh the data, I want to edit the comments field on the PIVOT, and it will be updated together with the update of the report, and not to reconnect the tables every time .
- aref12May 30, 2023Copper ContributorI found another way to do this, through the PIVOT
- HansVogelaarMay 30, 2023MVP
That's great! Please tell us how, others may well benefit from it.
- HansVogelaarMay 29, 2023MVP
You cannot add text values to a pivot table, and if you enter them in a column next to the pivot table, they won't move with the rows of the pivot table.