Hi Masters
In Excel 2003 I could add 2 data elements to the Row label area of the Pivot table. Both items would show up on each row in a different column, this does not happen in 2007 as all items in the row label show up in the same column.
How can I revert to the way it was in 2003?
Many thanks
Arasan
Last edited by arasan25; 05-11-2011 at 03:31 AM.
On the Design tab in PivotTable Tools, change the Report Layout to either outline or tabular.
Remember what the dormouse said
Feed your head
Re: Excel 2007 Pivot Table side by side row labels
Wohooo!!!! You made my day mate! it works
Cheers
Arasan
Thanks to both... it helps me a lot
Rgds, Suresh
Re: Excel 2007 Pivot Table side by side row labels
This is wonderfully helpful! Thank you
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks