cancel
Showing results for 
Search instead for 
Did you mean: 

Suppress hierarchy aggregation

Hello!

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

node1

--subnode1

-


subnode11

...

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,

Ilya.

View Entire Topic
0 Kudos

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