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,