Hierarchy - is this possible?

[#1]

Hi there,

does anyone have an idea how to create a hierarchy table to show last child in missing child fields (see example).

Br,

Przemek

[#2 · Accepted solution]

Hello Przemek,

if I got you right, take a look at the calculated dimensions in your chart:

Regards,

Roland

[#3]

Thanks, Roland. Looks good! I'm now wondering whether it can also be done dynamically i.e. when you add/remove a dimension it gets filled with last child.

BR,

Przemek

[#4]

Hi Przemek,

take a look at the expressions. It shows in every dim the very last child (wasn't it "AccName"?). So if you delete one of the dims in the chart the others should work as well.

RR