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.
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.