shadowpook
New Member
- Joined
- Jan 2, 2008
- Messages
- 8
In Excel 2003, if I had a pivot table, the non-sum data (sections) would display nicely in two or more columns, now it all cascades into one column.
For example, if I wanted to see the Dept, then the subclasses within the dept, and the totals, I would set Dept and subclass as rows and the sum of the amount as the totals. When it displayed, I would get Dept in Column A and SCL in Column B, then the sum values in Column 'C'
A...............B..............C..............D
Dept 1.......SCL123.........$5.00.......
............... SCL234.........$6.00.......
................SCL345.........$20.00......
..TOTAl........................$31.00
Dept2........SCL123..........$2.00
................SCL234..........$3.00
....TOTAL..........................$5.00
Now in 2007 I can only Get Dept and SCL (any data I want to display but not sum) in column A...So I would get Dept and SCL in column A, I couldn't put SCL in column B to make it cleaner. There used to be something that I could drag so that I could get the SCL to show in Column B, but the non-sum data only cascades down
A...............B..............C..............D
Dept 1.
.SCL123....$5.00
.SCL234....$6.00
.SCL345....$20.00
Dept2
.SCL123....$2.00
.SCL234...$3.00
Any idea if I can get the data to look like it did before?
For example, if I wanted to see the Dept, then the subclasses within the dept, and the totals, I would set Dept and subclass as rows and the sum of the amount as the totals. When it displayed, I would get Dept in Column A and SCL in Column B, then the sum values in Column 'C'
A...............B..............C..............D
Dept 1.......SCL123.........$5.00.......
............... SCL234.........$6.00.......
................SCL345.........$20.00......
..TOTAl........................$31.00
Dept2........SCL123..........$2.00
................SCL234..........$3.00
....TOTAL..........................$5.00
Now in 2007 I can only Get Dept and SCL (any data I want to display but not sum) in column A...So I would get Dept and SCL in column A, I couldn't put SCL in column B to make it cleaner. There used to be something that I could drag so that I could get the SCL to show in Column B, but the non-sum data only cascades down
A...............B..............C..............D
Dept 1.
.SCL123....$5.00
.SCL234....$6.00
.SCL345....$20.00
Dept2
.SCL123....$2.00
.SCL234...$3.00
Any idea if I can get the data to look like it did before?