Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a reference line that is dynamic based on the dimension selected in the chart. I am currently trying to use getObjectField() to do this but I can't get it to work. It looks like this:
=avg(total aggr(avg([Is In Arrears (MonthEnd)])
,$(= '[' & getobjectfield(0,'GnfAza') & ']')
,$(= '[' & getobjectfield(1,'GnfAza') & ']')
))
Can anyone help please?