cycle expression

[#1]

Hi,

Can anybody tell me how to get the cycle expression lable?

Thanks,

[Gysbert_Wassenaar · Accepted solution]

That's not possible unfortunately. For dimension groups there's the getcurrentfield function, but there's no corresponding function for expression groups.

An alternative would be to create an inline table in the script with the expression labels and create a listbox for that new field. You choose an expression by selecting the label name in the field. You'd have to replace the expression group with an expression that uses the selected name. Something like this: pick(match(only[ExpressionLabel]), 'Label1','Label2',...etc), sum(X), max(X), ...etc)

[#3]

Another way I have tried this is to enter your axis text on the Numbers tab in the "Symbol" input box. For example,

First expression enter "Invoice Count"

Second expression enter "Avg Invoice Amount"

Third Expression "Total Invoice Days"

...

You can then manually move the cycle button by the axis text using Shift + Ctrl + drag.

One thing I have found is that you cannot use line breaks in your "Symbol" field since it will only display one line.