Subtotals headings

  • Thread starter Thread starter Donna
  • Start date Start date
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
 
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.
 
Back
Top