Comments alongside pivot report get displaced

[salman]

Dear all

I have preapred a pivot table based report for customers of my company. Each customer in our company has 2 accounts (one each for machinery and spares).

As 'customer' field was with 'automatic' setting there was subtotal of each customer. To make the report more presentable I opted for 'collapse' report.

My CFO liked report however asked to add comments for each customer. I did so however now when a customer field is expanded (or whole report is expanded) the comments for other customers are displaced alongside other customers'.

can i avoid this situation.

pl help.

 

[GlennUK]

When you say "comments", do you mean some text typed into cells, or do you mean Cell Comments ( as in menu command Insert/Comment )?

 

[salman]

Dear Glen
I meant text typed in cells alsong side a particulat customer.
Thank you n regards
salman

 

[GlennUK]

I'd say that you need to keep your comments in a different sheet, and retrieve them in cells next to the PivotTable using VLOOKUP or INDEX&MATCH, so that whatever the position of the customer the correct comments are shown.