Partial sum on Pivot

[abeyphilip]

Hi,

Is there any way to achieve the following in qlikview. The problem here is, it requires one calculation logic for individual values and another when the partial sums are to be shown. The values for R and O are directly available per Desc, per (A/B/C) . P is to be calcualated as O * (1-R) and Q as O-P.

And for totals, O,P and Q are calculated by adding only the rows above it. But for R, it is to be calcualated as Q/P. Partial sum in pivot can work fine for O,P and Q  but not for R.

Any help would be greatly received..

Thanks,

Abey

Attaching the sample output.

[whiteline · Accepted solution]

There is a dimentionality() function that can be used to determine the level of calculation.

You can use something like this:

=if(dimentionality() = 2, R, Q/P)

[abeyphilip]

Hi,

Brilliant. Worked perfectly. Thanks.

My actual model was different and had to consider other things as well, but key was using dimensionlaity.

Regards,

Abey.