# Kibana Enhanced Table 2 Total Values on Different Condition

**URL:** <https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913>\
**Category:** Kibana\
**Created:** [November 23, 2021, 7:35am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913 "2021-11-23T07:35:46Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Avnish\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/avnish_singh/32/71923_2.png) [@Avnish\_Singh](https://discuss.elastic.co/u/Avnish_Singh)\
**Post date:** [November 23, 2021, 7:35am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/1 "2021-11-23T07:35:46Z")

</div>

Hi, I have created an enhanced table now there is an option to do a sum on a computed column but it does the sum of the entire column whereas I want 2 sums based on condition.  
Is it possible if yes then how?

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 9:47am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/2 "2021-11-23T09:47:59Z")

</div>

Hi @Avnish_Singh -- It sounds like this feature is specific to the enhanced table plugin... The team at Elastic doesn't maintain that plugin, but our friend @fbaligand does. He may be able to provide you with more guidance as to whether this is an issue with the plugin, or with Kibana itself.

You may also consider [opening an issue](https://github.com/fbaligand/kibana-enhanced-table/issues/new) in the enhanced table repo in case your question doesn't get answered here.

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [November 23, 2021, 1:05pm UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/3 "2021-11-23T13:05:13Z")

</div>

Hi,

I’m not sure to fully understand your need.  
Could you give a more precise example, with data, formulas, expected results, eventually snapshots?

---

<div class="post-metadata">

**Author:** ![Avnish\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/avnish_singh/32/71923_2.png) [@Avnish\_Singh](https://discuss.elastic.co/u/Avnish_Singh)\
**Post date:** [November 23, 2021, 3:29pm UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/4 "2021-11-23T15:29:34Z")

</div>

I have attached the Screenshot as of now there is 1 Total Sum Value But I need 2 sum values which I have mentioned in the screenshot.

 ![Screenshot (9)](https://us1.discourse-cdn.com/elastic/original/3X/1/1/11426c078ad8697d7cec1530df20babee4692979.png)

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [November 23, 2021, 4:43pm UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/5 "2021-11-23T16:43:56Z")

</div>

Well, you can’t do this sum as is.  
But you can create a computed column for sum1, where column value is conditional, based on Register column. And another computed column for sum2.

---

<div class="post-metadata">

**Author:** ![Avnish\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/avnish_singh/32/71923_2.png) [@Avnish\_Singh](https://discuss.elastic.co/u/Avnish_Singh)\
**Post date:** [November 24, 2021, 7:19am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/6 "2021-11-24T07:19:00Z")

</div>

Thanks, @fbaligand and your enhanced table plugin is awesome man, Great work have a good day!

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [November 24, 2021, 7:33am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/7 "2021-11-24T07:33:23Z")

</div>

Thanks, happy to see that you enjoy it!

---

<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:** [December 22, 2021, 7:33am UTC](https://discuss.elastic.co/t/kibana-enhanced-table-2-total-values-on-different-condition/289913/8 "2021-12-22T07:33:42Z")

</div>

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