# How to combine elasticsearch aggregation results to category navigation
**URL:** https://discuss.elastic.co/t/how-to-combine-elasticsearch-aggregation-results-to-category-navigation/24642
**Category:** Elasticsearch
**Created:** [June 30, 2015, 4:15pm UTC](https://discuss.elastic.co/t/how-to-combine-elasticsearch-aggregation-results-to-category-navigation/24642 "2015-06-30T16:15:34Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@elastiq](https://discuss.elastic.co/u/elastiq)
#### Post date: [June 30, 2015, 4:15pm UTC](https://discuss.elastic.co/t/how-to-combine-elasticsearch-aggregation-results-to-category-navigation/24642/1 "2015-06-30T16:15:34Z")
Let's say I have infinite hierarchical category menu achieved by some other datastore (In my case should be mongodb). Now I want to add faceted filter feature, I want the category to be recalculated as the user applies a filter. Should hierarchical menu be stored in elasticsearch or should I take two queries from two databases and combine them somehow in my application. I see no easy way I might have a wrong thinking since I am new to elasticsearch. Also I read elasticsearch shouldn't be used as primary database so category should not be stored in it I guess.
-Here I gave two cases as an example to explain better
Case 1: If I go to automobile category it contains lots of sub-categories as car brands and in parentheses it has item counts. As Shown in image below
Also this is the link [http://www.sahibinden.com/otomobil](http://www.sahibinden.com/otomobil)
Case 2: The link is here [http://www.sahibinden.com/otomobil?price=450001-500000](http://www.sahibinden.com/otomobil?price=450001-500000)
As I applied price range between 400k&500k sub categories of Otomobil (brands) greatly reduced and their counts as well.
How do I achieve such kind of functionality
---
### Author:  [@basti](https://discuss.elastic.co/u/basti)
#### Post date: [March 8, 2016, 7:19pm UTC](https://discuss.elastic.co/t/how-to-combine-elasticsearch-aggregation-results-to-category-navigation/24642/2 "2016-03-08T19:19:14Z")
@elastiq: did you found a solution? I am just searching for a solution to this problem also....
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:10pm UTC](https://discuss.elastic.co/t/how-to-combine-elasticsearch-aggregation-results-to-category-navigation/24642/3 "2017-07-05T23:10:13Z")