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?