Trying to display sum of rows for an expression as Window Title
I have a straight table with a MonthYear dimension, and three expressions. The first is just sum(forecast). The second is a linear trendline expression that looks something like:
The third expression is simply Column(1)-Column(2). Basically, I'm showing the difference between forecast and the sales trendline value for a given month. I'm using sum of rows as expression total for columns 2 and 3. All that works.
What I am trying to do is somehow get the window title to contain the sum of rows of column 3. The plan is to have this object minimzed 99% of the time, with only that number showing (what the user cares about most). Then they can open it up if they want more detail.
So, any idea how to get that number as the window title? Copying the text of expression 1 - expression 2 doesn't work, that's for sure. I don't think the linear equation will work in a non-dimensional context.
