Skip to Content
Former Member
Sep 29, 2011 at 09:10 AM

Hierarchy: How to suppress duplicated/repeated rows in a BEx query


Hi Gurus.

I have a BEx query which displays data based on a Cost Element hierarchy. When the hierarchy is expanded to leaf level (or any level), all key figures and characteristics are displayed for the leaf level but are also repeated throughout all the levels above.

Is it possible to suppress the repeated rows in higher levels of the hierarchy and display a summary result only?

The issue we have is that if the user wishes to export or save a workbook, they will have to filter and manipulate the report a great deal which is impractical.

I'm hoping it's a simple setting that I've missed. I look forward to receiving the magic answer!! :o)