Question:
Dear friends,
We are getting wrong sub-totals when we use hierarchy in a query but the totals are okay without the hierarchy. Has anyone come across a similar situation and found a solution for the same? Thanks in advance for your help and advice.
Regards
Prakash Kalal
Answer:
the results row when using a heirachy becomes distorted becuase it is worked out depending on how much of the heirarchy you have exploded.
I would be safe an set up calculated KF's to sum up the columns you what.
regards,
Answer:
the results row when using a heirachy becomes distorted becuase it is worked out depending on how much of the heirarchy you have exploded.
I would be safe an set up calculated KF's to sum up the columns you what.
regards,
Answer:
Thanks for your reply pal. It is of great help.
Regards