Skip to Content
Former Member
Sep 27, 2010 at 11:41 AM

Hierarchies Drill Down - Starting Level 2


Hi Team,

The Crystal Report I am working on is built on a BEx Query which has a hierarchy drill down to level 9. I have restricted the hierarchy to Level 7 in BEx (report requirement).

The Root Node of the hierarchy is a dummy node and I have suppressed it in Crystal. I have to Summarize across the Hierarchy for Average at each level and a Global calculation at the Top Level. The Top Level Average Calculation is including the Root Node which is leading to incorrect values.

Please let me know if there is a way I can restrict the Average Calculation to omit the Root Level Hierarchy from calculation.

Thanks & regards,