Aggregate and sum instead sum and aggregate

[ambi]

Hi Team, 

we are having Spotfire report and trying to migrate to QlikSense. we have a scenario to dived between two rows of values and multiply with other scenario values and then overall total has to be displayed in the chart. 

Here is the expression in written format. 

Sum(

         (Row 1 Column C)

*      [row 2 ColumnA/row 1 ColumnA]

          )

- Sum(Row 1 Column C)

Now the issue is, it is summing overall rows and doing the calculation instead of individual/granular level aggregation and sum which is happening in Spotfire perfectly. 

any help would be much appreciated!

-Ambi

[BrunPierre]

Perhaps you can share sample data and what you expect as an output