summing row

[raadwiptec]

I have the following pivot structure in Qlik, These are the installments that has been paid.. I looking for a way to sum this up at row level..in a new field ( Not the Totals) 

For Ex: if the current month is 2019 May -- Then i should get a sum of  9874 for the reference KBC093223232

If the Current month is august then it should be 9874 +9874 

Thanks to advise here..

Reference	Date	Dates	01/01/2019	01/02/2019	01/03/2019	01/04/2019	01/05/2019	01/06/2019	01/07/2019	01/08/2019	01/09/2019	01/10/2019	01/11/2019	01/12/2019	01/01/2020
KBC093223232	30/01/2019		9,874	-	-	-	-	-	9,874	-	-	-	-	-	0
	-	0	-	-	-	-	-	0	-	-	-	-	-
	-	-	0	-	-	-	-	-	0	-	-	-	-
	-	-	-	0	-	-	-	-	-	0	-	-	-
	-	-	-	-	0	-	-	-	-	-	0	-	-
	-	-	-	-	-	0	-	-	-	-	-	0	-
KBC9232323w	17/03/2019		0	-	-	-	-	-	-	-	-	-	-	-	-
	-	0	-	-	-	-	-	-	-	-	-	-	-
	-	-	5,392	-	-	-	5,392	-	-	-	5,392	-	-
	-	-	-	0	-	-	-	0	-	-	-	0	-
	-	-	-	-	0	-	-	-	0	-	-	-	0
	-	-	-	-	-	0	-	-	-	0	-	-	-

[Vegar]

I think you will need to explain your data once more, because it is not obvious how you get 9874 for May and 19 748 for August. 

Anyway, I would assume you will need to use crosstable() in the script in order to get the data structured in a way that supports  the calculations you need to do in the application.