# Data Table with split table ordering

**URL:** https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030
**Category:** Kibana
**Created:** [January 18, 2018, 11:37am UTC](https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030 "2018-01-18T11:37:52Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Tomas\_Law](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@Tomas\_Law](https://discuss.elastic.co/u/Tomas_Law)
#### Post date: [January 18, 2018, 11:37am UTC](https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030/1 "2018-01-18T11:37:52Z")

</div>

Hello,

After a couple split rows and split tables aggregations I get the following result:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/0/30d9c47599ab7a0961b150e733cc611184ea6571.png)

The most important metric I get comes from the Total function in the visualization Options which is the Sum (circled in red). I want to order the splitted tables according to the sum value (left: highest sum- \>right: lowest sum) but I don't know how to use this Sum value to order them.

![image](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d11bc4dea9fa9c45f1f763eada235a55ebe993ae.png)

How can I do it?

Thank you

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [January 18, 2018, 8:38pm UTC](https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030/2 "2018-01-18T20:38:51Z")

</div>

You'd have to do the split table aggregation first. I'm not sure if that would give you the results you want in your visualization though.

---

<div class="post-metadata">

### Author: ![Tomas\_Law](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@Tomas\_Law](https://discuss.elastic.co/u/Tomas_Law)
#### Post date: [January 19, 2018, 3:51pm UTC](https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030/3 "2018-01-19T15:51:17Z")

</div>

Hey Lukas,

Thanks for replying on both of my posts 😉

Yep, doing the split table aggregation first selects all the terms initially available but, as you said, I only want the terms after I did a couple split row aggregations...

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 16, 2018, 3:51pm UTC](https://discuss.elastic.co/t/data-table-with-split-table-ordering/116030/4 "2018-02-16T15:51:42Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.