Document toolboxDocument toolbox

This article is for Data Center. Visit Cloud

Totals Columns


Totals columns provide aggregate values for all numeric and time-tracking fields. These are calculated as the sum of the current item's field value and those of its sub-issues.


When using an aggregate column:

  • When an aggregate value is displayed for an issue that also has its own value in the field, its own value is displayed next to the aggregate value in a gray color.
  • Since issues can be present multiple times in a structure, you can select whether you want to count every instance of an issue or count it just once. By default, duplicates are counted each time they appear. To exclude them, select Exclude Duplicates in the column configuration panel.

Sum over sub-items

All aggregate columns have the Sum over sub-items box checked.


This is what makes them aggregate columns. Unchecking this box will change the column from an aggregate column to it's corresponding Field column.

Build Your Own Aggregate Columns

You can also build your own aggregate columns for most numeric and time-tracking fields. Simply open the column configuration panel and select Sum over sub-issues.

If the Sum over sub-issues option is unavailable for a given field, then the aggregate cannot be calculated.

Totals are Structure-Specific

The Total value for a specific issue may change depending on the selected structure, because its sub-issues can vary by structure.