Problem with summing on Webi Report

[Former Member]

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

[Former Member · Accepted solution]

Fixed my own problem using RunningSum