topic AW:partial sum of pivot table disreagrding the current sellections in QlikView

partial sum of pivot table disreagrding the current sellections

Fri, 18 Mar 2011 07:04:55 GMT

Hello everyone,

I am having trouble with mt pivot table. I am trying to get the figure of that day (not sum of all days) disregarding the current sellections.

Here is a formula I ma currently using. This formula disregards all selections but returns the total of all days.

sum({1<APKO_LIABILITIES_ACIKLAMA = {'Kat�lma Hesaplar�'}>} TOTAL (APKO_MT_TL_BAKIYE))/1000

In case I could not express my problem well, here is the screen shot.

I would be grateful if anyone can help.

brenner_martina — Fri, 18 Mar 2011 08:06:57 GMT

HI,

you can enter after TOTAL for wich dimension(s) you want to get the partial sum, something like:

Sum({} TOTAL <Dimensionfield1, Dimensionfield1> APKO_MT_TL_BAKIYE)

Fri, 18 Mar 2011 12:26:12 GMT

Thanks Martina.

The final formula is below

Sum({1} TOTAL <dimensinfield1, dimensinfield2> APKO_MT_TL_BAKIYE))