topic Re: weekly cumulative sales qty in App Development

weekly cumulative sales qty

wanyunyang — Fri, 02 Apr 2021 08:11:09 GMT

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 — Wed, 13 Nov 2019 14:23:40 GMT

Hi Wanyunyang,

Try this:

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

Jordy

Climber

wanyunyang — Wed, 13 Nov 2019 14:36:07 GMT

Hi Jordy,

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