Subtracting same column values in QlikSense table chart

[Aditya_Chitale]

Hello All,

I have a table chart in frontend which containg data as below

Business	Month	Sales
Direct	Apr	100
Direct	May	200
Direct	Jun	300
Direct	Jul	400
Direct	Aug	500
Indirect	Apr	10
Indirect	May	20
Indirect	Jun	30
Indirect	Jul	40
Indirect	Aug	50

I want to subtract Business=Indirect value for month of Apr from Business=Direct and show in a separate table chart.

(here for Apr = 100 - 10). Similar for all months

Desired output:

Business	Month	Sales
Net	Apr	90
Net	May	180
Net	Jun	270
Net	Jul	360
Net	Aug	450

Regards,

Aditya

[BrunPierre]

Try

Sum(Aggr(Sum({<Business={'Direct'}>}Sales),Month))- Sum(Aggr(Sum({<Business={'Indirect'}>}Sales),Month))