2007 Pivot tables
In Excel 2003 you could have more than one set of row data, aligned
horisontally next to each other, in Excel 2007 when you add more than one set of row data it nests the data in a sub menu style rather than allowing it to be placed alongside and displaying data in the same row. Does anyone know how I can make a pivot table display in row data alongside rather than nested? |
2007 Pivot tables
Alan,
Not sure if this will help, but have you tried "Pivot Table Options" - "Display" - and then check the "Classic Pivot Table Layout" box. This gives you the same layout that people were used to in 2003 and may fix your problem. Ian Grega "Alan M" wrote: In Excel 2003 you could have more than one set of row data, aligned horisontally next to each other, in Excel 2007 when you add more than one set of row data it nests the data in a sub menu style rather than allowing it to be placed alongside and displaying data in the same row. Does anyone know how I can make a pivot table display in row data alongside rather than nested? |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com