Hi expert,
I create a hierarchy based on following table and data:
I define a child parent hirarchy and filter as below:
data preview , with following value for input parameter:
even though the data result is correct, but hierarchy is wrong as below: