Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Comment Field
I am wanting to put a comment field in a pivot table, so when some one sees something on the table they can put a comment as why it is there. A free form type thing. I know that if I put a field in that is blank and it puts (blank) in all the cells in the field, if you change the word blank to what ever it changes all the same thing to what you type in that field or cell. So the only thing I could think of was to put numbers in the column prior to converting to a pivot table like 1-150, so they would all be unique so I can have a comment field. Is there some other way to do this? Thanks for the help, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 |
#2
|
|||
|
|||
Is there a reason you don't want to use a comment? (Insert|Comment)
robertjtucker wrote: I am wanting to put a comment field in a pivot table, so when some one sees something on the table they can put a comment as why it is there. A free form type thing. I know that if I put a field in that is blank and it puts (blank) in all the cells in the field, if you change the word blank to what ever it changes all the same thing to what you type in that field or cell. So the only thing I could think of was to put numbers in the column prior to converting to a pivot table like 1-150, so they would all be unique so I can have a comment field. Is there some other way to do this? Thanks for the help, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 -- Dave Peterson |
#3
|
|||
|
|||
It is for many users, and I am not sure that everyone would know to look for the red tag on the cell for comments. The rest of the spread sheets that are used here all have a column marked comments and they are probably used to that. Of course I made this reall nice pivot table that makes things really easy, and I need a comment field. Thanks for the help, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 |
#4
|
|||
|
|||
You could add text to any adjacent cell (not part of the pivottable), but then
if you rearrange that pivottable, your text may not make much sense. (If the users don't know to look for comments, maybe you could copy|paste special over the pivottable and make it just data so it can't be rearranged??) You could turn on the comments so that they're always visible? Tools|options|view tab. robertjtucker wrote: It is for many users, and I am not sure that everyone would know to look for the red tag on the cell for comments. The rest of the spread sheets that are used here all have a column marked comments and they are probably used to that. Of course I made this reall nice pivot table that makes things really easy, and I need a comment field. Thanks for the help, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 -- Dave Peterson |
#5
|
|||
|
|||
I like the way inserting the comments works, putting the name in and everything but if there is comments in cells right above or below they overlap and you can't read them if you alow them to be viewed all the time. Like you said if it is in adjacent cells out of the pivot then the text gets jumbled if you sort or use the drop boxes. Can you group them with a part of the pivot table so the cells that are not in the pivot will move with the data in the pivot. Thanks for you input Dave, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 |
#6
|
|||
|
|||
I don't think you can tie those adjacent cells to something in the pivottable.
There are just so many things you can do that I would think it would be impossible to do it automatically. If you can pick out a unique value, maybe you could put the notes in another worksheet and use =vlookup() to retrieve that "comment" into the adjacent cell. (But that, too, would depend on what you did to that pivottable.) robertjtucker wrote: I like the way inserting the comments works, putting the name in and everything but if there is comments in cells right above or below they overlap and you can't read them if you alow them to be viewed all the time. Like you said if it is in adjacent cells out of the pivot then the text gets jumbled if you sort or use the drop boxes. Can you group them with a part of the pivot table so the cells that are not in the pivot will move with the data in the pivot. Thanks for you input Dave, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 -- Dave Peterson |
#7
|
|||
|
|||
I think What I'll do is in my data table I'll create a column for comments. In the cells below it I'll put "Enter Comments Here 01" and do a fill in the range so it'll have a unique entry for every field so when it creates the pivot table and they enter comments it will not change the fiel in the pivot table to all the same comment. Make sense, it does in my head at least. -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=391067 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Group Field in Pivot Table €“ Not Enough Room | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |