# Multiple Sum subaggregations at same level using Java API

**URL:** <https://discuss.elastic.co/t/multiple-sum-subaggregations-at-same-level-using-java-api/70994>\
**Category:** Elasticsearch\
**Created:** [January 9, 2017, 8:38pm UTC](https://discuss.elastic.co/t/multiple-sum-subaggregations-at-same-level-using-java-api/70994 "2017-01-09T20:38:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JonathanAaron](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jonathanaaron/32/24405_2.png) [@JonathanAaron](https://discuss.elastic.co/u/JonathanAaron)\
**Post date:** [January 9, 2017, 8:38pm UTC](https://discuss.elastic.co/t/multiple-sum-subaggregations-at-same-level-using-java-api/70994/1 "2017-01-09T20:38:40Z")

</div>

Any way to add the subaggregations to my query? I'm trying to clean up my code. Here's what it looks like now.

```
builder.setQuery(query)
   .addAggregation(AggregationBuilders.terms("group_by_this_field").field("this_field")
		  .subAggregation(AggregationBuilders.terms("group_by_that_field")
											 .field("that_field")
											 .subAggregation(AggregationBuilders
													 .sum("field_1")
													 .field("field_1"))
											 .subAggregation(AggregationBuilders
													 .sum("field_2")
													 .field("field_2"))
											 .subAggregation(AggregationBuilders
													 .sum("field_3")
													 .field("field_3")).subAggregation(AggregationBuilders
														 .topHits("agg_source")
														 .fetchSource(aggSource, new String[0])))));
```

---

<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:** [February 6, 2017, 8:38pm UTC](https://discuss.elastic.co/t/multiple-sum-subaggregations-at-same-level-using-java-api/70994/2 "2017-02-06T20:38:45Z")

</div>

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