Re: How to make a chart title formula with conditional dimension label?
Sorry I have tried to make the question a little bit more explicit, one if statement in the master item gives the variable for the table and the other if statement gives the label. The I simply use the master item variable in my chart and the rest is done for me e.g. the dimension label for the legend.
However, when editing a chart title you can only use a couple of lines I dont know why, so my nested if statement doesnt work. therefore I need a workaround and I imagine a way to refer directly to the label or the variable would help. Sorry if this is a little complex.