Qlik Sense Cumulative in Pivot restart from 0

[hoangly]

Hi All,

I have this formula for cumulative value in pivot table.

rangesum(before(
sum ({$< DateType = {"Create"}, ActualGIDateYN={"No", "Partial"}
>} EBWOrderQtyNoGI )
,0, ColumnNo()))

It works fine .

Before Week Selection

But when user change Weeks range, the formula restart from 0, cumulative value should be 204 and NOT 80. See below, any suggestion to fix this issue?

Thanks in advance.

After WeekYear changed

[hoangly]

Any body can help me?