Good Morning -
Using Excel 2007 on WinXP SP3
I'm trying to use a Pivot Table to come up with a summary sheet. My issue is that when the sheet is collapsed (Collapsed down to ITEM) (Which it needs to be) I'm loosing the info in the related cells which I very much need. I know there has to be a simple solution to this, but I've spent 2 days on it now and can't find it!
Small snips of the sheets are below to explain what I'm looking at.
Basically, I want it to LOOK like it does when collapsed but have all the info you see when it's expanded.
Expanded, showing all info:
Collapsed - notice that Description, Vendor, Quan and Cost are all missing now, BUT that COUNt of item, SUM of Quan and SUM of Cost are all tallied up correctly:
Using Excel 2007 on WinXP SP3
I'm trying to use a Pivot Table to come up with a summary sheet. My issue is that when the sheet is collapsed (Collapsed down to ITEM) (Which it needs to be) I'm loosing the info in the related cells which I very much need. I know there has to be a simple solution to this, but I've spent 2 days on it now and can't find it!
Small snips of the sheets are below to explain what I'm looking at.
Basically, I want it to LOOK like it does when collapsed but have all the info you see when it's expanded.
Expanded, showing all info:
IS Purchases 2009 Forward.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Values | |||||||||
2 | Item | Description | Vendor | Quan | Cost | CountofItem | SumofQuan | SumofCost | ||
3 | 7859 | Cord | 30885 | 6 | $31.74 | 1 | 6 | $31.74 | ||
4 | 8173 | Cable | 30885 | 2 | $46.87 | 1 | 2 | $46.87 | ||
5 | Cable.a | 30885 | 1 | $46.87 | 2 | 2 | $93.74 | |||
6 | 8175 | Thing | 30885 | 4 | $34.03 | 1 | 4 | $34.03 | ||
7 | 9008 | Installation | 10771 | 1 | $0.00 | 1 | 1 | $0.00 | ||
8 | 9618 | Widget | 30885 | 1 | $5.12 | 1 | 1 | $5.12 | ||
9 | Widget.a | 30885 | 3 | $5.12 | 1 | 3 | $5.12 | |||
10 | Widget.b | 30885 | 1 | $5.12 | 1 | 1 | $5.12 | |||
11 | 13211 | Circle | 11071 | 2 | $11.66 | 1 | 2 | $11.66 | ||
Sheet6 |
Collapsed - notice that Description, Vendor, Quan and Cost are all missing now, BUT that COUNt of item, SUM of Quan and SUM of Cost are all tallied up correctly:
IS Purchases 2009 Forward.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Values | |||||||||
2 | Item | Description | Vendor | Quan | Cost | CountofItem | SumofQuan | SumofCost | ||
3 | 7859 | Cord | 1 | 6 | $31.74 | |||||
4 | 8173 | Cable | 3 | 4 | $140.61 | |||||
5 | 8175 | Thing | 1 | 4 | $34.03 | |||||
6 | 9008 | Installation | 1 | 1 | $0.00 | |||||
7 | 9618 | Widget | 3 | 5 | $15.36 | |||||
8 | 13211 | Circle | 1 | 2 | $11.66 | |||||
Sheet5 |