8,849
edits
Changes
no edit summary
# Now click into the ''Overview'' section and click into the node that should contain the total for Year 1 from the ''Staff'' section.
# In the ''Content'' section of ''Cell Properties'', enter the reference to the Year 1 total for ''Staff'' using the following syntax: <br />=[''section ID''_'''total'''_''Node Name'']<br />In the above example, this will be ''=[1440_total_Year-1]<br />[[Image:XMLSampleReferenceInOverviewToStaffTotal.png|link=|600px]]
# Repeat for each section total to be referenced.
The =[''section ID''_'''total'''_''Node Name''] syntax works because the ''Year 1'' column in the ''Staff'' section has the ''Has Total'' option selected.
To return a reference to an XML section that does not use totals, use the following syntax:<br />
=[''section ID''_''Node Name of Row''_''Node Name of Column'']
[[Category:XML]]