subtract two columns in QlikView

[newqlik2017]

Hi,

What's the better way to  calculate the output table based on input table below?

Category, state are dimensions. Amount fields are expressions in a straight table in QlikView.

Input:

Category	State	Amount1	Amount2
A1	CA	-	1,000
A1	NY	-	1,500
B2	CA	5,000	-
B2	NY	4,500	-

Output:

Category	State	Amount
B2	CA	4,000
B2	NY	3,000

[Taoufiq_Zarra]

@newqlik2017  can you elaborate ?