# Pivot table

Pivot tables visualise multidimensional data.&#x20;

* Columns and rows can be freely configured.&#x20;
* Like diagrams, pivot tables are separately linked to the source data.

<figure><img src="https://3920520305-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyZbW8vbNs5hz8x57emJJ%2Fuploads%2FHi5rS56zXrmc1DB9xfme%2FReporting_pivot_tables.png?alt=media&#x26;token=ae0b4369-53a2-48e2-b4b8-aa902ec57d47" alt=""><figcaption><p>Pivot table view</p></figcaption></figure>

* A Row area field configured on Status displays all the element's statuses as rows.
* The Column Area field, configured on Significance, displays all Significance value as columns.&#x20;
* The Data Area field, configured on Number of Elements, displays the corresponding number of elements from the Status-Significance pairs.

### Example of how to create a pivot table:&#x20;

<figure><img src="https://3920520305-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyZbW8vbNs5hz8x57emJJ%2Fuploads%2F96V11l2645hcLiz2NSGT%2Fimage.png?alt=media&#x26;token=427d071c-6cf3-47c8-947c-d0596b3649d8" alt=""><figcaption></figcaption></figure>

In order to count e.g. our defects accordingly to a certain argument or category (in other words a value field that was created for a defect), please follow the video:

{% embed url="<https://drive.google.com/file/d/1evPJfFk2JW1fC8eoj7UjRV1pND0A4ywh/view?usp=drive_link>" %}

{% hint style="info" %}
Make sure to unmark the field *Show data headers* in the Options -> View Options

See photo:
{% endhint %}

<figure><img src="https://3920520305-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyZbW8vbNs5hz8x57emJJ%2Fuploads%2FEJjGkXVZcRM0OxecYVaj%2Fimage.png?alt=media&#x26;token=35c9556c-cf2d-42db-9d86-433f20a8a5b1" alt="" width="457"><figcaption></figcaption></figure>
