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?