Skip to Content
0
Former Member
Nov 22, 2012 at 02:03 PM

Problem with summing on Webi Report

40 Views

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