Sum values from column in different column and then use the summation result in further calculation

Summary: Sum values from a column in different column and then use the summation result in further calculation

Content (please ensure you mask any confidential information):

Hello All,

We have a requirement where in lets suppose we have three columns A, B and C. The calculation would be work like column B should have sum of all values in column A and then column C should be column B*100. I understand that summation of a column can be done by utilizing the miscellaneous Rate column in any of the components but showing the sum total in summary but how would I again utilize the summation value for further calculation.