Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
in pivot table, the accumulate button is not available
use this expression:
rangesum(before(sum(Qty),0,99))
Regards
Hi,
Maybe try to check 'Accumulate' box in Expression tab.
in pivot table, the accumulate button is not available
use this expression:
rangesum(before(sum(Qty),0,99))
Regards