Pivot Report

Work items Structure

Group 326-20260303-032657.png

This article explains why and how to use the Issues Structure tab type within a report.

Why should you use this tab type?

The Issues Structure tab lets you display the full issue tree using either the default hierarchy (Epic → Story → Sub-task) or a custom hierarchy, without changing your Jira settings.

At each level of the tree, you can display rollup fields available in Jira’s Issue Navigator, along with additional report fields. These fields allow you to sort and filter the tree to quickly identify issues that require attention.

Overall, the Issues Structure tab acts as an enhanced version of Jira’s Issue Navigator. It builds on the same core features while adding detailed visibility into issue relationships, without needing to open the Issue view. This makes it easier to identify blockers directly within the tree.

Features and use cases

Display the issue tree outside the report

You can display the issue tree outside the report in several ways.

The contents of the Issues Structure tab can be shown on a dashboard using gadgets, as described in a separate article.

On Jira Cloud, you can also display the Issue structure within the Work Item view using widgets, as explained in a related article.

Display rollup fields as columns

Rollup fields—such as ∑ Original Estimate, ∑ Time Spent, and ∑ Remaining Estimate—which are available in Jira’s Issue Navigator, can also be displayed as columns within this tab type.

When a rollup field is used as a column, each parent cell aggregates the values of the cells below it in the same branch. This lets you view values for individual issues as well as combined totals for their related parent issues.

Fields that support rollup behavior are marked with the sigma (∑) symbol in the Columns dropdown. The Issues Structure tab supports additional rollup fields as columns, including:

  • Number or time based fields (such as Story Points, number of issues, time spent, or time remaining)

  • Progress indicators (such as Spent vs Estimated or Completion Rate)

  • Relative time-based measures (such as Underspent or Overspent)

These rollup columns can be sorted, as described in the FAQ below.

Display progress indicators as columns

Progress indicators, listed in a separate article, can be displayed as columns within the tab.

For example, Completion Rate can appear as a column. It is shown as a stacked bar that compares the number of Done issues with the total number of issues.

Group 250 (7)-20260205-065900.png

Displaying progress indicators as columns provides several advantages over Jira’s default views:

Group 239 (1)-20260106-043501.png
  1. Jira’s Child issues section shows a completion rate based only on status and only for direct child items. It does not include sub-tasks. In comparison, in this tab you can display the completion rate for the issue as well as the entire tree.

Group 250 (8)-20260205-072020.png
  1. Jira’s Issue Navigator is limited to the Progress and ∑ Progress columns, which are based on time spent, remaining time, and original estimates. These same indicators can also be displayed as columns in this tab, alongside other progress indicators.

Display Linked or blocked items
Group 250 (5)-20260205-061355.png

Linked issues, which appear in Jira’s Issue Navigator as shown in the screenshot above, can also be displayed within the Issues Structure tab.

Group 262-20260219-015700.png

This tab provides several advantages over Jira’s Issue Navigator:

  1. Linked issues appear alongside their icons, making it easy to see, for example, if an Epic is blocked by another Epic or by an Initiative that groups multiple Epics.

  2. A separate column can be displayed for each relationship link type (Blocks, Is Blocked By, Relates To, etc.), allowing you to filter and identify relationships that may act as bottlenecks in your projects.

In another scenario, a support ticket in one project may depend on a feature in another project. This dependency is visible in the Issues Structure tab tab without needing Jira Premium’s Advanced Roadmaps Dependencies view.

Sort Column sub-totals

You can sort rollup column sub-totals, such as ∑ Time Spent, by following these steps.

  1. Click the rollup column header. On the first click, the column values are sorted in ascending order, indicated by an upward arrow (↑). Click the header again to sort the values in descending order, indicated by a downward arrow (↓).

  2. Alternatively, after clicking the rollup column header once, click Sorting.

  3. Then select the field name and choose whether to sort it in ascending or descending order.

Group 261-20260219-015542.png
Sort rows using any field

You can sort rows using any field by following these steps, even if the field is not used in a Column.

  1. Click Sorting to open the report sidebar.

  2. Click Add field, open the dropdown menu, and select the field you want to sort by, such as Issue Type. The field is added to the bottom of the sorting queue, and it is sorted in ascending order, indicated by an upward arrow (↑). You can use up to three fields at a time.

  3. To change the sorting priority, drag a field using the grid icon (the dotted handle on the left side of the field card) to reposition it in the sorting queue. In the example shown, rows are sorted first by ∑ Time Spent, then by ∑ Work Ratio, and finally by Issue Type. To sort by Issue Type first, drag it above ∑ Time Spent. Finally, click on the field name and choose whether to sort it in ascending or descending order. In the provided example, Issue Type is ranked in descended order, indicated by a downward arrow (↓).

  4. Alternatively, to remove a field from the sorting queue, click the bin icon on the field card. For example, you can remove ∑ Work Ratio and ∑ Time Spent to sort only by Issue Type.

  5. Also, to clear all sorting rules at once, click Reset custom sorting, then click Add field to select Issue Type again.

Group 260-20260219-015505.png
Display a custom hierarchy that differs from your Jira hierarchy

You can create a custom hierarchy by following the steps described in a related article.

A custom hierarchy lets you change how issues are grouped in a report’s Issues Structure tab, independently of the Jira hierarchy.

FAQ

How can you edit this tab?

If you want to edit this tab, refer to a separate article.

Where can you you see Column sub-totals?
Group 247 (5)-20260205-030735.png

Column sub-totals appear at the top of the column, rather than at the bottom, as shown in the screenshot above.

  1. The rollup column total for ∑ Time Spent across all issues in the project appears in the first row. In this example, rows are grouped by project.

  2. A sub-total for Time Spent appears for each parent issue within the same group. In this example, sub-tasks are grouped under a story, and the story row displays the combined time spent for its sub-tasks.

  3. The time spent for each individual sub-task appears in its corresponding row.

If you want to display the cumulative total for a rollup Column, such as ∑ Time spent, you will need to use either a progress indicator or a custom slice.

Can you impact the hierarchy by using sorting?

No. Sorting does not affect the Jira issue hierarchy.

Sorting rules are applied separately at each level of the hierarchy. As a result, issues that share the same parent are sorted only among themselves, while the overall tree structure remains unchanged.

Can you change the order of Column appearance?

Yes. You can change the order in which columns appear by following these steps.

  1. Select any part of the column header. In the example shown, ∑ Time Spent is the column being moved.

  2. Drag the column to the desired position until a rectangle appears over the target column. In the example, ∑ Time Spent is moved to replace Fix Version.

Group 259-20260219-015417.png

Troubleshooting

This tab is missing. Where can you find it?
Group 430 (1)-20260316-231536.png

If the Issues Structure tab is missing, as shown in the screenshot above, it may have been removed from the report.

To add a tab, follow the steps in a separate article.

If you have questions or need assistance, contact our support team via email or service desk. Our team is available Monday through Friday (9:00 AM to 7:00 PM GMT+7) to help with technical challenges or discuss improvements.