Footnotes in tree chart with drill down dimension

[Mark4]

Hello Community,

Is there a way to use a calculation in the footote of a tree chart showing the next selection in a dimension drill down?

For example, my master dimension drill down is:

Field 1 (fx)

Field 2 (fx)

Field 3 (fx)

If Field 1 is defaulted I would like the footnote to say: "Make a selection to view (Field 2)"

If Field 2 is selected I would like the footnote to say "Make a selection to view (Field 3)"

and so on.

I tried an if(isnull() calculation and it broke down around the third selection.

Any ideas?

[y_grynechko · Accepted solution]

Hey,

=if(GetSelectedCount([Field (1)]) < 1 ,'Make a selection to view (Field 2)',
if(GetSelectedCount([Field (2)]) < 1 ,'Make a selection to view (Field 3)',
'No more drill downs'))

You need to add a couple more ifs to work with cases like: Field 2 is selected but Field 1 is not but I am sure you are going to figure that out.