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 |
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 |
All times are GMT +1. The time now is 04:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com