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?