# Adding a new column to a data table from a calculation based on two different columns in the same row

**URL:** <https://discuss.elastic.co/t/adding-a-new-column-to-a-data-table-from-a-calculation-based-on-two-different-columns-in-the-same-row/202022>\
**Category:** Kibana\
**Created:** [October 2, 2019, 5:41pm UTC](https://discuss.elastic.co/t/adding-a-new-column-to-a-data-table-from-a-calculation-based-on-two-different-columns-in-the-same-row/202022 "2019-10-02T17:41:05Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Amphagory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amphagory/32/46127_2.png) [@Amphagory](https://discuss.elastic.co/u/Amphagory)\
**Post date:** [October 2, 2019, 9:12pm UTC](https://discuss.elastic.co/t/adding-a-new-column-to-a-data-table-from-a-calculation-based-on-two-different-columns-in-the-same-row/202022/5 "2019-10-02T21:12:21Z")

</div>

Actually I want to create another new column like the following, where I divide `Calls A` by `Total Calls`

```auto
       Calls A | Calls B | Total Calls | Call A Percentage
Ottawa 1 2 3 33.3%
Toronto 5 4 9 55.6%
Nunavik 0 0 0 0.0%

```

---

_[View the full topic](https://discuss.elastic.co/t/adding-a-new-column-to-a-data-table-from-a-calculation-based-on-two-different-columns-in-the-same-row/202022)._