Calculate in range

[Godtooro]

Dear all,

First of all thank you for your support. Wish you can help me.

I'm stuck at this trick. I've the next table:

Postin Date	Invoice number	Article	Units	Unit Cost
01/01/2020	10000	RedCar	50	3,50 €
02/01/2020	10001	RedCar	10	3,60 €
03/01/2020	10002	RedCar	5	3,70 €
04/01/2020	10003	RedCar	3	3,80 €
05/01/2020	10004	RedCar	1	3,90 €

I need that Qlik calculate the total cost per invoice as the next table:

Postin Date	Invoice number	Article	Units	Unit Cost	¿This Total Cost in Qlik Sense?How to?
01/01/2020	10000	RedCar	50	3,50 €	175,00 €
02/01/2020	10001	RedCar	10	3,60 €	36,00 €
03/01/2020	10002	RedCar	5	3,70 €	18,50 €
04/01/2020	10003	RedCar	3	3,80 €	11,40 €
05/01/2020	10004	RedCar	1	3,90 €	3,90 €

This total cost is: 244.80€

What I'm reaching it at the control panel the results obtained at qlik are the next ones:

Postin Date	Invoice number	Article	Units	Unit Cost
01/01/2020	10000	RedCar	50	3,50 €
02/01/2020	10001	RedCar	10	3,60 €
03/01/2020	10002	RedCar	5	3,70 €
04/01/2020	10003	RedCar	3	3,80 €
05/01/2020	10004	RedCar	1	3,90 €
			Average cost	3,70 €
			Total(average cost * total units)	255,30 €

Total cost: 255.30€ comes from an average and not from every invoice.

Do you know how can I calculate per invoice?

Thank you for your support again.