# How to show Sum in K, Laks, Crores

**URL:** <https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277>\
**Category:** Kibana\
**Created:** [May 9, 2019, 4:45am UTC](https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277 "2019-05-09T04:45:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lakshykar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lakshykar/32/43198_2.png) [@lakshykar](https://discuss.elastic.co/u/lakshykar)\
**Post date:** [May 9, 2019, 4:45am UTC](https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277/1 "2019-05-09T04:45:32Z")

</div>

Hi,

I am trying to create a dashboard, and there are some aggregated number, like sum of loan amount.

On the dashboard can i do something to show number like 1.2 Cr, or 1k.  
Right now sum showing like 28,250,000 Can i show number like this 2.8 Cr?

![Screenshot%20from%202019-05-09%2010-14-48](https://us1.discourse-cdn.com/elastic/original/3X/b/5/b5bd995359360b48f71b1921ba89b1187caf11f0.png)

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [May 9, 2019, 3:50pm UTC](https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277/2 "2019-05-09T15:50:55Z")

</div>

> can i do something to show number like 1.2 Cr, or 1k

Yes. You can set up field formatters on the index pattern to format fields as needed.

Go to management -\> index patterns and open your index pattern. Find the field and click the edit button.

 ![51%20AM](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7ed0c1d9c4e2e87065a8db53740d213b3de6ec35.png)

Add a formatter that formats the value as expected. See [https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html](https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html) for more details

---

<div class="post-metadata">

**Author:** ![lakshykar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lakshykar/32/43198_2.png) [@lakshykar](https://discuss.elastic.co/u/lakshykar)\
**Post date:** [May 10, 2019, 6:28am UTC](https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277/3 "2019-05-10T06:28:36Z")

</div>

Thanks for the help

---

<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:** [June 7, 2019, 6:28am UTC](https://discuss.elastic.co/t/how-to-show-sum-in-k-laks-crores/180277/4 "2019-06-07T06:28:44Z")

</div>

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