topic Re: Cumulative sum in Pivot Table in App Development

Cumulative sum in Pivot Table

alejovacca — Wed, 10 Apr 2019 16:07:10 GMT

Hi guys,

I am trying to do a cumulative sum of the values in the column ToShip for each Product Group. The red numbers are the expected values.

I was trying to use the formula RangeSum(Above([To Ship], 0, RowNo()))but a I get the same value that [To Ship] column.

Do you have any idea?

Thanks in advance

dplr-rn — Wed, 10 Apr 2019 16:52:38 GMT

thats the right idea.

try this
RangeSum(Above(Sum([To Ship]), 0, RowNo()))

if not try diagnose by checking what above([To Ship]) returns

alejovacca — Wed, 10 Apr 2019 17:19:11 GMT

Yes, I used the sum inside above but it doesn't work.