Please add a new aggregation option that can be used specifically for parent calculations when working with shadow calculations.
Currently, the hidden column calculation used together with Weighted Average can produce correct parent-level calculations for this specific scenario. We would like logic to be introduced that injects the appropriate calculation behavior automatically when this use case is wanted.

Photo Viewer

View photos in a modal