Reference Section Title in Script

[ksharpes]

Hello,

Am I able to reference my Section title within the script?

[marcus_sommer]

AFAIK no - but you could reference on already loaded tables/data and also use sub-routines and/or variables to avoid redundant stuff.

- Marcus

[ksharpes · Accepted solution]

So I actually worked out a way to get around this.

Rather than use a Variable in my expression, i have used a StateName() and then created a statename for each of the options needed then assigned the state to the chart.

I am unsure of the impact it will have on the speed of the app as yet, but will report back if any issues arise.

The below is part of the expression I am using for reference:

Sum({1<[BU15]={"$(=Statename())"}>}[Sales Value] )