Dear Community,
Does the Board Waterfall Chart handle unbalanced hierarchies correctly when it comes to aggregation?
It appears that the object automatically sums all members, including subgroup totals, which leads to double-counting. For example, when the screen selection is set on the bottom line of a P&L, the system aggregates all rows of the P&L, even those that belong to intermediate subtotal groups within the unbalanced hierarchy.
Are there configuration options or best practices to prevent this automatic aggregation and ensure that only the intended members are included in the Waterfall calculation ( Start / END Bars ) ?