Are you saying that you want a computed value to be part of the Worksheet title?
I for one don't know of a way to do that. You can have a Parameter in the Title, but I've never seen a Measure Value be dynamically populated into a Title. Let's see if someone has something.
yes...I calculated the variables r (correlation coefficient) and though is would be nice to display on the worksheet's scatter plot (title)...?
Well you're not going to have a dynamic Title for a Worksheet.
What you can do is build a Dashboard, in which one of the Worksheets is a Crosstab containing the measure name and measure value you have computed, along with some text to build out what would visually look like a title, but not be an actual Title of an Actual Worksheet.
?when I create these variables (calculated fields), I often just want the value (one time) and want to display it (the correlation value, the t-test values, etc.)...
?what is the best way to do this...?
thank you...looking further...
ps how did you calculate R (i.e., may I see your calculated fields)?
//R-Squared for Sales and Profit
(SUM([Profit]) - WINDOW_AVG(SUM([Profit]))) / WINDOW_STDEV(SUM([Profit]))*
(SUM([Sales]) - WINDOW_AVG(SUM([Sales]))) / WINDOW_STDEV(SUM([Sales]))
rSquared.twbx 1.5 MB
thank you...most helpful...
as I "wrestle" with the R functions, did you see my ANOVA posting (how to use aov)?
and I practiced with the Z value calculation:
(SUM([Product Revenue])-[Average Sales])/[STDEVP Sales](SUM([Product Revenue])-[Average Sales])/[STDEVP Sales]