Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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