> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-rows/template-rows.md). # Template rows Inforiver allows inserting calculated rows at every level in the hierarchy with the template row option. {% embed url="" %} Let us take this example: Sales data by region and category. Let's insert a calculated row in each hierarchy which is 1.5 times the value of Beverages across quarters. a) Select a row above which you would like to insert the row. b) In the 'Insert' tab of the toolbar, click on the ‘Insert row' dropdown and select the 'Template row' option.

c) A new row gets inserted and the 'Template row' side panel opens.

d) Enter the 'title' and insert the required 'formula'. Refer to [calculated rows](/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-rows.md) for more details on using the formula editor.

e) Select the 'Row position' as ‘First’, ‘Auto’ or ‘Last’ from the drop-down. 'First' - the template row will be placed first at the category level, irrespective of where it is added 'Auto' - the template row is placed above the selected row where it is added 'Last' - the template row is placed last at the category level, irrespective of where it is added

f) You can select the 'Apply the same style to all rows' checkbox if you want to replicate the same formatting to all of the rows. For example, let's apply a background color for the row.

g) To include the row value in subtotals and totals, check the 'Include in total' check box.

h) If charts are added to the table, the 'Include in charts' option allows you to visualize the calculated rows as well using charts. {% hint style="info" %} The 'Include in charts' checkbox is enabled only when the 'Include in total' option is unchecked. {% endhint %} i) If the 'Evaluate columns before rows' checkbox is enabled, the defined formula is used for calculating the column totals. If this check box is disabled, then sum aggregation is followed fo the column totals. To learn more, refer [Evaluate columns before rows](https://inforiver.gitbook.io/inforiver/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-rows#4.-evaluate-column-before-rows). j) You can add a description for the formula if needed. Click 'Create'.

k) The row gets created at the category level for all the subregions as shown.

l) The below image shows another example, where the rows 'Extra Large' are defined as the previous month's value for the size 'Large'. To learn more about the formula used, refer to [RELATIVE\_COLUMN](/~/changes/mS6jwvARNLHpKqBa4cT9/formula-syntax/identifiers/relative_column.md).

m) You can edit/delete the inserted template row by clicking on the row gripper of the selected template row and choosing the respective option from the drop-down.

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/4.-adding-business-logic-and-formulae/insert-calculated-rows/template-rows.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.