Creating a variable to Sum the column (WEBI)

[agarg]

Hello everyone,

I am working on a report which looks like:

Machine Type	Unique Machine ID	Number of bins in machine	Sales A	Sales B	Sales C = Sales A + Sales B
M 1	123	1 (coming from machine type)	10	20	30
M 2	212	2	20	20	40
M 2	231	2	15	15	30
M 3	234	3	10	10	20
M 1	567	1	10	20	30
M 1	224	1	15	15	30

I want to create a summary report which shows Sales C for each Machine Type i.e. M1, M2 and M3. But I tried doing it by setting Machine Type as section and applying break. But I am unable to sum the sales for respective Machine Types. I don't want to use the "sum" from "Analysis", I want to do it by creating a separate variable. I want result like:

Machine Type	Number of bins in machine	v_Total_Sales
M 1	1	90
M 2	2	70
M 3	3	20

I am using WeBI. Can you help?

Thank you for your help!!