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
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