Forum Discussion
Avoid interrupted hierarchy summation
I have data from 1980 to 2030 which I structure in a five level hierarchy tree (the hierarchy is defined in a separate table and then connected to the actual data via a relationship). After 2017,...
HI LP135,
It is impossible to custom on hierarchy column, maybe you can try to parent child hierarchy.
For measure, it is possible add conditions to replace value when current hierarchy level is blank and use replace value in calculations.
Regards,
Xiaoxin Sheng