# Query that sum balance of different event

**URL:** <https://discuss.elastic.co/t/query-that-sum-balance-of-different-event/157055>\
**Category:** Elasticsearch\
**Created:** [November 16, 2018, 12:41pm UTC](https://discuss.elastic.co/t/query-that-sum-balance-of-different-event/157055 "2018-11-16T12:41:23Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Nikhil\_Nambiar](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@Nikhil\_Nambiar](https://discuss.elastic.co/u/Nikhil_Nambiar)\
**Post date:** [November 20, 2018, 2:25am UTC](https://discuss.elastic.co/t/query-that-sum-balance-of-different-event/157055/3 "2018-11-20T02:25:43Z")

</div>

I have rephrased the query and I have posted till which point I got success and where it's breaking in below link

> [@Query to display terms associated to a filter aggregation on particular event](https://discuss.elastic.co/t/query-to-display-terms-associated-to-a-filter-aggregation-on-particular-event/157183):
>
> Hi, I need a help for an elastic search query, My query below is as follows { "size":0, "aggs":{ "group-by-customerid":{ "terms":{ "field":"customer\_id.keyword" }, "aggs":{ "card-load":{ "filter":{ "term":{ "Event":2003 } }, "aggs":{ "load-balance":{ "terms":{ "field":"balance" …

---

_[View the full topic](https://discuss.elastic.co/t/query-that-sum-balance-of-different-event/157055)._