Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does the data shift out my outline when I refresh the Pivot table?
I tried outlining my detail information and I want to show the first
and last line of my detail information. It is broken down by Customer, detail next customer next detatil. When I close the grouping, It shows Customer and then the last line is customer total. The problem I am having is when I refresh the pivot table and get more data, the data shifts out of the outlines, I originally created. Is this something I am stuck with redoing the outlines when new data is added or is their a way to prevent it. Regards, Chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does the data shift out my outline when I refresh the Pivottable?
As answered in microsoft.public.excel.misc:
If new items appear in the pivot table, they won't automatically be included in manually created groups. Perhaps you could create a new column in the source data, and enter the group name there, or use a formula to lookup the group in a table. Then, add that new field to the pivot table, and use it instead of the manually created groups. Chris wrote: I tried outlining my detail information and I want to show the first and last line of my detail information. It is broken down by Customer, detail next customer next detatil. When I close the grouping, It shows Customer and then the last line is customer total. The problem I am having is when I refresh the pivot table and get more data, the data shifts out of the outlines, I originally created. Is this something I am stuck with redoing the outlines when new data is added or is their a way to prevent it. Regards, Chris -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report choosing a Pivot table data | Excel Worksheet Functions | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |