Pivot table subtotal partial sum not calculating correctly

bobpants — Sat, 16 Nov 2024 04:57:31 GMT

HI,

So I have a pivot table where I simply want the subtotal (partial sum) to be the sum of the row values.

I read a ton of posts and me & a colleague spent about 7 hours trying every form of SUM and AGGR we could think of, but simply cannot get it to total correctly.

On the attached example, Overspend for A should sub total -60 and not -35, and Underspend for A should total 25, but come back with nothing !, similarly subtotals for B should be -43 and 153 respectively.

Can anyone please assist here with some Christmas magic ?!?!?!?

Thanks in advance

Bob

Re: Pivot table subtotal partial sum not calculating correctly

sunny_talwar — Fri, 14 Dec 2018 17:34:27 GMT

Try these expressions

OverSpend

Sum(Aggr(RangeMin(Sum(Budget) - Sum(Spend), 0), Branch, Department))

UnderSpend

Sum(Aggr(RangeMax(Sum(Budget) - Sum(Spend), 0), Branch, Department))

topic Pivot table subtotal partial sum not calculating correctly in QlikView

Pivot table subtotal partial sum not calculating correctly

Re: Pivot table subtotal partial sum not calculating correctly