Hi Experts
I am new to Webi.
I have a report with only 2 columns. The first column contains a hierarchy element, which can be drilled into. The 2nd column contains an amount.
I have added a sum function to the table so that the amount is totaled at bottom of the page.
My problem come in when I drill into the Hierarchy. My sum increases, because it now it sums all the values in the column, not just the parents.
Is there a way to get the sum to only consider the 1st level in the hierarchy?
Thanks in advance
Anton Kruse