weekly cumulative sales qty

[wanyunyang]

I'm trying to get a table by Item, with cumulative sales qty each week.

For example, my data is:

I would like the result to be:

So I created a pivot table, Item as row, Week as column, measure is: 

RangeSum(Before(sum(Qty),0,columnno()))

But the result is like this: 

Since A has no sales in Week2, B has no sales in Week3, they're showing Null.

Any idea how to fix this? Thanks in advance!

[JordyWegman]

Hi Wanyunyang,

Try this:

RangeSum(Before(TOTAL Sum(Qty),0,ColumnNo(TOTAL)))

Jordy

Climber 

[wanyunyang]

Hi Jordy,

Thank you for the help! I tried, but didn't work. Same as before.