What is the "admission compared to yearly average" calculation?
It's equal to [Admission]/TOTAL([Admission]) across the instname variable (institutions).
Do you know whether it is possible to simply save the Tableau calculations as new variables added to the data set, rather than have them always tied to the sheet (and table) in which they were created? I think that would solve all my difficulties. However, I have been unable to find any means to do this.
Thank you so much,
Do you have Tableau Server 7.0? One option would be to create the data as you would like it, with the desired calculations, and publish it up to the Data Server--then you could use this as the data source for each workbook that you want to use these calculations. The following provides further information on Tableau Data Server:
Hope this helps!