Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PT Grouping - Naming
Excel 2007, multiple PTs based on same dataset/cache, combining rows into
grouped rows with unique group names. Need to update PTs weekly, and groupings change as a result of changes in dataset (the calculations update as expected with the new dataset). Is there anyway to have the unique combined row names represented in all PTs without having to copy from a PT where the grouping changes are made and rebuilding the other PTs manually (copy/paste/rebuild)? The grouping names are obviously not beeing kept with the cache (just Groupxx). The unique grouped row names copy appropriately the first time the cloned PTs are made, but are then static. Thanks in advance, J Austin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PT Grouping - Naming
Excel 2007 PivotTable
Grouping of odd time slots and set of names. http://www.mediafire.com/file/mt0dd2myxmm/07_21_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with naming | Excel Discussion (Misc queries) | |||
Tab Naming | Excel Worksheet Functions | |||
Tab Naming | Excel Worksheet Functions | |||
Tab Naming | Excel Worksheet Functions | |||
Naming A Grouping | Excel Discussion (Misc queries) |