You and try this
SUM([Field 2]) * [Field_3]
Many thanks for the reply. I am hoping to use this calculated field (SUM([Field 2]) * [Field_3]) to generate another variable by comparing it with a non aggregate field. for example lets take multiplication of Field 2 and Field 3 equal to Field 4, Now I need to create another variable as Field 5 by comparing Field 4 with another non aggregate field. Can I do these kind of operations??
(SUM([Field 2]) * [Field_3]) provides correct calculation but it is an aggregate dimension.
I think you should have at least one dimension to identify your each records. I'm not finding any solution without aggregation. You've to use agg functions.