Subtotals headings

D

Donna

I need to see summary data (SS, First, Last) in Level 2 for more than the
column I am sub-totaling on. Is this possible?
Example: Level 3
ID SS First Last Amt Units
1104 xxx-xx-xxxx Joe Jones $305.08 21.04
1104 xxx-xx-xxxx Joe Jones $32.59 0
1104 xxx-xx-xxxx Joe Jones $507.84 31.74
1104 xxx-xx-xxxx Joe Jones $80.89 0
1104 Total $926.40 52.78
1106 xxx-xx-xxxx Jim Smith $738.87 67.17
1106 xxx-xx-xxxx Jim Smith $29.04 1.76
1106 xxx-xx-xxxx Jim Smith $108.12 0
1106 xxx-xx-xxxx Jim Smith $1,009.82 72.13
1106 Total $1,885.85 141.06
1107 xxx-xx-xxxx Sally White $1,307.69 80
1107 xxx-xx-xxxx Sally White $96.98 0
1107 xxx-xx-xxxx Sally White $249.97 0
1107 xxx-xx-xxxx Sally White $1,384.62 80
1107 Total $3,039.26 160


Example: Level 2
ID SS First Last Amount Units
1104 Total $926.40 52.78
1106 Total $1,885.85 141.06
1107 Total $3,039.26 160
 
J

Jim Thomlinson

Using Subtotaling that is not possible. If you used a pivot table that would
work. Try this if you wish.

Remove the Subtotals.
Put your cursor in the middle of the data and select
Data -> Pivot Table...
When the wizard comes up you can usually just hit finish and XL will make
all of the appropriate guesses for you.

Drag the ID, SS First and Last to the left hand column.
Drag the amount and units to the data area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top