# Doing aggregation as in an OLAP CUBE **URL:** \ **Category:** Kibana\ **Created:** [October 10, 2019, 1:56pm UTC](https://discuss.elastic.co/t/doing-aggregation-as-in-an-olap-cube/203040 "2019-10-10T13:56:58Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![cderudde](https://avatars.discourse-cdn.com/v4/letter/c/b5e925/32.png) [@cderudde](https://discuss.elastic.co/u/cderudde)\ **Post date:** [October 10, 2019, 1:56pm UTC](https://discuss.elastic.co/t/doing-aggregation-as-in-an-olap-cube/203040/1 "2019-10-10T13:56:58Z")
I'm new to ELK is there a way doing aggregagtion as in OLAP CUBE. Example: rate by departement, then rate by office. Doesn't seem to work, everytime the rate is calculated on each doc and doesn't aggeagrate correctly to analysis axes. Any help? I'm afraid to be near to failed in my POC... Thanks a lot Carine ---
**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\ **Post date:** [October 10, 2019, 8:26pm UTC](https://discuss.elastic.co/t/doing-aggregation-as-in-an-olap-cube/203040/2 "2019-10-10T20:26:48Z")
Can you provide some more information as to where you are with this? What is the visualization you have configured? Are you wanting a histogram with a derivative aggregation of two fields? ---
**Author:** ![cderudde](https://avatars.discourse-cdn.com/v4/letter/c/b5e925/32.png) [@cderudde](https://discuss.elastic.co/u/cderudde)\ **Post date:** [October 11, 2019, 8:08am UTC](https://discuss.elastic.co/t/doing-aggregation-as-in-an-olap-cube/203040/3 "2019-10-11T08:08:07Z")
Hello Tyler, many thanks for your help, here is the problem with simple data in the picture below. ![2019-10-11_10h04_47](https://us1.discourse-cdn.com/elastic/original/3X/1/d/1d43bc9a5bb09187d429dbea2f62aac80278a785.png) So Olap knows how to do calculate with hierarchy. I thought i could do reporting with Kibana because it's very fast but users wants to analyse data with filter.... Thanks for your help Carine ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 8, 2019, 8:08am UTC](https://discuss.elastic.co/t/doing-aggregation-as-in-an-olap-cube/203040/4 "2019-11-08T08:08:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.