Сalculation with unbalanced hierarchy on the Gantt Chart

124 views
0

Hi!

Question about calculation values such as progress, date end, date start, categories, measures based on data from table with unbalanced hierarchy.

For example, in this case:

1. Gantt chart2. Table with data

For first level hierarchy instead of automatic calculation (start date as minimum start date from second level hierarchy, progress as average progress from second level hierarchy, etc.), we need to get values directly from this row

And for second level hierarchy, instead of calculation based on the third hierarchy level, we need to just get values directly from row that keep information about second hierarchy level

Is there a way to do this kind of calculation?

Thanks

Edited question