# How to add a sum for all columns in a table view

**URL:** <https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888>\
**Category:** Kibana\
**Created:** [October 4, 2020, 8:28am UTC](https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888 "2020-10-04T08:28:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\
**Post date:** [October 4, 2020, 8:28am UTC](https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888/1 "2020-10-04T08:28:22Z")

</div>

Hi all,

I need to add a table view in my kibana dashboard with a sum for all columns like Excel. (see the picture.

Is there any idea.

Best Regards  
Hamid

![Table](https://us1.discourse-cdn.com/elastic/original/3X/6/0/601e996f1381a6a862af96895bdaaaaa5ba4afed.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 4, 2020, 1:46pm UTC](https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888/2 "2020-10-04T13:46:58Z")

</div>

If you are using the data table visualization, there is a "Show total" setting in the Options tab:

 ![Screen Shot 2020-10-04 at 15.46.05](https://us1.discourse-cdn.com/elastic/original/3X/5/0/50fb748dc8bf688c8ae880368e051793ecf8c217.png). This together with a "Total function" of Sum should do what you want to see.

---

<div class="post-metadata">

**Author:** ![hzarrabi](https://avatars.discourse-cdn.com/v4/letter/h/f9ae1b/32.png) [@hzarrabi](https://discuss.elastic.co/u/hzarrabi)\
**Post date:** [October 5, 2020, 7:00am UTC](https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888/3 "2020-10-05T07:00:13Z")

</div>

Hi Joe,

Thanks a lot for the solution. I have set it alreday. But it adds the sum on the count of the first column that is registerd.  
Which I need is to have a total sum for each column as I've shown in the picture attached to my post.

Do you have any idea about it please ?  
Best regards

---

<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:** [November 2, 2020, 7:00am UTC](https://discuss.elastic.co/t/how-to-add-a-sum-for-all-columns-in-a-table-view/250888/4 "2020-11-02T07:00:28Z")

</div>

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