How does the pivot table accumulate weekly calculations

[Nora104]

The below is sales quantity of every week:

I want it to be like this, cumulative calculation weekly：

But I don't know how to write the formula.

I use the formula:sum(total<Code>Qty)

But the result is the below:

How can I write the formula?

[sergio0592]

Hi,

Maybe try to check 'Accumulate' box in Expression tab.

[martinpohl · Accepted solution]

in pivot table, the accumulate button is not available

use this expression:

rangesum(before(sum(Qty),0,99))

Regards