I believe what you are looking would require a Table Calculation to get this done. I copied the data that you provided and got to the attached view using the following Table Calculation:
SUM([temperature]) / TOTAL(SUM([temperature]))
Is this what you were looking for?
Percent of Total.twbx.zip 8.7 KB
Hi, Siraj, what I'm asking is how to create another column "T_max" of which the value is the max value of the first column "T":
Using the workbook Siraj created, create a calculated field similar to the following:
Then, depending how the view is set up, it may be necessary to edit how the calculation is computed (to do this, right click and select Compute Using...)
Hope this helps!