# Show hierarchy in columns not rows

**URL:** <https://community.eazybi.com/t/show-hierarchy-in-columns-not-rows/9878>\
**Category:** Questions & Answers\
**Created:** [June 24, 2022, 6:41am UTC](https://community.eazybi.com/t/show-hierarchy-in-columns-not-rows/9878 "2022-06-24T06:41:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Howell](https://community.eazybi.com/letter_avatar_proxy/v4/letter/h/dfb087/32.png) [@Howell](https://community.eazybi.com/u/Howell)\
**Post date:** [June 24, 2022, 6:41am UTC](https://community.eazybi.com/t/show-hierarchy-in-columns-not-rows/9878/1 "2022-06-24T06:41:41Z")

</div>

One of our users requested for a report to be displayed in this manner:  
The data below are displayed in the Columns, not in the rows.  
 ![image](https://community.eazybi.com/uploads/default/original/2X/2/2a93f75abcd5d4f5da59393742ed8c2d79794dfe.png)

I tried using Epic Link, Issues but I am getting this result  
 ![image](https://community.eazybi.com/uploads/default/original/2X/7/7e5be000564114907ee7da1cb2295e533ac63180.png)

Is there a way to link the two dimensions so that I can display the data as per the 1st image?  
Thanks in advance!

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [July 4, 2022, 11:16am UTC](https://community.eazybi.com/t/show-hierarchy-in-columns-not-rows/9878/2 "2022-07-04T11:16:51Z")

</div>

Hi @Howell,  
You can use the option to drill into a particular level from the issue level.  
Here is this example report:

- I have the Issue dimension both in Columns and Pages.
- I filter two epics from Pages
- and use option drill into the “Parent” level from the Issue Epic hierarchy.

 ![eazyBI_drill_into_level](https://community.eazybi.com/uploads/default/original/2X/2/2fff749ad394f02394b1dbb19740c8c406e1bd25.jpeg)

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![Howell](https://community.eazybi.com/letter_avatar_proxy/v4/letter/h/dfb087/32.png) [@Howell](https://community.eazybi.com/u/Howell)\
**Post date:** [December 2, 2022, 3:31am UTC](https://community.eazybi.com/t/show-hierarchy-in-columns-not-rows/9878/3 "2022-12-02T03:31:33Z")

</div>

Thanks Gerda it works!  
Sorry for the late response.

I have a scenario which is somewhat similar.  
My report column is using the Project and Issues dimensions.  
The first column of the report is showing components while under it are Epics.

Right now all Epics are showing under each component.  
I want to show only the epics that have the actual component under each component.  
Can this be done without any scripting or calculated field?  
If not, do you have any sample I can follow?

Regards,  
Howell