# Row calculation in Enhanced Table **URL:** \ **Category:** Kibana\ **Created:** [October 19, 2022, 8:32am UTC](https://discuss.elastic.co/t/row-calculation-in-enhanced-table/316971 "2022-10-19T08:32:14Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Seemant\_Bind](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seemant_bind/32/107045_2.png) [@Seemant\_Bind](https://discuss.elastic.co/u/Seemant_Bind)\ **Post date:** [October 19, 2022, 8:32am UTC](https://discuss.elastic.co/t/row-calculation-in-enhanced-table/316971/1 "2022-10-19T08:32:14Z")
Hi, I am trying to calculate row in the enhanced table where I am computing row1/ Grand total i.e. 30/187 =16.04%, refer to the pic attached with post. I have tried this in enhanced table but couldn't find any such feature. Any idea how to achieve this in enhanced table or any other alternate visual to achieve it? ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/5/15d2cd95cd84ff9b084dc80598aca062df1330d7.png) ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [October 19, 2022, 3:38pm UTC](https://discuss.elastic.co/t/row-calculation-in-enhanced-table/316971/2 "2022-10-19T15:38:45Z")
Hi @Seemant_Bind . It looks like "Enhanced Table" is a third-party plugin so you may have more luck getting help at that project's [repository](https://github.com/fbaligand/kibana-enhanced-table). I will say that it looks like [this feature request](https://github.com/fbaligand/kibana-enhanced-table/issues/169) might already capture what you're looking for. I would have to understand more about your data, but it is possible that a Lens datatable could provide the math you're looking for via the [formula feature](https://www.elastic.co/guide/en/kibana/current/lens.html#lens-formulas). You'd have to transpose your table so the columns would become rows and then do something like this for your "Percentage(row1/ Grand Total)" column (this example assumes that the numbers in your spreadsheet are sums). ![Screen Shot 2022-10-19 at 10.32.34 AM](https://us1.discourse-cdn.com/elastic/original/3X/b/5/b5bcda916a0fff077442ae5cdb93804f6a8fc7dd.png) You could then format it as a percentage using Lens' value format selector. ![Screen Shot 2022-10-19 at 10.41.00 AM](https://us1.discourse-cdn.com/elastic/original/3X/f/1/f1055e37d32c569fc2168d30d9403bdb07f6aadb.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 16, 2022, 2:16am UTC](https://discuss.elastic.co/t/row-calculation-in-enhanced-table/316971/3 "2022-11-16T02:16:00Z")
---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 14, 2022, 2:16am UTC](https://discuss.elastic.co/t/row-calculation-in-enhanced-table/316971/4 "2022-12-14T02:16:24Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.