Count previous column measure in a Pivot Table

[lewisjackson_eq]

Hi!, I'm looking to count the totals of columns by including the previous weeks data as well in a pivot table. Current data looks like this:

	Date2
Date1	02/10/2017	09/10/2017	23/10/2017
02/10/2017	30	2	9
09/10/2017		15	7
23/10/2017			10

I want it to look like the following, where it is adding the previous column as well for a running total so to speak:

Date2
Date1	02/10/2017	09/10/2017	23/10/2017
02/10/2017	30	32	41
09/10/2017		15	22
23/10/2017			10

would someone be able to point me in the right direction for this?

Cheers

[petter]

You have the Before () inter-record chart functions (and it's siblings).

Before ( Sum (Qty) ) +Sum (Qty) )

Is an example on how you can keep a running total column-wise.

Here is the documentation and further examples:

  Before - chart function ‒ Qlik Sense

[Silambarasan1306]

You have Column() function.

Use Column(1) + Sum(Value)

It will add the previous column value with the sum(value)

[lewisjackson_eq]

This helped immensely. Thanks and bunch!