# Pivot Grid - How to Sort by Data Area values

**URL:** <https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 4, 2018, 7:56am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797 "2018-04-04T07:56:35Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![InfoMan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/infoman/32/322_2.png) [@InfoMan](https://forums.toadworld.com/u/InfoMan)\
**Post date:** [April 4, 2018, 7:56am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/1 "2018-04-04T07:56:35Z")

</div>

I have a simple pivot table (in the Query Builder area, not an independent Pivot Grid tab). How can I sort on the data values? I see that I can sort on the rows or columns by clicking on those, but how to sort on the count of or sum of something?

Example, how to sort on the "Count of Line"?

 ![3173.Capture.jpeg](https://global.discourse-cdn.com/quest/original/2X/6/691841e2e315d149a5b552b4d99365a9ddf648cc.jpeg)

---

<div class="post-metadata">

**Author:** ![Petr.Hodovsky](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@Petr.Hodovsky](https://forums.toadworld.com/u/Petr.Hodovsky)\
**Post date:** [April 5, 2018, 6:16am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/2 "2018-04-05T06:16:07Z")

</div>

Hello InfoMan,

We do not support this feature currently.

Petr

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [April 5, 2018, 8:54am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/3 "2018-04-05T08:54:13Z")

</div>

We do plan to support this in the future and this enhancement is entered as QAT-12112

---

<div class="post-metadata">

**Author:** ![InfoMan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/infoman/32/322_2.png) [@InfoMan](https://forums.toadworld.com/u/InfoMan)\
**Post date:** [January 23, 2019, 9:34pm UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/4 "2019-01-23T21:34:19Z")

</div>

It appears that this is available in version 5.0, but it only sorts ascending. It would be nice to also be able to sort descending.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [January 26, 2019, 12:00am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/5 "2019-01-26T00:00:21Z")

</div>

let me look into this.

---

<div class="post-metadata">

**Author:** ![InfoMan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/infoman/32/322_2.png) [@InfoMan](https://forums.toadworld.com/u/InfoMan)\
**Post date:** [January 30, 2019, 7:29pm UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/6 "2019-01-30T19:29:45Z")

</div>

I think that I see how this can work ascending or descending.

1. Create a pivot table with a field in the Row Area and in the Data Area.
2. Right-click the header of the desired field in the Data Area, select Sort By…the Pivot is now sorting on that field ASCENDING.
3. Click the header of the field in the Row Area. This will cause the Pivot to sort DESCENDING based on the field in the Data Area earlier.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [January 31, 2019, 5:24am UTC](https://forums.toadworld.com/t/pivot-grid-how-to-sort-by-data-area-values/40797/7 "2019-01-31T05:24:15Z")

</div>

I had this on my list to verify today. but you got it.

 ![sort](https://global.discourse-cdn.com/quest/original/2X/8/827c7da5922f557d1442ff4c6c1f645613328ac1.png)
