2022.2

1. Intheworkspace,opentheDesigntab.
2. Ifthetabledoesn'thaveaheader/footer,addit(see"Addingaheaderorfooter"onpage657).To
determineifatablehasaheaderand/orfooter,expandthetableonthe"Outlinepane"on
page977.
3. Ifyouneedanextrarowintheheaderorfooter:
a. Right-clicktheheaderorthefooterofthetable,dependingonwhereyouwanttoaddarow.
b. Ontheshortcutmenu,selectRow > Insert beloworInsert above.
4. Specifyonwhichpagestherowmustappearintheoutput:
a. Selecttherowtowhichyouwanttoaddasubtotal(see"Selectinganelement"onpage570).
b. Onthe"Attributespane"onpage969,selectoneoftheoptionsfromtheShow Rowdrop-down:
l
All:Therowwillappearonallpages.
l
Before page break(footerrowsonly):Therowwillappearonallpagesexceptthelast.
l
After page break(headerrowsonly):Therowwillappearonallpagesexceptthefirst.
l
At end of table:Therowwillonlyappearonthelastpage.
5. Now,addthesubtotaltoacellinthatrow.Thisprocedureisthesameforsubtotalsintheheader
andfooter.
a. Selectthecell(see"Selectinganelement"onpage570).
b. Selectthedatafield:
l
Onthe"Attributespane"onpage969,fromtheSumdrop-down,selectthedatafieldon
whichthesubtotalmustbebased.Thedrop-downwillofferalleligiblefields,includingthose
innesteddetailtables.
l
Alternatively,e.g.toselectadatafieldinanesteddetailtable,switchtoSourceviewand
manuallyaddthedata-sumattributetothetablecell(the<td>element).
Itsvalueshouldconsistofthepathtothedatafield.Forexample:<tddata-sum-
m="Instruments.Items.Amount">.Thiscellwillhaveasubtotalbasedonthe"Amount"field
inthe"Items"detailtablewhichisnestedinthe"Instruments"detailtable.
c. Youcouldalsoaddtextlike"continuedonnextpage"or"continuedfrompreviouspage"tothecell.
See"EditingcellsinaDynamicTable"onthefacingpage.
Subtotals inside a Dynamic Table
Subtotalsnormallyappearintheheaderorfooterofatable;however,itisalsopossibletoinsertsub-
totalsincellsinthebodyofatable.
Page 749