---
metadata:
  - name: generator
    content: Diplodoc Platform v5.54.5
  - property: og:type
    content: article
  - property: article:section
    content: Следить за задачами на дашборде
  - property: og:title
    content: Виджет «Сводная таблица с суммой»
  - property: article:tag
    content: Базовая инструкция
alternate:
  - https://yandex.com.tr/support/tracker/en/user/summary-table-with-totals.md
  - href: en/user/summary-table-with-totals.md
    type: text/markdown
    title: Markdown version
  - href: ../llms.txt
    type: text/markdown
    title: llms.txt
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com.tr/support/tracker/en/llms.txt


# Summary table with totals

Select three issue parameters: for rows, columns, and cells. The table will show the sum of values for the third parameter in issues that match each combination of the other two values.

For example, track your team's workload by **Assignee** and **Component** parameters: each column will show an assignee's name, each row will show a component name, and each cell will show the total time the assignee spent on issues with that component.

{% note tip "" %}

If you need to count the number of issues in cells, use [Pivot table](https://yandex.com.tr/support/tracker/en/user/summary-table.md).

{% endnote %}

![](../_assets/widgets/table-with-sum.png =500x){.border-blue}
_Example table_

## Widget settings {#config}

- <!-- source: en/_includes/dashboards.md -->
  **Data source** — the issue search conditions for the widget. You can specify them in different formats: {#data-source}
  <!-- endsource: en/_includes/dashboards.md -->

  <!-- source: en/_includes/dashboards.md -->
  - **Filter** — here you can select a quick filter, such as "Reported by me", or your saved filter. [How to save an issue filter](https://yandex.com.tr/support/tracker/en/user/create-filter.md)
  - **Query language** — here you can enter a condition in query format. Choose this if you need to insert a function or combine several conditions with the "AND" and "OR" operators. [How to set a condition using the query language](https://yandex.com.tr/support/tracker/en/user/query-filter.md)
  - **Parameters** — here you can set up a condition using buttons. [How to add search conditions](https://yandex.com.tr/support/tracker/en/user/create-filter.md#set-conditions)
  <!-- endsource: en/_includes/dashboards.md -->

- <!-- source: en/_includes/dashboards.md -->
  **Columns** — the issue parameter whose values become the table columns. {#columns}
  <!-- endsource: en/_includes/dashboards.md -->

- <!-- source: en/_includes/dashboards.md -->
  **Rows** — the issue parameter whose values become the table rows. {#rows}
  <!-- endsource: en/_includes/dashboards.md -->

- **Cells**: Issue parameter whose value sum will be calculated in table cells.
    The parameter must contain a number or time.

- **Issues on page**: How many table rows to show. If there are more rows than specified, the **Show all** button will appear at the bottom of the widget.

- **Sort rows** and **Sort columns**: In ascending or descending alphabetical order.

- <!-- source: en/_includes/dashboards.md -->
  **Show total** — enable this to add a row with the total for each column. {#summ}
  <!-- endsource: en/_includes/dashboards.md -->

- <!-- source: en/_includes/dashboards.md -->
  **Auto-update** — how often the widget will update. {#autoup}
  <!-- endsource: en/_includes/dashboards.md -->

![](../_assets/dashboards/summary-table-settings.png =500x){.border-blue}
_Example settings_

<!-- source: en/_assets/style/image.md -->

<!-- endsource: en/_assets/style/image.md -->