Cumulative / running partial sums

[#1]

Does anyone know a way of making partial sums on a pivot table add on the subtotal above it please?

I am trying to replicate it using Rangesum (Above(  , but I am not having any success with it.

Ideally I would like:

Section                    Account                        Amount

Section 1                 123                               10

Section 1                 124                               15

Subtotal Section 1                                      25

Section  2                 345                              5

Section  2                 567                              10

Subtotal Section 2                                      40

etc.

Thanks,

Chris

[#2 · Accepted solution]

I have solved it:

If(Dimensionality()=1

,Aggr(RangeSum(Above(Sum([Amount]),0,RowNo(TOTAL))),Section)

,IF(Dimensionality()=0

,Sum(Amount)

,Sum((Amount))))

Needs a bit of tweaking but this basically does the job