Adding Comments To Pivot Table

[sserge]

Dear all,

I have a small issue in Excel 2010. Having prepared a huge data analysis by the means of a pivot table, there is a huge amount of product number inconsistency among the data. Hence there is the need of being able to add comments to individual data sets in the Pivot table. Of course, this imposes various problems when resorting the Pivot Table. Comments obviously will not work and just adding a column neither.

Thus - what is the possibility (maybe some macro magic) to add comments to the dataset from within a Pivot table. I am completely lost there, also since Excel is not really by usual field of work.

Any help is highly appreciated, thanks!

[bonny24tycoon]

Hi sserge,

Welcome to the forum


Im not sure if I understood your query. However, you can try using shapes adjacent to your pivot as call outs to add comments. Like this Book1.xlsx


Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[sserge]

Hi Bonny.

Thanks for your effort. But unfortunately that's not exactly what I want. Unfortunately it's a bit more complicated. Let me elaborate on it.

There is a huge raw dataset with several thousand articles and their corresponding details. Since there are inconsistencies within the article numbers, same or similar articles have different articles numbers. When analysing this data I can not determine the best sellers correctly. Hence gradually, over time, adaptations have to be made. In order to keep track of that I need to add comments to the individual articles from within the Pivot table.

Meaning: I sort my data in the Pivot table, add a comment and that comment will be linked to the corresponding article and shows in the Pivot table.

Basically its adding another column to the raw data, which shows up in the Pivot, but is editable from within the Pivot.

I find it really hard to explain Basically adding a comment which moves with the data. A review comment is linked to a cell (not good for sorting) same applies to a static column.

Hope that clarified it a bit, otherwise I try to repharase this again.

Thanks again for your help and I appreciate the friendly tone around here!

[bonny24tycoon]

Ohhh I see!!!! Let me try if there is a work around.

Thanks for your appreciation. I would like to say that its just been a month for me joining this forum and the tone and knowledge here is indeed fantastic.


Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[sserge]

Thanks a lot.

[deleted since my approach, excuse my french, was crap]

So, I have found this: http://www.mrexcel.com/forum/showthread.php?t=608648

Not sure if it is of help and whether I understand the whole principle correctly. However, my Pivot is in Tabular Form anyway

[sserge]

I guess you came to the conclusion as well that this is not exactly possible?!

[Hatrick40]

I think I know exactly what we are all looking for. I found this site and if you download the tutorial it show exactly what it does with screenshots.

I'm hoping one of you might be able to figure it out.

http://pivot4u.com/documents/tutorial.html

Thanks

Jeremy

[protonLeah]

Hatrick40,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

No one here is going to watch a video and create an application for you. Buy the porduct!

This is your third duplication/hijack:
http://www.excelforum.com/showthread.php?t=682087
http://www.excelforum.com/showthread.php?t=831461
http://www.excelforum.com/showthread.php?t=732896