---
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.ru/support/tracker/en/user/summary-table.md
  - https://yandex.ru/support/tracker/ru/user/summary-table.md
  - href: en/user/summary-table.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.ru/support/tracker/en/llms.txt


# Pivot table

Select two issue parameters, and the table will show how many issues fall into each combination of values.

For example, to track team workload by **Assignee** and **Status**: each column will show an assignee's name, each row will show an issue status, and each cell will show the number of issues for the assignee in each status.

{% note tip "" %}

If you want to see the sum of values for a third parameter in the cells, such as **Time spent** or **Iteration**, use [Summary table with totals](https://yandex.ru/support/tracker/en/user/summary-table-with-totals.md).

{% endnote %}

![](../_assets/widgets/table.png =500x){.border-blue}
_Example of a pivot 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.ru/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.ru/support/tracker/en/user/query-filter.md)
  - **Parameters** — here you can set up a condition using buttons. [How to add search conditions](https://yandex.ru/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 -->

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

- **Sort by** — whether to sort rows and columns by the cell values.

- <!-- 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/table-settings.png =500x){.border-blue}
_Example of settings_

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

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