Thanks for your post. Could you share your workbook in .tbwx format?
Sharing it will "speed-up" the solution time tremendously;)
As I wrote in my original request, there is some sensitive data contained in my worksheet and data sources that I can't share publicly (hence the screenshot where I've even covered up some of the field names with "generic names"). I could try to create a sample worksheet with sample data, but that would require quite a bit of re-work. However, if I don't get any solutions, soon, I will consider that...
I was able to come up with a partial solution by reviewing other posts (e.g. Getting the Average of underlying Aggregate data ) and using the WINDOW_AVG function. I created 3 new calculations that use the WINDOW_AVG function on the original data and then apply it "along table down" to correctly come up with the average values.
But these are repeated for each exercise row (compare screenshot below, Worksheet 2, with original - the last 3 values for each exercise labeled "Curriculum Avg..." are the results of the WINDOW_AVG function). Unfortunately, I'd like these averages to appear at the top of the table, like the "Analysis -> Totals" feature provides.
But, by removing the original data from the Measure Values shelf, "hiding" all but one row of exercises, and then turning off "Show Header" for the first two columns (Exericse Name and # Sessions, which are no longer appropriate), I can get a view that's close to what I want: showing just the average of the data (see below screenshot, Worksheet 3). This is pretty hacky, and I'm sure there's a much better way to do this, but my Tableau skills are not good enough (yet!) to figure this out.
Any suggestions would be much appreciated!