Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table help
Dear all
I have prepared 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 boss 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 mentioned alongside each customer are displaced against some other customers. can i avoid this situation. Pl help. -- salman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table help
On Jun 23, 1:23*pm, salman wrote:
Dear all I have prepared 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table help
Create a new column in the source data, and add the comments there. Then
add the comments field to the row area of the pivot table. salman wrote: Dear all I have prepared 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 boss 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 mentioned alongside each customer are displaced against some other customers. can i avoid this situation. Pl help. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |