Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables & Excel 2007
Just switched from Excel 2003 to 2007 and just getting to grips with
reworking my pivots from the previous version. In 2003 Rows in Pivot should be listed sideby side, if you had a number of Row items they would be listed in Col B, C, D etc until the numerical data. In 2007 rows seem to be nested is there away of unnesting and showing multiple text rows sideby side Thanks Cassie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables & Excel 2007
Cassie,
Try playing with the Pivot Design Layout in 2007, to get the result you're looking for. In this case, PivotTable Tools, Design, Report Layout, Tabular Form -- Kevin "Cassie" wrote: Just switched from Excel 2003 to 2007 and just getting to grips with reworking my pivots from the previous version. In 2003 Rows in Pivot should be listed sideby side, if you had a number of Row items they would be listed in Col B, C, D etc until the numerical data. In 2007 rows seem to be nested is there away of unnesting and showing multiple text rows sideby side Thanks Cassie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables in Excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Tables in Excel 2007 | Excel Worksheet Functions | |||
Pivot Tables in Excel 2007 | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot tables | Excel Worksheet Functions |