elucidating grouped headings in pivot table
Hi - my pivot table groups rows like this (i.e. only showing the name Jones
for one of the two rows for this name): Name City Smith London Jones Edinburgh (blank) Clarke Paris I'd like the names column to be more explicit, i.e. what I'd like to see (to be able to use Excel's database/list functions) is: Name City Smith London Jones Edinburgh Jones (blank) Clarke Paris Any ideas? Thanks. |
elucidating grouped headings in pivot table
Pivot tables don't work like that.
You could convert the pivottable to values (select the cells|copy|paste special|values) And use the techniques shown at Debra Dalgleish's site to fill the cells. http://www.contextures.com/xlDataEntry02.html Martin wrote: Hi - my pivot table groups rows like this (i.e. only showing the name Jones for one of the two rows for this name): Name City Smith London Jones Edinburgh (blank) Clarke Paris I'd like the names column to be more explicit, i.e. what I'd like to see (to be able to use Excel's database/list functions) is: Name City Smith London Jones Edinburgh Jones (blank) Clarke Paris Any ideas? Thanks. -- Dave Peterson |
All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com