Showing results for 
Search instead for 
Did you mean: 

Suppress hierarchy aggregation


I need to suppress aggregation on certain nodes in a hierarchy. For example, I have an hierarchy:






subnode11 should aggregate data as usual, subnode2 too, but the node1 should display no data for keyfigures.

Is there any way to do this in the query? It's easy with a custom Excel workbook or Web-Template, but I see no way to do it in the query.

Best regards,


View Entire Topic
0 Kudos

We have resolved to use macros to blank out lines that shouldn't contain aggregate values.