# Pivot Table - Sort

## Sort by Columns and Rows

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FXAFR3gmnhFaTV9f6rKYH%2Fimage.png?alt=media&#x26;token=2c04f182-dbe0-46e2-8a1c-e25759483b45" alt=""><figcaption></figcaption></figure>

* Only the select fields of Columns and Rows are available for the Sort feature in the Pivot Table.
* Click on the dropdown box next to the field and choose one of the options you want or keep it as None as default.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fboua0onRmnIfeJ9YFT6D%2Fimage.png?alt=media&#x26;token=f95229e8-7256-47ed-9010-b5405965ccb2" alt=""><figcaption></figcaption></figure>

* You can also quickly apply the Sort option by clicking on the Sort tag on the left of Pivot table.

{% hint style="info" %}
All the data will be sorted and displayed based on the highest sorting value, followed by subsequent sorting values.
{% endhint %}

{% hint style="info" %}
Click the Save changes button to confirm your sort setup.
{% endhint %}

## Sort by certain Values

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fe3roNCNsQjbPZYzEiPWL%2Fimage.png?alt=media&#x26;token=12cec1c9-43e0-4785-9163-153d7350f88b" alt=""><figcaption></figcaption></figure>

* To sort by certain Values, hover on the Value header and click on the ▲▼ Sort icon.&#x20;

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FG0z6HmUcVacY1qAznTEN%2Fimage.png?alt=media&#x26;token=076e46b4-34f2-4489-8ab1-a835d93d4b50" alt=""><figcaption></figcaption></figure>

* The ▼ icon indicates that the value is sort descending.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FhKxkgG8ShNLy7ADBKMRG%2Fimage.png?alt=media&#x26;token=5c389553-42b7-484d-8d71-b99d7f9e011a" alt=""><figcaption></figcaption></figure>

* The ▲ icon indicates that the value is sort ascending.

{% hint style="info" %}

* You can reset it back to the default state when click again through ▲▼ the Sort icon.&#x20;
* Sort by certain values will reset the sort option of Rows.
  {% endhint %}
